Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop, mail # user - import SQLSERVER to Hive


+
prabhu k 2012-07-17, 16:26
+
Chalcy 2012-07-17, 18:49
+
prabhu k 2012-07-18, 08:11
+
Jarek Jarcec Cecho 2012-07-18, 08:21
+
prabhu k 2012-07-18, 12:10
+
Jarek Jarcec Cecho 2012-07-18, 12:24
+
prabhu k 2012-07-18, 12:38
Copy link to this message
-
Re: import SQLSERVER to Hive
abhijeet gaikwad 2012-07-19, 02:24
Hi Prabhu,
You may try these :
1. If your client system(from where your sqoop job is running) is not
Windows, you will have to change your authentication type on Sql Server.
2. If your client system is Windows, try integratedSecurity property in
your JDBC connection string; see -
http://msdn.microsoft.com/en-us/library/ms378988(v=sql.105).aspx

Thanks,
Abhijeet
 On 18 Jul 2012 18:09, "prabhu k" <[EMAIL PROTECTED]> wrote:

> I have tried the --username and --password, but still same issue.
>
> While i am installing SQL Server set it was in Windows Authentication
> mode. How can i execute sqoop command with windows
> Authentication mode or else any other alternate solution for this?
>
> Thanks,
> Prabhu.
> On Wed, Jul 18, 2012 at 5:54 PM, Jarek Jarcec Cecho <[EMAIL PROTECTED]>wrote:
>
>> Hi Prabhu,
>> It seems that you've specified your credentials in the URL, however sqoop
>> is expecting them on the command line as well. Would you mind specifying
>> parameters --username and --password to see if it helps?
>>
>> Jarcec
>>
>> On Wed, Jul 18, 2012 at 05:40:57PM +0530, prabhu k wrote:
>> > Hi,
>> >
>> > I have corrected the command like below.but still same issue.
>> >
>> > command:
>> >
>> > $bin/sqoop list-databases --connect
>> > "jdbc:sqlserver://MT-TRNGSQL\SQLEXPRESS:1433;username=abc;password=xyz"
>> >
>> >
>> > sqoop-1.4.1-incubating__hadoop-0.20# bin/sqoop list-databases --connect
>> > "jdbc:sqlserver://MT-TRNGSQL\SQLEXPRESS:1433;username=abc;password=xyz"
>> > Warning: /usr/lib/hbase does not exist! HBase imports will fail.
>> > Please set $HBASE_HOME to the root of your HBase installation.
>> > Warning: $HADOOP_HOME is deprecated.
>> > 12/07/18 17:34:22 INFO manager.SqlManager: Using default fetchSize of
>> 1000
>> > 12/07/18 17:34:22 ERROR manager.CatalogQueryManager: Failed to list
>> > databases
>> > com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user
>> > 'sqlserver'. ClientConnectionId:bb5ea97e-ea07-4e69-89b9-4c675fbe6d64
>> >         at
>> >
>> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
>> >
>> > Please help me on this issue.
>> >
>> > Thanks,
>> > Prabhu.
>> >
>> >
>> > On Wed, Jul 18, 2012 at 1:51 PM, Jarek Jarcec Cecho <[EMAIL PROTECTED]
>> >wrote:
>> >
>> > > Hi Prabhu,
>> > > I believe that your connection URL is not valid. Please consider
>> following
>> > > Microsoft guide:
>> > >
>> > > http://msdn.microsoft.com/en-us/library/ms378428(v=sql.90).aspx
>> > >
>> > > The correct form seems to be:
>> > >
>> > >
>> > >
>> jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
>> > >
>> > > I believe that you used normal slash between server name and instance
>> name
>> > > instead of the backslash, right? You can specify the instance name in
>> the
>> > > property as instanceName=instance1 if you do not want to fight with
>> proper
>> > > escaping of the backslash.
>> > >
>> > > Are you also able to ping MT-TRNGSQL from the box where you're running
>> > > sqoop?
>> > >
>> > > Jarcec
>> > >
>> > > On Wed, Jul 18, 2012 at 01:41:54PM +0530, prabhu k wrote:
>> > > > Thanks for the reply.
>> > > >
>> > > > I have run the below command as per your suggestion.
>> > > >
>> > > > bin/sqoop list-databases --connect
>> > > >
>> "jdbc:sqlserver://MT-TRNGSQL/SQLEXPRESS:1433;username=abc;password=xyz"
>> > > >
>> > > > I am getting following error.
>> > > >
>> > > > sqoop-1.4.1-incubating__hadoop-0.20# bin/sqoop list-databases
>> --connect
>> > > >
>> "jdbc:sqlserver://MT-TRNGSQL/SQLEXPRESS:1433;username=abc;password=xyz"
>> > > > Warning: /usr/lib/hbase does not exist! HBase imports will fail.
>> > > > Please set $HBASE_HOME to the root of your HBase installation.
>> > > > Warning: $HADOOP_HOME is deprecated.
>> > > > 12/07/18 13:33:00 INFO manager.SqlManager: Using default fetchSize
>> of
>> > > 1000
>> > > > 12/07/18 13:33:15 ERROR manager.CatalogQueryManager: Failed to list
>> > > > databases
>> > > > com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP
+
prabhu k 2012-07-19, 10:58
+
Jarek Jarcec Cecho 2012-07-19, 11:06