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

# · text · 24 lines · 15 code · 9 blank · 0 comment · 0 complexity · a7cbaaa53a1f80fb5d031d514b2d95bf MD5 · raw file 

    

  1. show partitions srcpart;
    2. 

  2. 

  3. 

  4. 

  5. create table if not exists nzhang_part8 like srcpart;
    6. 

  6. describe extended nzhang_part8;
    7. 

  7. 

  8. set hive.merge.mapfiles=false;
    9. 

  9. set hive.exec.dynamic.partition=true;
    10. 

  10. set hive.exec.dynamic.partition.mode=nonstrict;
    11. 

  11. 

  12. explain extended
    13. 

  13. from srcpart
    14. 

  14. insert overwrite table nzhang_part8 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
    15. 

  15. insert overwrite table nzhang_part8 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08';
    16. 

  16. 

  17. from srcpart
    18. 

  18. insert overwrite table nzhang_part8 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
    19. 

  19. insert overwrite table nzhang_part8 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08';
    20. 

  20. 

  21. show partitions nzhang_part8;
    22. 

  22. 

  23. select * from nzhang_part8 where ds is not null and hr is not null;
    24.