在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上查不了而已。