Uploaded image for project: 'CDH (READ-ONLY)'
  1. CDH (READ-ONLY)
  2. DISTRO-465

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

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: CDH4.1.3
    • Fix Version/s: None
    • Component/s: Hive, Sqoop
    • Labels:
    • Environment:
      Cloudera Hadoop - CDH-4.1.3
      Sqoop - 1.4.1
      Hive - 0.9.0
      Java - 1.6

      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

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: