/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 

    

  1. create table partition_test_partitioned(key string, value string) partitioned by (dt string);
    2. 

  2. 

  3. insert overwrite table partition_test_partitioned partition(dt=100) select * from src1;
    4. 

  4. alter table partition_test_partitioned set fileformat rcfile;
    5. 

  5. insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
    6. 

  6. alter table partition_test_partitioned set fileformat Sequencefile;
    7. 

  7. insert overwrite table partition_test_partitioned partition(dt=102) select * from src1;
    8. 

  8. 

  9. select * from partition_test_partitioned where dt >=100 and dt <= 102;
    10.