input24.q | searchcode

/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0



create table tst(a int, b int) partitioned by (d string);
alter table tst add partition (d='2009-01-01');
explain
select count(1) from tst x where x.d='2009-01-01';

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