PageRenderTime 47ms CodeModel.GetById 8ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 80 lines | 78 code | 2 blank | 0 comment | 0 complexity | 2e5d42294a5cd8ff2df1984a24d6ce1d 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. drop table tbl_protectmode5
  3. PREHOOK: type: DROPTABLE
  4. 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
  5. drop table tbl_protectmode5
  6. POSTHOOK: type: DROPTABLE
  7. PREHOOK: query: create table tbl_protectmode5_1 (col string)
  8. PREHOOK: type: CREATETABLE
  9. POSTHOOK: query: create table tbl_protectmode5_1 (col string)
  10. POSTHOOK: type: CREATETABLE
  11. POSTHOOK: Output: default@tbl_protectmode5_1
  12. PREHOOK: query: create table tbl_protectmode5 (col string) partitioned by (p string)
  13. PREHOOK: type: CREATETABLE
  14. POSTHOOK: query: create table tbl_protectmode5 (col string) partitioned by (p string)
  15. POSTHOOK: type: CREATETABLE
  16. POSTHOOK: Output: default@tbl_protectmode5
  17. PREHOOK: query: alter table tbl_protectmode5 add partition (p='p1')
  18. PREHOOK: type: ALTERTABLE_ADDPARTS
  19. PREHOOK: Input: default@tbl_protectmode5
  20. POSTHOOK: query: alter table tbl_protectmode5 add partition (p='p1')
  21. POSTHOOK: type: ALTERTABLE_ADDPARTS
  22. POSTHOOK: Input: default@tbl_protectmode5
  23. POSTHOOK: Output: default@tbl_protectmode5@p=p1
  24. PREHOOK: query: alter table tbl_protectmode5 add partition (p='p2')
  25. PREHOOK: type: ALTERTABLE_ADDPARTS
  26. PREHOOK: Input: default@tbl_protectmode5
  27. POSTHOOK: query: alter table tbl_protectmode5 add partition (p='p2')
  28. POSTHOOK: type: ALTERTABLE_ADDPARTS
  29. POSTHOOK: Input: default@tbl_protectmode5
  30. POSTHOOK: Output: default@tbl_protectmode5@p=p2
  31. PREHOOK: query: insert overwrite table tbl_protectmode5_1
  32. select col from tbl_protectmode5 where p='p1'
  33. PREHOOK: type: QUERY
  34. PREHOOK: Input: default@tbl_protectmode5@p=p1
  35. PREHOOK: Output: default@tbl_protectmode5_1
  36. POSTHOOK: query: insert overwrite table tbl_protectmode5_1
  37. select col from tbl_protectmode5 where p='p1'
  38. POSTHOOK: type: QUERY
  39. POSTHOOK: Input: default@tbl_protectmode5@p=p1
  40. POSTHOOK: Output: default@tbl_protectmode5_1
  41. POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
  42. PREHOOK: query: insert overwrite table tbl_protectmode5_1
  43. select col from tbl_protectmode5 where p='p2'
  44. PREHOOK: type: QUERY
  45. PREHOOK: Input: default@tbl_protectmode5@p=p2
  46. PREHOOK: Output: default@tbl_protectmode5_1
  47. POSTHOOK: query: insert overwrite table tbl_protectmode5_1
  48. select col from tbl_protectmode5 where p='p2'
  49. POSTHOOK: type: QUERY
  50. POSTHOOK: Input: default@tbl_protectmode5@p=p2
  51. POSTHOOK: Output: default@tbl_protectmode5_1
  52. POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
  53. POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
  54. PREHOOK: query: alter table tbl_protectmode5 partition (p='p1') enable offline
  55. PREHOOK: type: ALTERPARTITION_PROTECTMODE
  56. PREHOOK: Input: default@tbl_protectmode5
  57. PREHOOK: Output: default@tbl_protectmode5@p=p1
  58. POSTHOOK: query: alter table tbl_protectmode5 partition (p='p1') enable offline
  59. POSTHOOK: type: ALTERPARTITION_PROTECTMODE
  60. POSTHOOK: Input: default@tbl_protectmode5
  61. POSTHOOK: Input: default@tbl_protectmode5@p=p1
  62. POSTHOOK: Output: default@tbl_protectmode5@p=p1
  63. POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
  64. POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
  65. PREHOOK: query: insert overwrite table tbl_protectmode5_1
  66. select col from tbl_protectmode5 where p='p2'
  67. PREHOOK: type: QUERY
  68. PREHOOK: Input: default@tbl_protectmode5@p=p2
  69. PREHOOK: Output: default@tbl_protectmode5_1
  70. POSTHOOK: query: insert overwrite table tbl_protectmode5_1
  71. select col from tbl_protectmode5 where p='p2'
  72. POSTHOOK: type: QUERY
  73. POSTHOOK: Input: default@tbl_protectmode5@p=p2
  74. POSTHOOK: Output: default@tbl_protectmode5_1
  75. POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
  76. POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
  77. POSTHOOK: Lineage: tbl_protectmode5_1.col SIMPLE [(tbl_protectmode5)tbl_protectmode5.FieldSchema(name:col, type:string, comment:null), ]
  78. FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode5 Partition p=p1