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

Switch to Plain View
Sqoop, mail # user - Error while importing from Teradata to HDFS


+
DIPESH KUMAR SINGH 2012-04-22, 05:21
+
Cheolsoo Park 2012-04-22, 09:31
+
DIPESH KUMAR SINGH 2012-04-23, 17:32
+
Cheolsoo Park 2012-04-23, 17:43
+
DIPESH KUMAR SINGH 2012-04-23, 18:01
Copy link to this message
-
Re: Error while importing from Teradata to HDFS
Anirudh 2012-04-23, 18:17
Dipesh,

It would be ideal if the jdbc driver is placed under Sqoop/lib as other
users too would be able to leverage the same. But given your situation, use
the -libjars option to point to the driver.

Hope this helps.

Thanks,
Anirudh

On Mon, Apr 23, 2012 at 11:01 AM, DIPESH KUMAR SINGH
<[EMAIL PROTECTED]>wrote:

> Hi Cheolsoo,
>
> Yeah, I know. I was looking for an alternative way by which we could tell
> Sqoop to load jars from a location different than Sqoop/lib. I was looking
> for such an alternative because currently i don't have
> permissions to add jars in Sqoop/lib, though i have initiated the process.
>
> Thanks & Regards,
>
> Dipesh
>
>
>
> On Mon, Apr 23, 2012 at 11:13 PM, Cheolsoo Park <[EMAIL PROTECTED]>wrote:
>
>> Hi Dipesh,
>>
>> 12/04/23 01:02:42 ERROR sqoop.Sqoop: Got exception running Sqoop:
>>> java.lang.RuntimeException: Could not load db driver class:
>>> com.teradata.jdbc.TeraDriver
>>>
>> java.lang.RuntimeException: Could not load db driver class:
>>> com.teradata.jdbc.TeraDrive
>>
>>
>> Your Teradata jdbc jar is not found by Sqoop. The easiest way to fix it
>> is to put *terajdbc4.jar* and *tdgssconfig.jar* in */usr/lib/sqoop/lib*.
>>
>> Thanks,
>> Cheolsoo
>>
>> On Mon, Apr 23, 2012 at 10:32 AM, DIPESH KUMAR SINGH <
>> [EMAIL PROTECTED]> wrote:
>>
>>> Hi Cheolsoo,
>>>
>>> As you suggested, I tried after removing "TeraDriver" line from
>>> connectors file but that didn't worked
>>> too. Please help..!!
>>>
>>> Here is the stack trace:
>>>
>>>>
>>>> 12/04/23 01:02:35 DEBUG tool.BaseSqoopTool: Enabled debug logging.
>>>>
>>> Enter password:
>>>>
>>> 12/04/23 01:02:42 DEBUG util.ClassLoaderStack: Checking for existing
>>>> class: com.cloudera.sqoop.manager.TeradataManagerFactory
>>>>
>>> 12/04/23 01:02:42 DEBUG util.ClassLoaderStack: Attempting to load jar
>>>> through URL:
>>>> jar:file:///ms/user/a/sqoop-user/Sqoop/sqoop-td-connector-1.0.5.jar!/
>>>>
>>> 12/04/23 01:02:42 DEBUG util.ClassLoaderStack: Previous classloader is
>>>> java.net.URLClassLoader@27b15692
>>>>
>>> 12/04/23 01:02:42 DEBUG util.ClassLoaderStack: Testing class in jar:
>>>> com.cloudera.sqoop.manager.TeradataManagerFactory
>>>>
>>> 12/04/23 01:02:42 DEBUG util.ClassLoaderStack: Loaded jar into current
>>>> JVM: jar:file:///ms/user/a/sqoop-user/Sqoop/sqoop-td-connector-1.0.5.jar!/
>>>>
>>> 12/04/23 01:02:42 DEBUG util.ClassLoaderStack: Added classloader for jar
>>>> /ms/user/a/sqoop-user/Sqoop/sqoop-td-connector-1.0.5.jar:
>>>> java.net.FactoryURLClassLoader@19e3cd51
>>>>
>>> 12/04/23 01:02:42 DEBUG sqoop.ConnFactory: Added factory
>>>> com.cloudera.sqoop.manager.TeradataManagerFactory in jar
>>>> /ms/user/a/sqoop-user/Sqoop/sqoop-td-connector-1.0.5.jar specified by
>>>> /ms/user/a/sqoop-user/Sqoop/conf/managers.d/connectors
>>>>
>>> 12/04/23 01:02:42 DEBUG sqoop.ConnFactory: Loaded manager factory:
>>>> com.cloudera.sqoop.manager.TeradataManagerFactory
>>>>
>>> 12/04/23 01:02:42 DEBUG sqoop.ConnFactory: Loaded manager factory:
>>>> com.cloudera.sqoop.manager.DefaultManagerFactory
>>>>
>>> 12/04/23 01:02:42 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
>>>> com.cloudera.sqoop.manager.TeradataManagerFactory
>>>>
>>> 12/04/23 01:02:42 DEBUG manager.TeradataManagerFactory: Trying with
>>>> scheme: jdbc:teradata:
>>>>
>>> 12/04/23 01:02:42 INFO manager.SqlManager: Using default fetchSize of
>>>> 1000
>>>>
>>> 12/04/23 01:02:42 DEBUG sqoop.ConnFactory: Instantiated ConnManager
>>>> com.cloudera.sqoop.teradata.TeradataManager@220ca470
>>>>
>>> 12/04/23 01:02:42 INFO tool.CodeGenTool: Beginning code generation
>>>>
>>> 12/04/23 01:02:42 ERROR sqoop.Sqoop: Got exception running Sqoop:
>>>> java.lang.RuntimeException: Could not load db driver class:
>>>> com.teradata.jdbc.TeraDriver
>>>>
>>> java.lang.RuntimeException: Could not load db driver class:
>>>> com.teradata.jdbc.TeraDriver
>>>>
>>>  at
>>>> com.cloudera.sqoop.manager.SqlManager.makeConnection(SqlManager.java:634)
>>>>
>>> at
>>>> com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:51)
+
Cheolsoo Park 2012-04-23, 18:57
+
Technical Anirudh 2012-04-23, 19:35