impala:AnalysisException Syntax error
程序员文章站
2022-07-11 08:25:55
...
在impala-shell中use database出错:
[mr2:21000] > use int;
Query: use int
ERROR: AnalysisException: Syntax error in line 1:
use int
^
Encountered: INTEGER
Expected: DEFAULT, IDENTIFIER
CAUSED BY: Exception: Syntax error
试了一下其他库,是能够进行use的,原来是因为库名是关键词,所以,查不了。
试了一下价引号:
[mr2:21000] > use "int";
Query: use "int"
ERROR: AnalysisException: Syntax error in line 1:
use "int"
^
Encountered: STRING LITERAL
Expected: DEFAULT, IDENTIFIER
CAUSED BY: Exception: Syntax error
[mr2:21000] > use 'int';
Query: use 'int'
ERROR: AnalysisException: Syntax error in line 1:
use 'int'
^
Encountered: STRING LITERAL
Expected: DEFAULT, IDENTIFIER
CAUSED BY: Exception: Syntax error
还是没有作用,我们在建库的时候慎用关键词,但是并不影响在hive上的使用查询,只是在impala-shell上查不了而已。
下一篇: 切换用户
推荐阅读
-
PHP错误Parse error: syntax error, unexpected end of file in test.php on line 12解决方法
-
PHP异常Parse error: syntax error, unexpected T_VAR错误解决方法
-
PHP错误Parse error: syntax error, unexpected end of file in test.php on line 12解决方法
-
flume使用kafka sink报错syntax error或kafka channel输出数据抬头有乱码/奇怪字符
-
Command line option syntax error问题的解决方法小结
-
thinkphp6安装报错,composer install tp6 报错 Parse error: syntax error
-
pymysql.err.ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that co
-
mybatis java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax;
-
PHP Parse Error: syntax error, unexpected $end 错误的解决办法
-
JSON解析:com.alibaba.fastjson.JSONException: syntax error, expect {, actual string, pos xxx,...