Support Questions
Find answers, ask questions, and share your expertise

I have created a partiton table in hive. The partitoned column is of int type. I need to sqoop the data from sqlserver to hive table.

I have created a partiton table in hive. The partitoned column is of int type. I need to sqoop the data from sqlserver to hive table.

create table department_part (Department_ID int, Department_Name String, Manager_ID int) Partitioned by (Location_ID int)
Row Format delimited
Fields terminated by ','
stored as textfile;