Monday, July 3, 2017

SQOOP Import to HIVE & HIVE UDF.

Sqoop import to the HIVE.

sqoop import --connect "jdbc:mysql://nn01.itversity.com:3306/retail_db" --username retail_dba --password itversity --split-by order_id --table orders --target-dir /user/venkata_d/CCA_Prep/hive/orders --fields-terminated-by "," --hive-import --create-hive-table --hive-table venkat_cca_prep.orders

add jar hdfs:///user/venkata_d/hive_udf_supporting_jars/JavaCodeWorks-1.0-SNAPSHOT.jar;

0 comments:

Post a Comment