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

# · text · 14 lines · 6 code · 8 blank · 0 comment · 0 complexity · 698e28e4fd46eae657df1564cd181e46 MD5 · raw file 

    

  1. show partitions srcpart;
    2. 

  2. 

  3. 

  4. 

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

  6. describe extended nzhang_part7;
    7. 

  7. 

  8. 

  9. insert overwrite table nzhang_part7 partition (ds='2010-03-03', hr='12') select key, value from srcpart where ds = '2008-04-08' and hr = '12';
    10. 

  10. 

  11. show partitions nzhang_part7;
    12. 

  12. 

  13. select * from nzhang_part7 where ds is not null and hr is not null;
    14.