question Re: spcify location in create-hcatalog-table doing sqoop import in Archives of Support Questions (Read Only)

spcify location in create-hcatalog-table doing sqoop import

simon_jespersen — Tue, 21 Nov 2017 23:19:26 GMT

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"

Re: spcify location in create-hcatalog-table doing sqoop import

asirna — Tue, 21 Nov 2017 23:31:04 GMT

@Simon Jespersen,

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

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

Thanks,

Aditya

Re: spcify location in create-hcatalog-table doing sqoop import

simon_jespersen — Wed, 22 Nov 2017 18:38:32 GMT

Thanks it worked

/Simon