Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-2831

Does kylin do not support underlined fields?

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v2.0.0
    • Fix Version/s: Future
    • Component/s: Others
    • Labels:
      None

      Description

      When I choose the dimension contains _uid will report the following error:

      17/08/31 10:43:35 [main]: INFO parse.ParseDriver: Parsing command:
      INSERT OVERWRITE TABLE kylin_intermediate_uc_3cf963bd_53ca_47d6_ae0c_a71b364fc558 SELECT
      USER_GAMBLING._UID
      ,USER_GAMBLING.BID
      FROM DEFAULT.USER_GAMBLING as USER_GAMBLING
      WHERE (USER_GAMBLING.TM >= 20170831 AND USER_GAMBLING.TM < 20170831)

      NoViableAltException(13@[127:1: selectItem : ( ( tableAllColumns )=> tableAllColumns -> ^( TOK_SELEXPR tableAllColumns ) | ( expression ( ( ( KW_AS )? identifier ) | ( KW_AS LPAREN identifier ( COMMA identifier )* RPAREN ) )? ) -> ^( TOK_SELEXPR expression ( identifier )* ) );])
      at org.apache.hadoop.hive.ql.parse.HiveParser_SelectClauseParser$DFA17.specialStateTransition(HiveParser_SelectClauseParser.java:11835)
      at org.antlr.runtime.DFA.predict(DFA.java:80)
      at org.apache.hadoop.hive.ql.parse.HiveParser_SelectClauseParser.selectItem(HiveParser_SelectClauseParser.java:2853)
      at org.apache.hadoop.hive.ql.parse.HiveParser_SelectClauseParser.selectList(HiveParser_SelectClauseParser.java:1373)
      at org.apache.hadoop.hive.ql.parse.HiveParser_SelectClauseParser.selectClause(HiveParser_SelectClauseParser.java:1128)
      at org.apache.hadoop.hive.ql.parse.HiveParser.selectClause(HiveParser.java:45827)
      at org.apache.hadoop.hive.ql.parse.HiveParser.selectStatement(HiveParser.java:41495)
      at org.apache.hadoop.hive.ql.parse.HiveParser.regularBody(HiveParser.java:41230)
      at org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpressionBody(HiveParser.java:40413)
      at org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpression(HiveParser.java:40283)
      at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1590)
      at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1109)
      at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:202)
      at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
      at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:396)
      at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:308)
      at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1122)
      at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1170)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1059)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1049)
      at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:213)
      at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:165)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:376)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:311)
      at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:708)
      at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
      at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
      FAILED: ParseException line 3:14 cannot recognize input near 'USER_GAMBLING' '.' '_UID' in selection target
      17/08/31 10:43:35 [main]: ERROR ql.Driver: FAILED: ParseException line 3:14 cannot recognize input near 'USER_GAMBLING' '.' '_UID' in selection target
      org.apache.hadoop.hive.ql.parse.ParseException: line 3:14 cannot recognize input near 'USER_GAMBLING' '.' '_UID' in selection target
      at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:205)
      at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
      at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:396)
      at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:308)
      at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1122)
      at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1170)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1059)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1049)
      at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:213)
      at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:165)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:376)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:311)
      at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:708)
      at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
      at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              pengpd dengpitt
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: