phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-5102) Filtering on DATE types throws an exception using the spark connector
Date Thu, 17 Jan 2019 00:00:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-5102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16744543#comment-16744543
] 

Hudson commented on PHOENIX-5102:
---------------------------------

ABORTED: Integrated in Jenkins build Phoenix-4.x-HBase-1.4 #45 (See [https://builds.apache.org/job/Phoenix-4.x-HBase-1.4/45/])
PHOENIX-5102 Filtering on DATE types throws an exception using the spark (tdsilva: rev 8273cc11d5465efa60dc4774adf5339655cec1eb)
* (edit) phoenix-spark/src/it/scala/org/apache/phoenix/spark/PhoenixSparkIT.scala
* (edit) phoenix-spark/src/main/scala/org/apache/phoenix/spark/FilterExpressionCompiler.scala


> Filtering on DATE types throws an exception using the spark connector
> ---------------------------------------------------------------------
>
>                 Key: PHOENIX-5102
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5102
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Thomas D'Silva
>            Assignee: Thomas D'Silva
>            Priority: Major
>             Fix For: connectors-1.0.0
>
>
> SELECT * FROM DATE_TEST WHERE COL1 > TO_DATE('1990-01-01 00:00:01', 'yyyy-MM-dd HH:mm:ss')
> Filtering on a DATE column fails with the following exception:
> {code}
> Caused by: org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type mismatch.
DATE and BIGINT for "COL1" > 1988
> 	at org.apache.phoenix.schema.TypeMismatchException.newException(TypeMismatchException.java:53)
> 	at org.apache.phoenix.expression.ComparisonExpression.create(ComparisonExpression.java:149)
> 	at org.apache.phoenix.compile.ExpressionCompiler.visitLeave(ExpressionCompiler.java:234)
> 	at org.apache.phoenix.compile.ExpressionCompiler.visitLeave(ExpressionCompiler.java:146)
> 	at org.apache.phoenix.parse.ComparisonParseNode.accept(ComparisonParseNode.java:47)
> 	at org.apache.phoenix.parse.CompoundParseNode.acceptChildren(CompoundParseNode.java:64)
> 	at org.apache.phoenix.parse.AndParseNode.accept(AndParseNode.java:47)
> 	at org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:138)
> 	at org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:108)
> 	at org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:559)
> 	at org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:510)
> 	at org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:195)
> 	at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:155)
> 	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:490)
> 	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:456)
> 	at org.apache.phoenix.jdbc.PhoenixStatement.compileQuery(PhoenixStatement.java:1745)
> 	at org.apache.phoenix.jdbc.PhoenixStatement.compileQuery(PhoenixStatement.java:1738)
> 	at org.apache.phoenix.jdbc.PhoenixStatement.optimizeQuery(PhoenixStatement.java:1732)
> 	at org.apache.phoenix.spark.datasource.v2.reader.PhoenixDataSourceReader.planInputPartitions(PhoenixDataSourceReader.java:137)
> 	... 94 more
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message