Re: Cannot select data from a system table

2016-08-21 Thread Ted Yu
Looks like tokens in phoenix-core/src/main/antlr3/PhoenixSQL.g would give us good idea. Experts please correct me if I am wrong. On Sun, Aug 21, 2016 at 7:21 AM, Aaron Molitor wrote: > Thanks, Ankit, that worked. > > And on the heels of Ted's question... Are the

Re: Cannot select data from a system table

2016-08-21 Thread Aaron Molitor
Thanks, Ankit, that worked. And on the heels of Ted's question... Are the reserved words documented (even if just a list) somewhere, I've been looking at this page: http://phoenix.apache.org/language/index.html -- it feels like where I should find a list like that, but I don't see it

Re: Cannot select data from a system table

2016-08-21 Thread Ted Yu
Ankit: Is this documented somewhere ? Thanks On Sun, Aug 21, 2016 at 6:07 AM, Ankit Singhal wrote: > Aaron, > > you can escape check for reserved keyword with double quotes "" > > SELECT * FROM SYSTEM."FUNCTION" > > Regards, > Ankit Singhal > > On Fri, Aug 19, 2016 at

Re: Cannot select data from a system table

2016-08-21 Thread Ankit Singhal
Aaron, you can escape check for reserved keyword with double quotes "" SELECT * FROM SYSTEM."FUNCTION" Regards, Ankit Singhal On Fri, Aug 19, 2016 at 10:47 PM, Aaron Molitor wrote: > Looks like the SYSTEM.FUNCTION table is names with a reserved word. Is > this a

Re: JDBC Client issue

2016-08-21 Thread Gabriel Reid
Hi Aaron, I feel like I've seen this one before, but I'm not totally sure. What I would look at first is a possible hbase-xxx version issue. Something along these lines that I've seen in the past is that another uber-jar JDBC driver that is on the classpath also contains hbase or zookeeper