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命令同样报以上错误，求大仙指点！！！