Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-938

Sqoop: Provide CLI arguments to pass custom Hive CREATE TABLE command while importing using incremental imports.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.4.1-incubating
    • None
    • hive-integration
    • CentOS release 6.3 (final) with cloudera hadoop-cdh-4.1.3
      Oozie version-3.2.0
      Java version-1.6.0_24
      Sqoop version - 1.4.1
      Hive Version - 0.9.0

    Description

      We are not able to provide custom hive CREATE TABLE command while executing sqoop import (from MySql) into Hive using incremental imports feature. Sqoop automatically generate's a Hive script containing a CREATE TABLE operation defining our columns using Hive's types.

      Note: By default, Hive tables are created with underlying storage unit as HDFS. To change the underlying storage unit, it is good to pass custom Hive CREATE TABLE command to the Sqoop incremental import command.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sureeceg Suresh Srinivasan
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: