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