hbase cell storage different bewteen bulk load and direct api

2018-04-18 Thread Lew Jackman
Under Phoenix 4.11 we are seeing some storage discrepancies in hbase between a load via psql and a bulk load. To illustrate in a simple case we have modified the example table from the load reference https://phoenix.apache.org/bulk_dataload.html CREATE TABLE example ( my_pk bigint not

phoenix query server java.lang.ClassCastException for BIGINT ARRAY column

2018-04-18 Thread Lu Wei
Hi there, I have a phoenix table containing an BIGINT ARRAY column. But when querying query server (through sqlline-thin.py), there is an exception: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Long BTW, when query through sqlline.py, everything works fine. And

Split and distribute regions of SYSTEM.STATS table

2018-04-18 Thread Batyrshin Alexander
Hello, I've discovered that SYSTEM.STATS has only 1 region with size 3.25 GB. Is it ok to split it and distribute over different region servers?