Szabolcs Vasas commented on SQOOP-3155:

Hi [~jomach],

The command I have posted earlier should work without patching.


> 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 

This message was sent by Atlassian JIRA

Reply via email to