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)

Reply via email to