Re: sqlline thin client upsert successfully, but got timeout problem when try to connect to the phoenix again

2018-04-09 Thread ivanybma
Hi, sorry to reply late. that is just a part of my hbase-site.xml. below is the full content: hbase/conf/hbase.site.xml** hbase.rootdir hdfs://broker.xxx-xxx.local:9000/hbase hbase.zookeeper.quorum broker.xxx-xxx.l

Reminder: PhoenixCon 2018 call for abstracts ends in one week!

2018-04-09 Thread Josh Elser
Hi all, There's just one week left to submit abstracts to PhoenixCon 2018, held in San Jose, CA on June 18th. We need all of you -- developers, users, admins -- to submit all talks to make this event a great success. No talk is too small. Please reach out if there are any questions! You ca

Re: sqlline thin client upsert successfully, but got timeout problem when try to connect to the phoenix again

2018-04-09 Thread Josh Elser
The hbase-site.xml elements you shared earlier, were those your entire hbase-site contents or just part of it? Make sure you have the required properties set as described on https://phoenix.apache.org/secondary_indexing.html for your indexes. If you're still seeing problems, you may need to in

Re: sqlline thin client upsert successfully, but got timeout problem when try to connect to the phoenix again

2018-04-09 Thread ivanybma
thanks for your suggestion. I found something interesting, not sure if that is some potential reason. That is my indexes created on my tables. I created a lot of indexes. After I removed all of the indexes, it seems things went better(no more hanging like that). So I am suspecting there is

Re: sqlline thin client upsert successfully, but got timeout problem when try to connect to the phoenix again

2018-04-09 Thread Josh Elser
Have you looked at DEBUG logging client and server(HBase) side? The "Call exception" log messages imply that the client is repeatedly trying to issue an RPC to a RegionServer and failing. This should be where you focus your attention. It may be something trivial to fix related to configuration

Re: Please help with the "upsert into select case ... " statement error.

2018-04-09 Thread Josh Elser
This looks reminiscent of https://issues.apache.org/jira/browse/PHOENIX-4588 but I'm not certain if they're the same issue. On 4/4/18 6:38 PM, spark receiver wrote: Hi everyone, I’m using phoenix 4.11 ,facing a strange issue when using upsert. I’m joinning  2 tables to get  “flag“ column an

Re: Bind Params with Union throw AvaticaSqlException

2018-04-09 Thread Josh Elser
Hi Lew, I believe the snippet of the stack trace you have provided isn't telling us anything other than that the real PhoenixDriver code threw an error (Avatica/PQS are just doing pass-through to the real PhoenixDriver inside). Can you please look closer at the bottom of the stack trace to se