sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "arvind@cloudera.com" <arv...@cloudera.com>
Subject Re: [sqoop-user] Sqoop-with Terradata
Date Mon, 29 Aug 2011 18:58:25 GMT
This may be related to not having the GSS configuration classes in
your classpath. I would suggest you add tdgssconfig.jar to the
classpath and try again.

Thanks,
Arvind

On Mon, Aug 29, 2011 at 11:19 AM, SRINIVAS SURASANI <vasajb@gmail.com> wrote:
> Arvind,
>
> I have subscribed at sqoop-user@incubator.apache.org and posted Question .
> Sorry for the inconvinence from my end, since I'm close to deadline I'm
> taking your valuable time.
>
> sqoop list-tables --driver com.teradata.jdbc.TeraDriver --connect
> jdbc:teradata://PKTD/E1_CMS_WORK --username srini -P
> Iam getting the following error:
> 11/08/29 13:08:03 INFO manager.SqlManager: Using default fetchSize of 1000
> GSSException: Failure unspecified at GSS-API level (Mechanism level:
> UserFile parameter null)
>         at com.teradata.tdgss.jtdgss.TdgssParseXml.<init>(DashoA1*..)
>         at com.teradata.tdgss.jtdgss.TdgssConfigApi.<init>(DashoA1*..)
>         at com.teradata.tdgss.jtdgss.TdgssManager.<init>(DashoA1*..)
>         at com.teradata.tdgss.jtdgss.TdgssManager.getInstance(DashoA1*..)
>         at
> com.teradata.jdbc.jdbc.GenericTeraEncrypt.getGSSM(GenericTeraEncrypt.java:612)
>         at
> com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(GenericTeraEncrypt.java:630)
>         at
> com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid(GenericTeraEncrypt.java:723)
>         at com.teradata.jdbc.AuthMechanism.<init>(AuthMechanism.java:50)
>         at
> com.teradata.jdbc.jdbc.GenericInitDBConfigState.action(GenericInitDBConfigState.java:105)
>         at
> com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:49)
>         at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:199)
>         at
> com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:95)
>         at
> com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:54)
>         at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:217)
>         at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:150)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:185)
>         at
> com.cloudera.sqoop.manager.SqlManager.makeConnection(SqlManager.java:643)
>         at
> com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:51)
>         at
> com.cloudera.sqoop.manager.SqlManager.listTables(SqlManager.java:270)
>         at
> com.cloudera.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49)
>         at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
>         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>         at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
>         at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
>         at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
>         at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
> 11/08/29 13:08:04 ERROR sqoop.Sqoop: Got exception running Sqoop:
> java.lang.NullPointerException
> java.lang.NullPointerException
>         at
> com.teradata.tdgss.jtdgss.TdgssConfigApi.GetMechanisms(DashoA1*..)
>         at com.teradata.tdgss.jtdgss.TdgssManager.<init>(DashoA1*..)
>         at com.teradata.tdgss.jtdgss.TdgssManager.getInstance(DashoA1*..)
>         at
> com.teradata.jdbc.jdbc.GenericTeraEncrypt.getGSSM(GenericTeraEncrypt.java:612)
>         at
> com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(GenericTeraEncrypt.java:630)
>         at
> com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid(GenericTeraEncrypt.java:723)
>         at com.teradata.jdbc.AuthMechanism.<init>(AuthMechanism.java:50)
>         at
> com.teradata.jdbc.jdbc.GenericInitDBConfigState.action(GenericInitDBConfigState.java:105)
>         at
> com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:49)
>         at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:199)
>         at
> com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:95)
>         at
> com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:54)
>         at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:217)
>         at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:150)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:185)
>         at
> com.cloudera.sqoop.manager.SqlManager.makeConnection(SqlManager.java:643)
>         at
> com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:51)
>         at
> com.cloudera.sqoop.manager.SqlManager.listTables(SqlManager.java:270)
>         at
> com.cloudera.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49)
>         at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
>         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>         at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
>         at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
>         at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
>         at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
> Thanks,
> Srini
>
>
>
> On Mon, Aug 29, 2011 at 12:58 PM, arvind@cloudera.com <arvind@cloudera.com>
> wrote:
>>
>> [Please subscribe and respond to sqoop-user@incubator.apache.org]
>>
>> Please use HADOOP_CLASSPATH instead of CLASSPATH. Also, in order to
>> use the generic JDBC connector, you will have to specify the driver
>> class explicitly via the command line option --driver
>> com.teradata.jdbc.TeraDriver.
>>
>> Thanks,
>> Arvind
>>
>> On Mon, Aug 29, 2011 at 9:53 AM, SRINIVAS SURASANI <vasajb@gmail.com>
>> wrote:
>> > Arvind,
>> > I have set the classpath to teradata4.jar [ not placed the teradata4.jar
>> > in
>> > sqoop lib, as I dont have permissions].
>> > I'm getting the following error
>> >
>> > sqoop list-tables --connect jdbc:teradata://PKTD/E1_CMS_WORK --username
>> > srini -P
>> > ERROR: tool.BaseSqoopTool: Got error creating database manager:
>> > java.io.IOexception: No manager for connect string:
>> > jdbc:teradata:///PKTD/E1_CMS_WORK
>> >    at com.cloudera.sqoop.ConnFactory.getManager(ConnFactory.java:119)
>> >    at com.cloudera.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:186)
>> >    ...
>> >    ...
>> > Thanks,
>> > Srini
>> >
>> >
>> >
>> > On Mon, Aug 29, 2011 at 8:52 AM, SRINIVAS SURASANI <vasajb@gmail.com>
>> > wrote:
>> >>
>> >> Thanks-a-lot Arvind.
>> >>
>> >> On Mon, Aug 29, 2011 at 8:45 AM, arvind@cloudera.com
>> >> <arvind@cloudera.com>
>> >> wrote:
>> >>>
>> >>> [Moving the thread to sqoop-user@incubator.apache.org]
>> >>>
>> >>> Hi Srini,
>> >>>
>> >>> You should be able to use the generic JDBC connector to import/export
>> >>> from Teradata. There is also a specialized connector that is available
>> >>> for use with Teradata if you are interested. This connector is not a
>> >>> part of Sqoop and can be obtained from Cloudera by going to:
>> >>>
>> >>> http://www.cloudera.com/partners/connectors/
>> >>>
>> >>> Thanks,
>> >>> Arvind
>> >>>
>> >>> On Mon, Aug 29, 2011 at 8:17 AM, SRINIVAS SURASANI <vasajb@gmail.com>
>> >>> wrote:
>> >>> > I have csv file in hadoop and looking to load into Teradata. I
was
>> >>> > wondering does the sqoop works with Terradata.(with JDBC jar placing
>> >>> > in sqoop lib dir).
>> >>> >
>> >>> > Regards
>> >>> > Srini
>> >>> >
>> >>> > --
>> >>> > NOTE: The mailing list sqoop-user@cloudera.org is deprecated in
>> >>> > favor
>> >>> > of Apache Sqoop mailing list sqoop-user@incubator.apache.org. Please
>> >>> > subscribe to it by sending an email to
>> >>> > incubator-sqoop-user-subscribe@apache.org.
>> >>> >
>> >>>
>> >>> --
>> >>> NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor
>> >>> of
>> >>> Apache Sqoop mailing list sqoop-user@incubator.apache.org. Please
>> >>> subscribe
>> >>> to it by sending an email to
>> >>> incubator-sqoop-user-subscribe@apache.org.
>> >>
>> >
>> > --
>> > NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor of
>> > Apache Sqoop mailing list sqoop-user@incubator.apache.org. Please
>> > subscribe
>> > to it by sending an email to incubator-sqoop-user-subscribe@apache.org.
>> >
>>
>> --
>> NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor of
>> Apache Sqoop mailing list sqoop-user@incubator.apache.org. Please subscribe
>> to it by sending an email to incubator-sqoop-user-subscribe@apache.org.
>
> --
> NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor of
> Apache Sqoop mailing list sqoop-user@incubator.apache.org. Please subscribe
> to it by sending an email to incubator-sqoop-user-subscribe@apache.org.
>

Mime
View raw message