[ANNOUNCE] Apache Phoenix 4.9 released

2016-12-01 Thread James Taylor
Apache Phoenix enables OLTP and operational analytics for Apache Hadoop through SQL support using Apache HBase as its backing store and providing integration with other projects in the ecosystem such as Apache Spark, Apache Hive, Apache Pig, Apache Flume, and Apache MapReduce. We're pleased to

how to filter date type column ?

2016-12-01 Thread lk_phoenix
hi,all: I have a table with a column as date type, I try to use it as a where condition: but it was not work. select date,TO_DATE('2015-06-01','-MM-dd') ,date=TO_DATE('2015-06-01','-MM-dd')from FARM_PRODUCT_PRICE limit 100; and ,I can do it like this : select * from