New Contributor
Posts: 1
Registered: ‎10-10-2018

Sqoop import to partitioned hive table

Hi All, I want to create a simple hive partitioned table and have a sqoop import command to populate it.

1.Table have say 4 columns, ID, col1, col2, col3.

2. One of the column say col2 is int type and contains values 1 to 10 only.

3. I need to partition table based on col2 column with 1 to 5 value data should be in one partition and rest in another.

4. Once done i need to populate this table with sqoop import from my sql server.  


I have tried many ways but not able to do it. Can anyone please help?