[ https://issues.apache.org/jira/browse/PHOENIX-3319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15514439#comment-15514439 ]
James Taylor commented on PHOENIX-3319: --------------------------------------- Have you tried this in our calcite branch, [~jleach]? FWIW, this is where we'd add support for any missing syntax. FYI, [~maryannxue]. > TPCH 100G: Query 15 with view cannot parse > ------------------------------------------ > > Key: PHOENIX-3319 > URL: https://issues.apache.org/jira/browse/PHOENIX-3319 > Project: Phoenix > Issue Type: Bug > Reporter: John Leach > > {NOFORMAT} > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/opt/phoenix/apache-phoenix-4.8.0-HBase-1.1-bin/phoenix-4.8.0-HBase-1.1-client.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/usr/hdp/2.4.2.0-258/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > 16/09/13 20:45:42 WARN util.NativeCodeLoader: Unable to load native-hadoop > library for your platform... using builtin-java classes where applicable > 16/09/13 20:45:43 WARN shortcircuit.DomainSocketFactory: The short-circuit > local reads feature cannot be used because libhadoop cannot be loaded. > 1/5 CREATE VIEW REVENUE0 (SUPPLIER_NO INTEGER, TOTAL_REVENUE > DECIMAL(15,2)) AS > SELECT > L_SUPPKEY, > SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT)) > FROM > TPCH.LINEITEM > WHERE > L_SHIPDATE >= TO_DATE('1996-01-01') > AND L_SHIPDATE < TO_DATE('1996-04-01') > GROUP BY > L_SUPPKEY; > Error: ERROR 604 (42P00): Syntax error. Mismatched input. Expecting > "ASTERISK", got "L_SUPPKEY" at line 3, column 1. (state=42P00,code=604) > org.apache.phoenix.exception.PhoenixParserException: ERROR 604 (42P00): > Syntax error. Mismatched input. Expecting "ASTERISK", got "L_SUPPKEY" at line > 3, column 1. > at > org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33) > at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111) > at > org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1280) > at > org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1363) > at > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1434) > at sqlline.Commands.execute(Commands.java:822) > at sqlline.Commands.sql(Commands.java:732) > at sqlline.SqlLine.dispatch(SqlLine.java:807) > at sqlline.SqlLine.runCommands(SqlLine.java:1710) > at sqlline.Commands.run(Commands.java:1285) > 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 > sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36) > at sqlline.SqlLine.dispatch(SqlLine.java:803) > at sqlline.SqlLine.initArgs(SqlLine.java:613) > at sqlline.SqlLine.begin(SqlLine.java:656) > at sqlline.SqlLine.start(SqlLine.java:398) > at sqlline.SqlLine.main(SqlLine.java:292) > Caused by: MismatchedTokenException(99!=13) > at > org.apache.phoenix.parse.PhoenixSQLParser.recoverFromMismatchedToken(PhoenixSQLParser.java:360) > at > org.apache.phoenix.shaded.org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115) > at > org.apache.phoenix.parse.PhoenixSQLParser.create_view_node(PhoenixSQLParser.java:1336) > at > org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:834) > at > org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:508) > at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108) > ... 18 more > Aborting command set because "force" is false and command failed: "CREATE > VIEW REVENUE0 (SUPPLIER_NO INTEGER, TOTAL_REVENUE DECIMAL(15,2)) AS > SELECT > L_SUPPKEY, > SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT)) > FROM > TPCH.LINEITEM > WHERE > L_SHIPDATE >= TO_DATE('1996-01-01') > AND L_SHIPDATE < TO_DATE('1996-04-01') > GROUP BY > L_SUPPKEY;" > Closing: org.apache.phoenix.jdbc.PhoenixConnection > {NOFORMAT} -- This message was sent by Atlassian JIRA (v6.3.4#6332)