Support Questions

Find answers, ask questions, and share your expertise

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

Explorer

@Frank Lu

@Kit Menke

Please can you help with this one?

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.