Error creating External table on Sequence files

hive

#1

Hello all,

Step1 : I have imported departments data into hdfs using sqoop.

sqoop import --connect jdbc:mysql://nn01.itversity.com:3306/retail_db --username retail_dba --password itversity --table departments --as-sequencefile --target-dir ‘/user/sbhupa
thiraju86/dept_seq’ ;

Step 2: Creating external table on the path ‘/user/sbhupathiraju86/dept_seq’ and here i am facing the error.

create external table dept_seq (id string, name string)
> row format delimited
> fields terminated by ‘,’
> stored as sequencefile
> location ‘/user/sbhupathiraju86/dept_seq’ ;

Error: Failed with exception java.io.IOException:java.lang.RuntimeException: java.io.IOException: WritableName can’t load class: departments

Kindly advise where am I going wrong ?