sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Szabolcs Vasas (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-3155) Select oracle Database
Date Thu, 16 Mar 2017 15:42:41 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-3155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15928296#comment-15928296

Szabolcs Vasas commented on SQOOP-3155:

Hi [~jomach],

I think the problem is that Hive does not support table names containing '.' try overriding
the hive table name with the --hive-table option:

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 --hive-table TABLE_NAME


> 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
> 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

View raw message