/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 

    

  1. set datanucleus.cache.collections=false;
    2. 

  2. 

  3. set hive.stats.dbclass=hbase;
    4. 

  4. 

  5. create table stats_src like src;
    6. 

  6. insert overwrite table stats_src select * from src;
    7. 

  7. analyze table stats_src compute statistics;
    8. 

  8. desc formatted stats_src;
    9. 

  9. 

  10. create table hbase_part like srcpart;
    11. 

  11. 

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

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

  14. 

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

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

  17. 

  18. desc formatted hbase_part;
    19. 

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

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