Support Questions

Find answers, ask questions, and share your expertise

Unable to run sqoop import from teradata to hive table


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>( at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>( at com.teradata.connector.hive.utils.HiveUtils.isHiveOutputTablePartitioned( at com.teradata.connector.common.tool.ConfigurationMappingUtils.importConfigurationMapping( at org.apache.sqoop.teradata.TeradataSqoopImportHelper.runJob( at org.apache.sqoop.teradata.TeradataConnManager.importTable( at org.apache.sqoop.tool.ImportTool.importTable(

Any help is highly appreciated and thanks in advance..



@Frank Lu

@Kit Menke

Please can you help with this one?

Cloudera Employee

@Vani Deeppak

Have a look at this article:

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