/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/input24.q

# · text · 9 lines · 5 code · 4 blank · 0 comment · 0 complexity · 97eb44f10db6407c98cf4a26f47d82b8 MD5 · raw file 

    

  1. create table tst(a int, b int) partitioned by (d string);
    2. 

  2. alter table tst add partition (d='2009-01-01');
    3. 

  3. explain
    4. 

  4. select count(1) from tst x where x.d='2009-01-01';
    5. 

  5. 

  6. select count(1) from tst x where x.d='2009-01-01';
    7.