[
https://issues.apache.org/jira/browse/SQOOP-3155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15932290#comment-15932290
]
Szabolcs Vasas commented on SQOOP-3155:
---------------------------------------
Hi [~jomach],
The command I have posted earlier should work without patching.
Szabolcs
> Select oracle Database
> ----------------------
>
> Key: SQOOP-3155
> URL: https://issues.apache.org/jira/browse/SQOOP-3155
> Project: Sqoop
> Issue Type: Improvement
> Components: connectors
> Affects Versions: 1.4.6
> Reporter: Jorge Machado
> Priority: Minor
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
