Member since
11-21-2017
1
Post
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
7752 | 11-22-2017 02:23 PM |
11-22-2017
02:23 PM
@Todd Wilson Got the same error ,but followed these steps and import the data successfully. step 1:
--------- export HADOOP_CLASSPATH=/usr/local/hive/lib/*
export LIB_JARS=/usr/lib/tdch/1.4/lib/terajdbc4.jar,/usr/local/hive/lib/hive-metastore-0.13.1-SNAPSHOT.jar,/usr/local/hive/lib/hive-exec-0.13.1-SNAPSHOT.jar,/usr/local/hive/lib/hive-cli-0.13.1-SNAPSHOT.jar,/usr/local/hive/lib/jdo-api-3.0.1.jar,/usr/local/hive/lib/libfb303-0.9.0.jar,/usr/local/hive/lib/libthrift-0.9.0.jar,/usr/local/hive/lib/antlr-runtime-3.4.jar,/usr/local/hive/lib/datanucleus-core-3.2.10.jar,/usr/local/hive/lib/datanucleus-api-jdo-3.2.6.jar,/usr/local/hive/lib/datanucleus-rdbms-3.2.9.jar step 2:
--------- CREATE TABLE `test`(
`colum1` int,
`colum2` int,
`colum3` string
)
STORED AS ORC; step 3:
--------- hadoop jar /usr/lib/tdch/1.4/lib/teradata-connector-1.4.4.jar \
com.teradata.connector.common.tool.ConnectorImportTool \
-libjars $LIB_JARS \
-url jdbc:teradata://<DB_NAME>/database=SCHEMA_NAME \
-username <username> \
-password <password> \
-jobtype hive -hiveconf 'file:///etc/hive/conf/hive-site.xml' \
-fileformat orcfile \
-sourcetable test \
-targetdatabase default \
-targettable test \
-nummappers 16 \
-method split.by.hash \
-splitbycolumn colum1
... View more