RE: error if result size is over some limit

2016-11-23 Thread Bulvik, Noam
It is hard to quantify the size of the data that is causing the issue Change in criteria was done to retrieve fewer rows -Original Message- From: Josh Elser [mailto:josh.el...@gmail.com] Sent: Wednesday, November 23, 2016 7:07 PM To: user@phoenix.apache.org Subject: Re: error if result siz

Re: spark 2.0.2 connect phoenix query server error

2016-11-23 Thread Divya Gehlot
Can you try with below driver "driver" -> "org.apache.phoenix.jdbc.PhoenixDriver", Thanks, Divya On 22 November 2016 at 11:14, Dequn Zhang wrote: > Hello, since spark 2.x can not use Phoenix Spark Interpreter to load data, > so I want to use JDBC, but when I want to get a *thin connection*, I

Re: spark 2.0.2 connect phoenix query server error

2016-11-23 Thread Dequn Zhang
Thank you for your reply , I failed to find where do spark or phoenix save the log, and I also tried to change log4j.evel in $SPARK_HOME/conf/log4j.properties and $PHOENIX_HOME/bin/config, unfortunately it didn't work also, can you help me more on how to find out the lost stacktrace info? 2016-1

Re: phoenix-Hbase-client jar web application issue

2016-11-23 Thread pradeep arumalla
thanks josh looking into it. On Wed, Nov 23, 2016 at 1:48 PM, Josh Elser wrote: > Hi Pradeep, > > No, this is one you will likely have to work around on your own by > building a custom Phoenix client jar that does not include the > javax-servlet classes. They are getting transitively pulled into

Re: Phoenix LIKE operator with bind parameters question/error

2016-11-23 Thread Bartłomiej Niemienionek
Hi Aby other thoughts ideas to get Like operator working with bind parameters ? Regards Bartek 18.11.2016 22:20 "Bartłomiej Niemienionek" napisał(a): > Thank you for your answer but it seems that your solution is not working > in my case. > As you can see in my example also :abs is workin fine

Re: phoenix-Hbase-client jar web application issue

2016-11-23 Thread Josh Elser
Hi Pradeep, No, this is one you will likely have to work around on your own by building a custom Phoenix client jar that does not include the javax-servlet classes. They are getting transitively pulled into Phoenix via Hadoop (IIRC). If your web application already has the classes present, yo

RE: Phoenix-Spark plug in cannot select by column family name

2016-11-23 Thread Long, Xindian
Thanks, I just filed a Jira Issue https://issues.apache.org/jira/browse/PHOENIX-3506 Xindian From: James Taylor [mailto:jamestay...@apache.org] Sent: Thursday, November 10, 2016 3:08 PM To: user Subject: Re: Phoenix-Spark plug in cannot select by column family name Please file a JIRA, though,

phoenix-Hbase-client jar web application issue

2016-11-23 Thread pradeep arumalla
hello group , when I try to connect to hbase using *phoenix-4.8.1-HBase-1.2-client.jar *in my web application on tomcat* , *I see the jar is getting rejected because of javax/servlet/Servlet.class package being present in the jar, is there an other jar to use ?.Please advice. INFO: validateJarFil

Re: error if result size is over some limit

2016-11-23 Thread Josh Elser
Hi Noam, Can you quantify the query you run that shows this error? Also, when you change the criteria to retrieve less data, do you mean that you're fetching fewer rows? Bulvik, Noam wrote: I am using phonix 4.5.2 and in my table the data in in Array. When I issue a query sometime the query

Re: Salting an secondary index

2016-11-23 Thread Josh Elser
IIRC, SALT_BUCKET configuration from the data table is implicitly applied to any index tables you create from that data table. Pradheep Shanmugam wrote: Hi, I have a hbase table created using phoenix which is salted. Since the queries on the table required a secondary index, I created index us

Re: spark 2.0.2 connect phoenix query server error

2016-11-23 Thread Josh Elser
Hi Dequn, There should be more to this stacktrace than you provided as the actual cause is not included. Can you please include the entire stacktrace? If you are not seeing this client-side, please check the Phoenix Query Server log file to see if there is more there. Dequn Zhang wrote: Hel

Salting an secondary index

2016-11-23 Thread Pradheep Shanmugam
Hi, I have a hbase table created using phoenix which is salted. Since the queries on the table required a secondary index, I created index using phoenix. Can this index also be salted which may place the rows randomly in different Rss? Even of the index is not salted, will the index be useful wh