phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rama Mullapudi (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4581) phoenix-spark is not pushing timestamp filter correctly
Date Sat, 03 Feb 2018 01:24:00 GMT
Rama Mullapudi created PHOENIX-4581:
---------------------------------------

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


phoenix-spark is not pushing timestamp filter correctly

 

val tblDF = spark.sqlContext.read.format("org.apache.phoenix.spark").option("table", "ORDER_LINE").option("zkUrl"
, "suhadoomgrqa001,suhadoomgrqa002,suhadoomgrqa003:2181:/hbase-secure").load().filter(col("CREATE_TMS").gt(lit(current_timestamp()))).show()

 

Query being sent to phoenix

select .... FROM ORDER_LINE 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