PageRenderTime 41ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 12 lines | 7 code | 5 blank | 0 comment | 0 complexity | f44d351efe2e767d9fab10c5753ce4ec MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. create table partition_test_partitioned(key string, value string) partitioned by (dt string);
  2. insert overwrite table partition_test_partitioned partition(dt=100) select * from src1;
  3. alter table partition_test_partitioned set fileformat rcfile;
  4. insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
  5. alter table partition_test_partitioned set fileformat Sequencefile;
  6. insert overwrite table partition_test_partitioned partition(dt=102) select * from src1;
  7. select * from partition_test_partitioned where dt >=100 and dt <= 102;