/tags/release-0.0.0-rc0/hive/external/hbase-handler/src/test/queries/hbase_stats.q

 1set datanucleus.cache.collections=false;
 2
 3set hive.stats.dbclass=hbase;
 4
 5create table stats_src like src;
 6insert overwrite table stats_src select * from src;
 7analyze table stats_src compute statistics;
 8desc formatted stats_src;
 9
10create table hbase_part like srcpart;
11
12insert overwrite table hbase_part partition (ds='2010-04-08', hr = '11') select key, value from src;
13insert overwrite table hbase_part partition (ds='2010-04-08', hr = '12') select key, value from src;
14
15analyze table hbase_part partition(ds='2008-04-08', hr=11) compute statistics;
16analyze table hbase_part partition(ds='2008-04-08', hr=12) compute statistics;
17
18desc formatted hbase_part;
19desc formatted hbase_part partition (ds='2010-04-08', hr = '11');
20desc formatted hbase_part partition (ds='2010-04-08', hr = '12');
21