hive related questions

[#1]

I have two questions related to hive tables :

1- if I create a hive orc table via Sqoop where on hdfs the related files are created and which parameter is controlling it?

2- can this location be specified at load time ?

[#2]

ok location I found , its in

hive.metastore.warehouse.dir

but still would like to know if I can specify a different location at the time of load.

[#3 · Accepted solution]

Hi @Sami Ahmad Check out the parameters --target-dir and --warehouse-dir that can be used with the sqoop-import command.

There are more details here:

https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_controlling_the_import_process_2