PageRenderTime 49ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientnegative/protectmode_part.q.out

#
text | 61 lines | 59 code | 2 blank | 0 comment | 0 complexity | 23c70bfc976c516f389e9045a7162a2a MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: -- protect mode: syntax to change protect mode works and queries are not blocked if a table or partition is not in protect mode
    2. 

  2. 

  3. drop table tbl_protectmode3
    4. 

  4. PREHOOK: type: DROPTABLE
    5. 

  5. POSTHOOK: query: -- protect mode: syntax to change protect mode works and queries are not blocked if a table or partition is not in protect mode
    6. 

  6. 

  7. drop table tbl_protectmode3
    8. 

  8. POSTHOOK: type: DROPTABLE
    9. 

  9. PREHOOK: query: create table tbl_protectmode3  (col string) partitioned by (p string)
    10. 

  10. PREHOOK: type: CREATETABLE
    11. 

  11. POSTHOOK: query: create table tbl_protectmode3  (col string) partitioned by (p string)
    12. 

  12. POSTHOOK: type: CREATETABLE
    13. 

  13. POSTHOOK: Output: default@tbl_protectmode3
    14. 

  14. PREHOOK: query: alter table tbl_protectmode3 add partition (p='p1')
    15. 

  15. PREHOOK: type: ALTERTABLE_ADDPARTS
    16. 

  16. PREHOOK: Input: default@tbl_protectmode3
    17. 

  17. POSTHOOK: query: alter table tbl_protectmode3 add partition (p='p1')
    18. 

  18. POSTHOOK: type: ALTERTABLE_ADDPARTS
    19. 

  19. POSTHOOK: Input: default@tbl_protectmode3
    20. 

  20. POSTHOOK: Output: default@tbl_protectmode3@p=p1
    21. 

  21. PREHOOK: query: alter table tbl_protectmode3 add partition (p='p2')
    22. 

  22. PREHOOK: type: ALTERTABLE_ADDPARTS
    23. 

  23. PREHOOK: Input: default@tbl_protectmode3
    24. 

  24. POSTHOOK: query: alter table tbl_protectmode3 add partition (p='p2')
    25. 

  25. POSTHOOK: type: ALTERTABLE_ADDPARTS
    26. 

  26. POSTHOOK: Input: default@tbl_protectmode3
    27. 

  27. POSTHOOK: Output: default@tbl_protectmode3@p=p2
    28. 

  28. PREHOOK: query: select * from tbl_protectmode3 where p='p1'
    29. 

  29. PREHOOK: type: QUERY
    30. 

  30. PREHOOK: Input: default@tbl_protectmode3@p=p1
    31. 

  31. PREHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-37_899_8567164411727057325/-mr-10000
    32. 

  32. POSTHOOK: query: select * from tbl_protectmode3 where p='p1'
    33. 

  33. POSTHOOK: type: QUERY
    34. 

  34. POSTHOOK: Input: default@tbl_protectmode3@p=p1
    35. 

  35. POSTHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-37_899_8567164411727057325/-mr-10000
    36. 

  36. PREHOOK: query: select * from tbl_protectmode3 where p='p2'
    37. 

  37. PREHOOK: type: QUERY
    38. 

  38. PREHOOK: Input: default@tbl_protectmode3@p=p2
    39. 

  39. PREHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_124_6078196023007251883/-mr-10000
    40. 

  40. POSTHOOK: query: select * from tbl_protectmode3 where p='p2'
    41. 

  41. POSTHOOK: type: QUERY
    42. 

  42. POSTHOOK: Input: default@tbl_protectmode3@p=p2
    43. 

  43. POSTHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_124_6078196023007251883/-mr-10000
    44. 

  44. PREHOOK: query: alter table tbl_protectmode3 partition (p='p1') enable offline
    45. 

  45. PREHOOK: type: ALTERPARTITION_PROTECTMODE
    46. 

  46. PREHOOK: Input: default@tbl_protectmode3
    47. 

  47. PREHOOK: Output: default@tbl_protectmode3@p=p1
    48. 

  48. POSTHOOK: query: alter table tbl_protectmode3 partition (p='p1') enable offline
    49. 

  49. POSTHOOK: type: ALTERPARTITION_PROTECTMODE
    50. 

  50. POSTHOOK: Input: default@tbl_protectmode3
    51. 

  51. POSTHOOK: Input: default@tbl_protectmode3@p=p1
    52. 

  52. POSTHOOK: Output: default@tbl_protectmode3@p=p1
    53. 

  53. PREHOOK: query: select * from tbl_protectmode3 where p='p2'
    54. 

  54. PREHOOK: type: QUERY
    55. 

  55. PREHOOK: Input: default@tbl_protectmode3@p=p2
    56. 

  56. PREHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_569_2255610848316200687/-mr-10000
    57. 

  57. POSTHOOK: query: select * from tbl_protectmode3 where p='p2'
    58. 

  58. POSTHOOK: type: QUERY
    59. 

  59. POSTHOOK: Input: default@tbl_protectmode3@p=p2
    60. 

  60. POSTHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_569_2255610848316200687/-mr-10000
    61. 

  61. FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode3 Partition p=p1
    62. 

  62.