mysql 5.7的drop insert都不好使
来源：8-5 使用Hive完成统计分析功能
慕虎7937911
2019-09-28
hive> insert overwrite table track_info_province_stat partition(day='2013-07-21') select province,count(*) as cnt from track_info where day='2013-07-21' group by province;
FAILED: SemanticException Unable to fetch table track_info. 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
写回答
1回答
-
Michael_PK
2019-09-28
SemanticException Unable to fetch table track_info. You have an error in your SQL syntax。让你找hive日志，找到了吗？
00
相似问题
Hive To Mysql
回答 1
hive启动问题
回答 2