sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jorge Machado (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-3155) Select oracle Database
Date Thu, 16 Mar 2017 09:03:42 GMT
Jorge Machado created SQOOP-3155:
------------------------------------

             Summary: 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.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message