Details
-
Improvement
-
Status: Resolved
-
Minor
-
Resolution: Won't Fix
-
1.4.6
-
None
-
None
Description
Hi Guys,
So I was trying to import some data from a oracle database and after getting a lot of errors this is my connection string:
sqoop import -connect "jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=xxxxx)(port=6778))(connect_data=(service_name=xxxx)))" -m 1 --username test1-password supersafe --table SID.TABLE_NAME --hive-import --hive-overwrite --hive-database test1
The export works without any Problem. When sqoop tries to create a table
it say that it cannot create a table with SID.TABLE_NAME unter the database test1. I think it would be nice that the sqoop import --table ignores everything before "." on the parameter.
Error: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Invalid table name test1.SID.TABLE_NAME