hbase_stats.q | searchcode

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

#
text | 21 lines | 14 code | 7 blank | 0 comment | 0 complexity | 48037d7c5671fb8bc220b6422be3594f MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0


set datanucleus.cache.collections=false;

set hive.stats.dbclass=hbase;

create table stats_src like src;
insert overwrite table stats_src select * from src;
analyze table stats_src compute statistics;
desc formatted stats_src;

create table hbase_part like srcpart;

insert overwrite table hbase_part partition (ds='2010-04-08', hr = '11') select key, value from src;
insert overwrite table hbase_part partition (ds='2010-04-08', hr = '12') select key, value from src;

analyze table hbase_part partition(ds='2008-04-08', hr=11) compute statistics;
analyze table hbase_part partition(ds='2008-04-08', hr=12) compute statistics;

desc formatted hbase_part;
desc formatted hbase_part partition (ds='2010-04-08', hr = '11');
desc formatted hbase_part partition (ds='2010-04-08', hr = '12');