Jdbc connection issue

Hi, I am trying to connect to phoenix using jdbc and getting the following exception. However the master is running and I can connect sqlline and hbase shell. The exception is not making any sense to me. org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=35, exceptions:

Re: where clause on Phoenix view built on Hbase table throws error

Date is a reserved word. Regards, John Leach > On Oct 5, 2016, at 9:39 AM, Ted Yu wrote: > > Please take a look at > phoenix-core/src/it/java/org/apache/phoenix/end2end/ToNumberFunctionIT.java > where to_number() is used. > > On Wed, Oct 5, 2016 at 7:34 AM, Mich

Re: where clause on Phoenix view built on Hbase table throws error

Please take a look at phoenix-core/src/it/java/org/apache/phoenix/end2end/ToNumberFunctionIT.java where to_number() is used. On Wed, Oct 5, 2016 at 7:34 AM, Mich Talebzadeh wrote: > Thanks John. > > 0: jdbc:phoenix:rhes564:2181> select "Date","volume" from "tsco"

Re: where clause on Phoenix view built on Hbase table throws error

I think phoenix mailing list is the proper one for this thread. On Wed, Oct 5, 2016 at 7:24 AM, John Leach wrote: > > Remove the double quotes and try single quote. Double quotes refers to an > identifier… > > Cheers, > John Leach > > > On Oct 5, 2016, at 9:21 AM,