no mapping is required for PK columns as all PK columns are concatenated together to form a row key. ... View more

Check if columns "COLUMN_QUALIFIER, COLUMN_NAME" of SYSTEM.CATALOG can help. ... View more

No actually, I'm unable to find TracingCompat.java in our HDP 2.6.0 version, so curious how did you get it. Are you sure your java application is using the right dependency for Phoenix? ... View more

you can't keep statement outside of method or constructor except declaration, static blocks in java. ... View more

Have you enabled tracing? ... View more

Configuration config = HBaseConfiguration.create(); Either you can add them config.set("zookeeper.znode.parent","/hbase-unsecure") and config.set("hbase.zookeeper.quorum","<server-name>) Or you can directly include server hbase-site.xml in your application classpath so that HBaseConfiguration.create() will add them automatically. ... View more

Either the zookeeper or znode is incorrect. * parent znode for hdp is generally /hbase-unsecure or /hbase-secure (not /hbase) * check you are giving the right zookeeper address while connecting. If you are not specifying them manually, then make sure that right hbase-site.xml is in your application classpath. ... View more

"UPDATE STATISTICS" will not run at the frequency specified by "phoenix.stats.updateFrequency" as this property is just to ensure that local client cache is refreshed with the stats from the SYSTEM.STATS at this frequency. So, you still need to run "UPDATE STATISTICS" or compaction to have your stats updated. Sorry , I know that documentation on apache for this property is little confusing, I'll update it soon for more clarity. ... View more

Sorry for being late. If you are still seeing this with local index, Can you please describe your table in HBase shell and paste an output here. ... View more

NONE means no compaction is currently running (or completed) , if state return MAJOR , it means major compaction is still running. Either your table is small or you have a single file in each region resulting in major compaction to complete soon and showing state as NONE ... View more