Reply
New Contributor
Posts: 1
Registered: ‎12-13-2017

sqoop syntax to import to kudu table

[ Edited ]

We'd like to test Kudu and need to import data. Sqoop seems like the correct choice. I find references that you can import to Kudu but no specifics. Is there any way to import to Kudu using Sqoop?

Highlighted
Cloudera Employee
Posts: 815
Registered: ‎03-23-2015

Re: sqoop syntax to import to kudu table

This is being worked via:

https://issues.apache.org/jira/browse/SQOOP-2903
https://issues.apache.org/jira/browse/SQOOP-3148

So currently Sqoop does not support Kudu yet. You can import to HDFS and then use Impala to write data to Kudu.
Cloudera Employee
Posts: 40
Registered: ‎01-07-2019

Re: sqoop syntax to import to kudu table

I have seen people create Kudu connectors for Sqoop, however these are not supported by Cloudera. The main reason is likely that Sqoop is fundamentally designed for writing to HDFS.

If you are limited to CDH you could first use sqoop to get the data into your cluster, and then do an extra step to bring it to Kudu.

However, since CDF has been released we have now got standard NiFi processors for reading from a database and writing to Kudu. Hence this would be my recommended solution.