Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-2899

Sqoop Import from Hive to Hive

    XMLWordPrintableJSON

    Details

    • Type: Test
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0
    • Fix Version/s: no-release
    • Component/s: hive-integration
    • Labels:
      None
    • Environment:

      DEV ENV

      Description

      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)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              snagalla srihari
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: