Hive is a beginner. After mysql is configured as a Metabase, a new table named test (idint, namestring) hive & gt; showtables; OKtestTimetaken: 1.759 secondshive & gt; droptabletest; FAILED: errorinmetadata: MetaException (message: javax. jdo. JDODataStoreException: YouhaveanerrorinyourSQL mysqlhive
Hive is a beginner. After mysql is configured as a Metabase, a new table named test (id int, name string) is created)
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.exe c. DDLTask
Then run the show tables command to report the preceding error. please give me some advice !!!