phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Josh Elser (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4581) phoenix-spark is not pushing timestamp filter correctly
Date Mon, 05 Feb 2018 23:27:00 GMT

    [ 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)

Mime
View raw message