Phoenix mapreduce

2017-01-31 Thread Anil
Hello, I have phoenix table which have both child and parent records. now i have created a phoenix mapreduce job to populate few columns of parent record into child record. Two ways of populating parent columns into child record are 1. a. Get the parent columns information by phoenix query for e

Re: Phoenix Question

2017-01-31 Thread Mark Heppner
Sukant, Yes, you definitely could replace your RDBMS with Phoenix. However, it does behave fairly differently than a traditional RDBMS. You should fully understand HBase and HDFS before making a decision. HBase scales really well as long as you plan it out. Phoenix does provide full ACID support, b

Re: Phoenix Question

2017-01-31 Thread Will Xu
Hi Mark, When you say Phoenix supports ACID do you mean via Tephra? Regards, Will From: Mark Heppner Sent: Tuesday, January 31, 2017 6:37 AM To: user@phoenix.apache.org Cc: noam.bul...@teoco.com Subject: Re: Phoenix Question Sukant, Yes, you definitely could

Re: Phoenix Question

2017-01-31 Thread Mark Heppner
Will, Yes. I don't know much about it, but it's somewhat new and is still in the Apache incubator. Since there are no versioned docs for Phoenix and you have to hunt to find what features are available in which version, I think the transactions were introduced as a beta feature in 4.7, but someone

phoniex 4.6 to 4.8 upgrade SYSTEM.STATS issue

2017-01-31 Thread venk sham
Hi, During the phoenix upgrade from 4.6 to 4.8 SYSTEM.STATS meta data is getting deleted and recreated in SYSTEM.CATALOG, but SYSTEM.CATALOG actual data is not getting cleared. phioenix 4.6 SYSTEM.STATS has row key as physical_Table_name + column family+ region name. Since SYSTEM.STATS data i

Phoenix Query Server query logging

2017-01-31 Thread Michael Young
Does the Phoenix Query Server have an option to log the SQL statements which are executed? We see there are ways to get various PQS trace logs modifying the log4j settings used by the queryserver.py: log4j.org.apache.phoenix.jdbc.PhoenixStatementFactory=TRACE (or DEBUG) log4j.org.apache.phoenix.j