You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Josh Elser (JIRA)" <ji...@apache.org> on 2018/02/05 23:27:00 UTC
[jira] [Commented] (PHOENIX-4581) phoenix-spark is not pushing
timestamp filter correctly
[ https://issues.apache.org/jira/browse/PHOENIX-4581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16353090#comment-16353090 ]
Josh Elser commented on PHOENIX-4581:
-------------------------------------
[~rmullapudi], what version of Apache Phoenix have you tested this with? If it is not the latest version, have you checked to see if this issue still exists in the latest released version?
Finally, do you have an interest in trying to fix this issue?
> phoenix-spark is not pushing timestamp filter correctly
> -------------------------------------------------------
>
> Key: PHOENIX-4581
> URL: https://issues.apache.org/jira/browse/PHOENIX-4581
> Project: Phoenix
> Issue Type: Bug
> Reporter: Rama Mullapudi
> Priority: Major
>
> phoenix-spark is not pushing timestamp filter correctly
>
> val tblDF = spark.sqlContext.read.format("org.apache.phoenix.spark")
> .option("table", "tablename").option("zkUrl" , "host:2181:/hbase-secure").load()
> .filter(col("CREATE_TMS").gt(lit(current_timestamp()))).show()
>
> Query being sent to phoenix
> select .... FROM tablename WHERE ( "CREATE_TMS" > 2018-02-02 20:06:51.545)
>
> As timstamp string does not have quotes query fails to run.
>
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)