problems_impala
1 impala-shell中执行语句报错
impala-shell -i cdh02
create external table ... #执行该语句后报错,如下:
ImpalaRuntimeException: Error making 'dropTable' RPC to Hive Metastore:
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
原因:impala进程出问题了,执行任何语句都报错。
解决方法:重启impala ,没用,重启电脑然后启动impala, 解决。
注:重启impala的语句:
主节点上:
service impala-catalog restart
service impala-state-store restart
从节点上:
service impala-server restart