[SQOOP-938] Sqoop: Provide CLI arguments to pass custom Hive CREATE TABLE command while importing using incremental imports.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.1-incubating
• Component/s: hive-integration
• Labels: sqoop

Environment

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

• Assignee: Unassigned
• Reporter: Suresh Srinivasan
• Created: 08/Mar/13 07:38
• Updated: 15/Jul/13 05:03

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.

Issue Links

• links to: DISTRO-465