FAQ
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 []

Search Discussions

  • Marcel Kornacker at Mar 29, 2013 at 12:44 am
    There is no way to do that at the moment.

    I created a jira to track this: https://issues.cloudera.org/browse/IMPALA-170

    We'll try to get a fix into the next beta refresh, to be released end
    of next week.
    On Thu, Mar 28, 2013 at 5:36 PM, Jan Mechtel wrote:
    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 []

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedMar 29, '13 at 12:36a
activeMar 29, '13 at 12:44a
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Marcel Kornacker: 1 post Jan Mechtel: 1 post

People

Translate

site design / logo © 2022 Grokbase