PageRenderTime 17ms CodeModel.GetById 15ms app.highlight 0ms RepoModel.GetById 1ms app.codeStats 0ms

/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
 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