This is not possible to test Hive HBase integration, neither with the sandbox, nor with the alpha 2.
It is related to nasty classpath issue. Indeed hive cannot find the HBase library.
Tried to overwrite export HIVE_AUX_JARS_PATH=/usr/lib/hcatalog/share/hcatalog/hcatalog-core.jar in /etc/hive/conf/hive-env.sh and adding the path to hbase core lib /usr/lib/hbase/hbase.jar
This works, since I can create an external table pointing on an existing HBase table and do a select * on it.
But as soon as I want to make a select * from mytable where prop=’value’, I hit the following exception :
java.io.FileNotFoundException: File file:/usr/lib/hbase/hbase.jar:/usr/lib/hcatalog/share/hcatalog/hcatalog-core.jar does not exist
It might be related to this issue https://issues.apache.org/jira/browse/HIVE-2379