Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unable to run sqoop import from teradata to hive table

Unable to run sqoop import from teradata to hive table

Explorer

When I Sqoop data from Teradata to Hive, I am running the command

sqoop import --connect jdbc:teradata://link/database=db --connection-manager org.apache.sqoop.teradata.TeradataConnManager --username user -P --table table --hive-import -m 1

and getting the following error-

18/03/21 14:13:50 INFO teradata.TeradataSqoopImportHelper: Setting source table to : table
18/03/21 14:13:51 INFO common.ConnectorPlugin: load plugins in jar:file:/usr/hdp/current/hadoop/lib/teradata-connector-1.5.2-hadoop2.jar!/teradata.connector.plugins.xml
18/03/21 14:13:52 INFO teradata.TeradataSqoopImportHelper: Teradata import job completed with exit code 1 Exception in thread "main" java.lang.NoSuchFieldError: METASTORE_BATCH_RETRIEVE_OBJECTS_MAX at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:221) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:209) at com.teradata.connector.hive.utils.HiveUtils.isHiveOutputTablePartitioned(HiveUtils.java:1140) at com.teradata.connector.common.tool.ConfigurationMappingUtils.importConfigurationMapping(ConfigurationMappingUtils.java:321) at org.apache.sqoop.teradata.TeradataSqoopImportHelper.runJob(TeradataSqoopImportHelper.java:364) at org.apache.sqoop.teradata.TeradataConnManager.importTable(TeradataConnManager.java:505) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:507)

Any help is highly appreciated and thanks in advance..

2 REPLIES 2

Re: Unable to run sqoop import from teradata to hive table

Explorer

@Frank Lu

@Kit Menke

Please can you help with this one?

Highlighted

Re: Unable to run sqoop import from teradata to hive table

Cloudera Employee

@Vani Deeppak

Have a look at this article: https://community.hortonworks.com/articles/53531/importing-data-from-teradata-into-hive.html

it has the link(s) for Sqoop documentation and also talks about how to use it. Hope this helps.

Don't have an account?
Coming from Hortonworks? Activate your account here