UNNEST Results to SYNTAX ERROR

2017-03-13 Thread Bernard Quizon
Hi, I've tried using phoenix-4.6.0-Hbase-1.1 and phoenix-4.7.0-Hbase-1.1 to test if UNNEST is now available but it returns a syntax error. Both are resulting to this error sqlline version 1.1.8 0: jdbc:phoenix:localhost> SELECT t.k FROM UNNEST((SELECT k FROM a)) AS t(k); Error: ERROR 601 (42P00

Comprehensive Guide for EXPLAIN

2016-09-26 Thread Bernard Quizon
Hi, I know explain statement results are relatively easy to understand but is there a comprehensive guide for it? 0: jdbc:phoenix:localhost> explain select count(1) from test.table where insert_ts > now() - 30; *+--+* *| ** PLAN