Hi Zheng, Could you please verify my sql;
add jar CREATE TABLE IF NOT EXISTS PARSE_XML( column1 String, column2 String ) STORED AS INPUTFORMAT 'org.apache.mahout.classifier.bayes.XmlInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' I was thinking that i could add some custom jar on top , not sure though. Ankit