Re: ALTER table

General recommendation is to choose salt number as a small multiple of region servers. If you are aware of your key distribution you can pre-split the table in phoenix too along specific split points. On Monday, January 11, 2016, Ken Hampson wrote: > I ran into this as well just today, and am ve

EXPLAIN output

Hi: I was wondering if there was a primer available anywhere regarding the output of EXPLAIN. I came across a post in the mailing list archive from over a year ago ( https://mail-archives.apache.org/mod_mbox/phoenix-user/201411.mbox/%3ccaaf1jdicio+yazljd6hoyjp3e4+8zzcgibgnwfzb7d4vpwc...@mail.gmai

COUNT behavior

Hi, all: I have noticed that when using an unqualified COUNT(*) call on a table (whether Phoenix or view of an existing HBase table) without a qualifying WHERE clause, it comes back very quickly and, usually, inaccurately. I assume it is being cached somewhere as metadata, but I am wondering if an

Re: ALTER table

I ran into this as well just today, and am very interested in the answer. HBase itself allows regions to be explicitly split as well as pre-split and auto-split. SALT_BUCKETS seems like a pre-split equivalent of sorts, so I am interested to see what there may be in terms of auto- and explicit-salti

Re: Phoenix 4.2.2log files

phoenix should log to the hbase logs, if I'm not mistaken William Watson Software Engineer (904) 705-7056 PCS On Mon, Jan 11, 2016 at 7:34 AM, Gaurav Agarwal wrote: > Hi > I am using hep sandbox trying to find where to find the log files of > phoenix . > Any idea how to log the information >

Phoenix 4.2.2log files

Hi I am using hep sandbox trying to find where to find the log files of phoenix . Any idea how to log the information

ALTER table

Hello, SALT_BUCKETS cannot be altered after table creation. I'd like to know from advanced users as to how do we ensure that salt buckets hold up as data grows? I might state salt buckets as say, 8 when I create table and that may hold up for a long time. However, as data is increasing those sal

working(parsing) of Where clause condition

Hello, I want to know the complete lifecycle of where clause condition in phoenix. How does the value of where condition get parse from different classes and intermediate value . Where is exactly the where clause logic and scan object reside in code Executing command

Re: Question about support for ARRAY data type with Pig Integration

Hi Kiran, Thank you very much for the information and your work ! Best Regards, rafa. On Sat, Jan 9, 2016 at 8:53 AM, Ravi Kiran wrote: > Hi Rafa, > >I will be working on this ticket > https://issues.apache.org/jira/browse/PHOENIX-2584. You can add yourself > as a watcher to the ticket t

Identify each column name and its data in region server coprocessor

Hi, I wanted to intercept the phoenix queries in hbase region server coprocessor and process certain columns individually. While receiving data in coprocessor postScannerNext method, each row is consolidated into single cell. And cannot be distinguished separately as particular co