Hive import running long and hanged

hive
hiveserver

#1

CREATE TABLE orders(
order_id int,
order_date DATE,
order_customer_id INT,
order_status STRING)
;

sqoop import
–connect jdbc:mysql://ms.itversity.com:3306/retail_db
–username retail_user
–password itversity
–num-mappers 2
–hive-import
–hive-database db_shiba
–hive-table orders
–target-dir /apps/hive/warehouse/db_shiba.db/orders
–delete-target-dir
–split-by order_id
–query “select * from orders where order_date like ‘2013%’ and $CONDITIONS”

This import is getting hanged. Let me know what’s wrong here.


#2

Can you try and let us know?