Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB