phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Leach (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-3319) TPCH 100G: Query 15 with view cannot parse
Date Thu, 22 Sep 2016 20:31:20 GMT
John Leach created PHOENIX-3319:
-----------------------------------

             Summary: 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)

Mime
View raw message