AnsweredAssumed Answered

Sqoop MapR-DB output, bulkload doesn't work

Question asked by metaruslan on May 24, 2016
Latest reply on Jun 26, 2016 by snayeem

I'm using MapR 4.1, Sqoop 1.4.6. I can successfully run a sqoop import with free-form sql query and without bulkload:

 

sqoop import --query 'SELECT COLUMN1, COLUMN2 FROM MY_TABLE WHERE $CONDITIONS' \
--split-by COLUMN1  \
--hbase-row-key COLUMN1 --hbase-table /sqoop-test4 --column-family 1 --hbase-create-table \
--connect jdbc:oracle:thin:@localhost:1521:XE --target-dir sqoop_test \
--username my_user --password my_password

 

but when I add the --hbase-bulkload I get an error:

 

Error: java.io.IOException: bulkLoaderClose() on '/local/sqoop-test5'
failed with error: Function not implemented (38).

 

Does it mean that the bulkload sqoop feature is not supported for MapR-DB tables? I'm aware I could Sqoop from Oracle to HDFS tsv file and then use a bulkload tool (ImportTsv) from the tsv file to MapR-DB, but I'm trying to avoid the HDFS step and load directly from Oracle to MapR-DB, preferably with the bulkload sqoop feature enabled.

 

Thanks in advance!

Ruslan

Outcomes