My all my tables are name 0x_something
Running
SELECT COUNT(*) FROM 05_kissmetricis
in Impala / HUE fails with:
com.cloudera.impala.common.AnalysisException: Syntax error at: SELECT
COUNT(*) FROM 05_kissmetricis ^ Encountered: INTEGER LITERAL Expected:
IDENTIFIER at
com.cloudera.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:135)
at
com.cloudera.impala.service.Frontend.createExecRequest(Frontend.java:221)
at
com.cloudera.impala.service.JniFrontend.createExecRequest(JniFrontend.java:91)
Caused by: java.lang.Exception: Syntax error at
com.cloudera.impala.analysis.SqlParser.unrecovered_syntax_error(SqlParser.java:1369)
at java_cup.runtime.lr_parser.parse(lr_parser.java:616) at
com.cloudera.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:125)
... 2 more
Is there an escape for the name, I tried ' and []