作者:手机用户2502902345 | 来源:互联网 | 2018-04-26 11:54
小弟初学hive,配置了mysql为元数据库后,然后新建了一个表test(idint,namestring)hive>showtables;OKtestTimetaken:1.759secondshive>droptabletest;FAILED:Errorinmetadata:MetaException(message:javax.jdo.JDODataStoreException:YouhaveanerrorinyourSQL
mysqlhive
小弟初学hive,配置了mysql为元数据库后,然后新建了一个表test(id int,name string)
hive> show tables;
OK
test
Time taken: 1.759 seconds
hive> drop table test;
FAILED: Error in metadata: MetaException(message:javax.jdo.JDODataStoreException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
NestedThrowables:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
然后再执行show tables命令同样报以上错误,求大仙指点!!!