[ 
https://issues.apache.org/jira/browse/PHOENIX-4581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rama Mullapudi updated PHOENIX-4581:
------------------------------------
    Description: 
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.

 

 

 

  was:
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 ORDER_LINE WHERE ( "CREATE_TMS" > 2018-02-02 20:06:51.545)

 

As timstamp string does not have quotes query fails to run.

 

 

 


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

Reply via email to