[jira] [Created] (SQOOP-3215) Sqoop create hive table to support other formats(avro,parquet)

["Nitish Khanna (JIRA)" <ji...@apache.org>]

Nitish Khanna created SQOOP-3215:
------------------------------------

             Summary: Sqoop create hive table to support other formats(avro,parquet)
                 Key: SQOOP-3215
                 URL: https://issues.apache.org/jira/browse/SQOOP-3215
             Project: Sqoop
          Issue Type: Improvement
    Affects Versions: 1.4.6
            Reporter: Nitish Khanna


Hi Team,

Sqoop doesn't support any other format apart from text format when we make use of "create-hive-table".

It would be great if sqoop could create avro,parquet etc format table(schema only).

I tried below command to create avro format table in hive.

[root@host-10-17-81-13 ~]# sqoop create-hive-table --connect $MYCONN --username $MYUSER --password $MYPSWD --table test_table --hive-table test_table_avro --as-avrodatafile
Warning: /opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/07/26 21:23:38 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.8.3
17/07/26 21:23:38 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
17/07/26 21:23:38 ERROR tool.BaseSqoopTool: Error parsing arguments for create-hive-table:
17/07/26 21:23:38 ERROR tool.BaseSqoopTool: Unrecognized argument: --as-avrodatafile

Please correct me if i missed anything.

Regards
Nitish Khanna



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