Error creating External table on Sequence files



Hello all,

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

sqoop import --connect jdbc:mysql:// --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 WritableName can’t load class: departments

Kindly advise where am I going wrong ?