spcify location in create-hcatalog-table doing sqoop import

[#1]

Hi,

Im doing sqoop import of msybase database tables into orc hive tables, can i specify the location my orc file is created in this cmd

i have tried --hcatalog-home /bla/bla and --location /bla/bla it wont work

#!/bin/bash
sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--driver net.sourceforge.jtds.jdbc.Driver \
--connect jdbc:jtds:sybase://10.9.179.5:4000/db1 \
--username foo \
--P \
--query "select  * from table1 where CAST(csrp_koersel_dto as DATE)>'2017-11-18' AND \$CONDITIONS" \
         --split-by cpr_nr  --hcatalog-database default --hcatalog-table sqoop_hccatalog_example_new1 --create-hcatalog-table --hcatalog-storage-stanza "stored as orcfile"

[#2 · Accepted solution]

@Simon Jespersen,

Can you try appending location as well in --hcatalog-storage-stanza

--hcatalog-storage-stanza "stored as orcfile LOCATION /bla/bla"

Thanks,

Aditya

[#3]

Thanks it worked

/Simon