As per your hbase-site.xml, bucket cache size is configured as <property> <name>hbase.bucketcache.size</name> <value>6416</value> </property But hbase-env.sh has MaxDirectMemorySize is set to just -XX:MaxDirectMemorySize=6128 You need to set this -XX:MaxDirectMemorySize in hbase-env.sh to more than the bucket cache size configuration, and remember to suffix the configuration with "m" -XX:MaxDirectMemorySize=6528m ... View more

Phoenix tables are the same as HBase tables so as per your need, you can use any backup method available in hbase. http://hbase.apache.org/book.html#ops.backup Taking a snapshot of all SYSTEM tables and user tables and exporting in some cold storage is an good option until incremental backup and restore feature in hbase got released (though active development is going on so expected to be released soon in HDP). ... View more

Some join queries can be rewritten like this:- delete from source1 where (pk1,pk2) in (select pk1,pk2 from source2); ... View more

May be you are hitting the following bug. https://issues.apache.org/jira/browse/HIVE-9977 And, Probably running the compaction manually on the table will get you more number of tez mappers. ... View more