beeline通过hive连接mysql，建表的错误

1. 终端输入

beeline -u jdbc:hive2://sam02:10000 -n root

2. 输入以下建表语句

CREATE EXTERNAL TABLE if not exists news (
    project string,
    ctime string,
    content struct>
)
PARTITIONED BY(logday string)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
LOCATION '/sources/news/';

3. 出错结果

Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.openx.data.jsonserde.JsonSerDe (state=08S01,code=1)

4. 解决方法

4.1终端输入

beeline -u jdbc:hive2://sam02:10000 -n root -i ~/.hiverc