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

# · text · 8 lines · 6 code · 2 blank · 0 comment · 0 complexity · fc3d6aa81c85ada572d7b36670bfb48b MD5 · raw file 

    

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

  2. alter table partition_test_partitioned set fileformat sequencefile;
    3. 

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

  4. alter table partition_test_partitioned partition (dt='1') set fileformat sequencefile;
    5. 

  5. 

  6. alter table partition_test_partitioned add partition (dt='2');
    7. 

  7. alter table partition_test_partitioned drop partition (dt='2');
    8.