sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Viplaw Jaiswa; (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-2899) Sqoop Import from Hive to Hive
Date Mon, 25 Sep 2017 08:11:02 GMT

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

Viplaw Jaiswa; commented on SQOOP-2899:
---------------------------------------

Hi [~snagalla]


Can you please share the resolution for this issue? I am facing the same issue. Thanks

> Sqoop Import from Hive to Hive
> ------------------------------
>
>                 Key: SQOOP-2899
>                 URL: https://issues.apache.org/jira/browse/SQOOP-2899
>             Project: Sqoop
>          Issue Type: Test
>          Components: hive-integration
>    Affects Versions: 2.0.0
>         Environment: DEV ENV
>            Reporter: srihari
>             Fix For: no-release
>
>
> Can we import tables from Hive DataSource to Hive DataSource using Sqoop?
> Query:
> sqoop import --connect jdbc:hive2://localhost:10000/default --driver org.apache.hive.jdbc.HiveDriver
--username root --password root --table student1 -m 1 --target-dir hdfs://localhost:9000/user/dummy/hive2result
> ERROR
> ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Method
not supported
> java.sql.SQLException: Method not supported
>     at org.apache.hive.jdbc.HiveResultSetMetaData.isSigned(HiveResultSetMetaData.java:141)
>     at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:290)
>     at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240)
>     at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226)
>     at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295)
>     at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1773)
>     at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1578)
>     at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
>     at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478)
>     at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:601)
>     at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
>     at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
>     at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
>     at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
>     at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
>     at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
>  



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message