Re: Preferred load balancer option for PQS

2018-03-27 Thread Josh Elser
Hi Jins, Check out https://community.hortonworks.com/articles/9377/deploying-the-phoenix-query-server-in-production-e.html which should cover a bit of this (specifically, via HAProxy). I wrote this prior to the ZK-based discovery and client-driven load balancer which has showed up recently.

v2 field - index type is decimal but table has bigint type.

2018-03-27 Thread Adi Kadimetla
Hi group, CREATE TABLE my_table (k VARCHAR PRIMARY KEY, v1 VARCHAR, v2 BIGINT); v2 - BIGINT CREATE INDEX my_index ON my_table (v2) INCLUDE (v1); MY_INDEX| 0:V2 | 3 | DECIMAL In my_index v2 type is decimal. I wanted to know data type change from bigint in the table to

Preferred load balancer option for PQS

2018-03-27 Thread Jins George
Hi, I am trying to add a load balancer for query server and after reading documentation, I am a little confused on which option to pick. go with a traditional load balancer ( thinking of ELB) or the inbuilt zookeeper based load balancer. Is there an advantage of using ELB over the zookeeper

Re: AW: Call queue too small

2018-03-27 Thread Josh Elser
I'd prefer not to get into HDP-specific details on Apache mailing lists to save those who don't care about HDP. If you have follow up questions, I'd encourage you to use Hortonworks' community forum for HDP specific question. The short answer is: no, new HDP versions do not just contain

Re: Storage Handler for Apache Hive

2018-03-27 Thread Artem Ervits
Oh, I didn't realize you specified Phoenix 4.12 in your original question, then answer is as yes, 2.7 is minimum as Jaanai pointed out. The other option is to choose another phonenix version with Hadoop 2.6 and your version of HBase. Though Hadoop 2.6 been out for years so it makes sense to

Re: Storage Handler for Apache Hive

2018-03-27 Thread Artem Ervits
I can't say for sure but in my experience, Hadoop was at the minimum on 2.7. I can't tell which minimum release of Phoenix 4.x this plugin was merged to but Jira says it affects v. 4.5 and for that release Hadoop 2.5 was minimum. I also see Hive 2.1 supports Hadoop 2.6 so I have no other leads

Re: Storage Handler for Apache Hive

2018-03-27 Thread Jaanai
Hi , Stepan Migunov! The Phoenix 4.12.0-HBase-1.1 depends on hadoop 2.7.1 version, you shoud run it on hadoop of higher version.

RE: Storage Handler for Apache Hive

2018-03-27 Thread Stepan Migunov
Thank you, Artem! Does it mean that Phoenix-Hive integration works with Hadoop >= 2.7 only? *From:* Artem Ervits [mailto:artemerv...@gmail.com] *Sent:* Tuesday, March 27, 2018 12:10 PM *To:* user@phoenix.apache.org *Subject:* Re: Storage Handler for Apache Hive Stepan, you're using