You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "dengpitt (JIRA)" <ji...@apache.org> on 2017/09/04 01:48:00 UTC

[jira] [Closed] (KYLIN-2831) Does kylin do not support underlined fields?

     [ https://issues.apache.org/jira/browse/KYLIN-2831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

dengpitt closed KYLIN-2831.
---------------------------
    Resolution: Fixed

> Does kylin do not support underlined fields?
> --------------------------------------------
>
>                 Key: KYLIN-2831
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2831
>             Project: Kylin
>          Issue Type: Improvement
>          Components: General
>    Affects Versions: v2.0.0
>            Reporter: dengpitt
>             Fix For: Future
>
>
> 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)



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)