PageRenderTime 63ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 30 lines | 20 code | 10 blank | 0 comment | 0 complexity | 14d2e43cc12bd518a0d2d47b871be2e4 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. drop table tstsrc;
    2. 

  2. 

  3. set hive.exec.pre.hooks = org.apache.hadoop.hive.ql.hooks.PreExecutePrinter,org.apache.hadoop.hive.ql.hooks.EnforceReadOnlyTables,org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec;
    4. 

  4. 

  5. create table tstsrc as select * from src;
    6. 

  6. desc extended tstsrc;
    7. 

  7. select count(1) from tstsrc;
    8. 

  8. desc extended tstsrc;
    9. 

  9. drop table tstsrc;
    10. 

  10. 

  11. drop table tstsrcpart;
    12. 

  12. create table tstsrcpart like srcpart;
    13. 

  13. 

  14. set hive.exec.dynamic.partition.mode=nonstrict;
    15. 

  15. set hive.exec.dynamic.partition=true;
    16. 

  16. 

  17. 

  18. insert overwrite table tstsrcpart partition (ds, hr) select key, value, ds, hr from srcpart;
    19. 

  19. 

  20. desc extended tstsrcpart;
    21. 

  21. desc extended tstsrcpart partition (ds='2008-04-08', hr='11');
    22. 

  22. desc extended tstsrcpart partition (ds='2008-04-08', hr='12');
    23. 

  23. 

  24. select count(1) from tstsrcpart where ds = '2008-04-08' and hr = '11';
    25. 

  25. 

  26. desc extended tstsrcpart;
    27. 

  27. desc extended tstsrcpart partition (ds='2008-04-08', hr='11');
    28. 

  28. desc extended tstsrcpart partition (ds='2008-04-08', hr='12');
    29. 

  29. 

  30. drop table tstsrcpart;
    31. 

  31.