My linux box timezone is in GMT and when I query the tables, it shows correct tz in phoenix (sqlline). When I remotely connect and query the same tables, the timestamp data converts to PST. When I say remotely connect, meaning I am using aqua data studio to connect and the same issue occurs when I connect via Application. I tried to add the property in hbase-site.xml, but there is no luck. Can you please let me know what do I need to do to get the exact data stored in phoenix/hbase table without tz conversion. ... View more

I have updated the system catalog table in phoenix to modify the column size of one of the tables I had created earlier. I have restarted the cluster but the Phoenix client is not picking up the metadata? My requirement is to modify a column data size from 500 to 2000. It's a varchar column ... View more

I have set up a cluster in Ambari. I am using Aqua Data Studio to connect hbase using "org.apache.phoenix.jdbc.PhoenixDriver" drive to connect through ZK nodes. I can run normal queries on hbase tables, but it throws an error while running any aggregate function like max()/count() >[Error] Script lines: 6-10 ------------------------- org.apache.phoenix.exception.PhoenixIOException: The system cannot find the path specified  [Executed: 23/12/2016 11:47:19 AM] [Execution: 28ms] What I need to do to fix this issue? ... View more

I have a requirement to design a table with defined column families but not consistent qualifiers at the beginning. For each records, it might vary. I gave a try to store the varying qualifiers into a Json object and then traverse through it . But the performance gone down when try to fetch for a specific data from a particular qualifier. And moreover I need to break the query into two, first fetch how many qualifiers I have, based on that I need to pass the actual select query. Please let me know how can I get this done in HBASE? The example could be like: Type of queries I want to achieve are: 1. select count(*) from table where one of the Q= 'REW' (How do I know how many qualifiers are there for each row) 2. select first and last qualifier data for keys in (1231, 321) ... View more

I have created a table with few CF and initial list of qualifiers. Later on while UPSERTing data into the table with dynamic qualifiers, it was successfully added. But I am not able to view them anymore. --------------------------------------------------------------------------------------------------------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS EMPDETAIL (id bigint not null, name varchar(255) not null, age bigint, address.addr1 varchar(1000), address.addr2 varchar(1000), address.addr3 varchar(1000), CONSTRAINT EMPDETAIL_PK PRIMARY KEY (id,name)) UPSERT INTO EMPDETAIL (id, name, age, address.addr1, address.addr2, address.addr3) VALUES (1, 'Test1', 20, 'testaddr1', 'testaddr2', 'testaddr3') UPSERT INTO EMPDETAIL (id, name, age, address.addr1, address.addr2, address.addr3, address.addr4 varchar(1000)) VALUES (2, 'Test2', 220, 'testaddr11', 'testaddr22', 'testaddr33', 'testaddr44') UPSERT INTO EMPDETAIL (id, name, age, address.addr1, address.addr2, address.addr3, address.addr4 varchar(1000)) VALUES (3, 'Test3', 330, 'testaddr33', 'testaddr33', 'testaddr333', 'testaddr444') --------------------------------------------------------------------------------------------------------------------------------------------------------------------- If I execute "SELECT * FROM EMPDETAIL", it doesn't return address.add4. I am using "Aqua Data Studio" to connect to Hbase using Phoenix & Hbase client jars. ... View more

How to proceed with the load testing on HBASE Cluster? How can I spwan concurrent threads/request for both data load and extract data? ... View more

I have a setup of Ambari installation with 1 active namenode, 1 secondary namenode and 5 datanodes to use HBASE primarily. Since this is a brand new cluster setup, we are not sure to with the default setting or not. We do have one use case, but for the data system setup what are the factors we should look upon to finalize the various parameters? e.g.: Load testing -- How shall I proceed with it? What should be our compaction parameters (shortCompactions as well)? What should be the initial config for memstore flushes (periodic flusher as well)? Need help on this. ... View more

In my Ambari cluster setup, in HBASE I see the Files Local percentage is fluctuating. Though the cluster is not busy at all and am not doing any bulk load or any such heavy operation. What are the things I need to verify and make changes to keep it stable and above 70%? ... View more