PageRenderTime 41ms CodeModel.GetById 7ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/alter3.q.out

#
text | 344 lines | 336 code | 8 blank | 0 comment | 0 complexity | c706fbda3f5ab7f11005e893ed1cfcf5 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: create table alter3_src ( col1 string ) stored as textfile
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: create table alter3_src ( col1 string ) stored as textfile
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@alter3_src
    6. 

  6. PREHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table alter3_src
    7. 

  7. PREHOOK: type: LOAD
    8. 

  8. POSTHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table alter3_src
    9. 

  9. POSTHOOK: type: LOAD
    10. 

  10. POSTHOOK: Output: default@alter3_src
    11. 

  11. PREHOOK: query: create table alter3 ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile
    12. 

  12. PREHOOK: type: CREATETABLE
    13. 

  13. POSTHOOK: query: create table alter3 ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile
    14. 

  14. POSTHOOK: type: CREATETABLE
    15. 

  15. POSTHOOK: Output: default@alter3
    16. 

  16. PREHOOK: query: create table alter3_like like alter3
    17. 

  17. PREHOOK: type: CREATETABLE
    18. 

  18. POSTHOOK: query: create table alter3_like like alter3
    19. 

  19. POSTHOOK: type: CREATETABLE
    20. 

  20. POSTHOOK: Output: default@alter3_like
    21. 

  21. PREHOOK: query: insert overwrite table alter3 partition (pCol1='test_part:', pcol2='test_part:') select col1 from alter3_src
    22. 

  22. PREHOOK: type: QUERY
    23. 

  23. PREHOOK: Input: default@alter3_src
    24. 

  24. PREHOOK: Output: default@alter3@pcol1=test_part%3A/pcol2=test_part%3A
    25. 

  25. POSTHOOK: query: insert overwrite table alter3 partition (pCol1='test_part:', pcol2='test_part:') select col1 from alter3_src
    26. 

  26. POSTHOOK: type: QUERY
    27. 

  27. POSTHOOK: Input: default@alter3_src
    28. 

  28. POSTHOOK: Output: default@alter3@pcol1=test_part%3A/pcol2=test_part%3A
    29. 

  29. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    30. 

  30. PREHOOK: query: select * from alter3 where pcol1='test_part:' and pcol2='test_part:'
    31. 

  31. PREHOOK: type: QUERY
    32. 

  32. PREHOOK: Input: default@alter3@pcol1=test_part%3A/pcol2=test_part%3A
    33. 

  33. PREHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-42-57_025_6359929124129148420/-mr-10000
    34. 

  34. POSTHOOK: query: select * from alter3 where pcol1='test_part:' and pcol2='test_part:'
    35. 

  35. POSTHOOK: type: QUERY
    36. 

  36. POSTHOOK: Input: default@alter3@pcol1=test_part%3A/pcol2=test_part%3A
    37. 

  37. POSTHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-42-57_025_6359929124129148420/-mr-10000
    38. 

  38. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    39. 

  39. 1	test_part:	test_part:
    40. 

  40. 2	test_part:	test_part:
    41. 

  41. 3	test_part:	test_part:
    42. 

  42. 4	test_part:	test_part:
    43. 

  43. 5	test_part:	test_part:
    44. 

  44. 6	test_part:	test_part:
    45. 

  45. PREHOOK: query: alter table alter3 rename to alter3_renamed
    46. 

  46. PREHOOK: type: ALTERTABLE_RENAME
    47. 

  47. PREHOOK: Input: default@alter3
    48. 

  48. PREHOOK: Output: default@alter3
    49. 

  49. POSTHOOK: query: alter table alter3 rename to alter3_renamed
    50. 

  50. POSTHOOK: type: ALTERTABLE_RENAME
    51. 

  51. POSTHOOK: Input: default@alter3
    52. 

  52. POSTHOOK: Output: default@alter3
    53. 

  53. POSTHOOK: Output: default@alter3_renamed
    54. 

  54. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    55. 

  55. PREHOOK: query: describe extended alter3_renamed
    56. 

  56. PREHOOK: type: DESCTABLE
    57. 

  57. POSTHOOK: query: describe extended alter3_renamed
    58. 

  58. POSTHOOK: type: DESCTABLE
    59. 

  59. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    60. 

  60. col1	string	
    61. 

  61. pcol1	string	
    62. 

  62. pcol2	string	
    63. 

  63. 	 	 
    64. 

  64. Detailed Table Information	Table(tableName:alter3_renamed, dbName:default, owner:pyang, createTime:1296517370, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/data/users/pyang/trunk/VENDOR.hive/trunk/build/ql/test/data/warehouse/alter3_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, last_modified_by=pyang, last_modified_time=1296517377, transient_lastDdlTime=1296517377, numRows=6, totalSize=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    65. 

  65. PREHOOK: query: describe extended alter3_renamed partition (pCol1='test_part:', pcol2='test_part:')
    66. 

  66. PREHOOK: type: DESCTABLE
    67. 

  67. POSTHOOK: query: describe extended alter3_renamed partition (pCol1='test_part:', pcol2='test_part:')
    68. 

  68. POSTHOOK: type: DESCTABLE
    69. 

  69. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    70. 

  70. col1	string	
    71. 

  71. pcol1	string	
    72. 

  72. pcol2	string	
    73. 

  73. 	 	 
    74. 

  74. Detailed Partition Information	Partition(values:[test_part:, test_part:], dbName:default, tableName:alter3_renamed, createTime:1296517376, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/data/users/pyang/trunk/VENDOR.hive/trunk/build/ql/test/data/warehouse/alter3_renamed/pcol1=test_part%3A/pcol2=test_part%3A, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{numFiles=1, transient_lastDdlTime=1296517376, numRows=6, totalSize=171})	
    75. 

  75. PREHOOK: query: select * from alter3_renamed where pcol1='test_part:' and pcol2='test_part:'
    76. 

  76. PREHOOK: type: QUERY
    77. 

  77. PREHOOK: Input: default@alter3_renamed@pcol1=test_part%3A/pcol2=test_part%3A
    78. 

  78. PREHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-42-57_884_3547980406449617618/-mr-10000
    79. 

  79. POSTHOOK: query: select * from alter3_renamed where pcol1='test_part:' and pcol2='test_part:'
    80. 

  80. POSTHOOK: type: QUERY
    81. 

  81. POSTHOOK: Input: default@alter3_renamed@pcol1=test_part%3A/pcol2=test_part%3A
    82. 

  82. POSTHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-42-57_884_3547980406449617618/-mr-10000
    83. 

  83. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    84. 

  84. 1	test_part:	test_part:
    85. 

  85. 2	test_part:	test_part:
    86. 

  86. 3	test_part:	test_part:
    87. 

  87. 4	test_part:	test_part:
    88. 

  88. 5	test_part:	test_part:
    89. 

  89. 6	test_part:	test_part:
    90. 

  90. PREHOOK: query: insert overwrite table alter3_like
    91. 

  91. partition (pCol1='test_part:', pcol2='test_part:')
    92. 

  92. select col1 from alter3_src
    93. 

  93. PREHOOK: type: QUERY
    94. 

  94. PREHOOK: Input: default@alter3_src
    95. 

  95. PREHOOK: Output: default@alter3_like@pcol1=test_part%3A/pcol2=test_part%3A
    96. 

  96. POSTHOOK: query: insert overwrite table alter3_like
    97. 

  97. partition (pCol1='test_part:', pcol2='test_part:')
    98. 

  98. select col1 from alter3_src
    99. 

  99. POSTHOOK: type: QUERY
    100. 

  100. POSTHOOK: Input: default@alter3_src
    101. 

  101. POSTHOOK: Output: default@alter3_like@pcol1=test_part%3A/pcol2=test_part%3A
    102. 

  102. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    103. 

  103. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    104. 

  104. PREHOOK: query: alter table alter3_like rename to alter3_like_renamed
    105. 

  105. PREHOOK: type: ALTERTABLE_RENAME
    106. 

  106. PREHOOK: Input: default@alter3_like
    107. 

  107. PREHOOK: Output: default@alter3_like
    108. 

  108. POSTHOOK: query: alter table alter3_like rename to alter3_like_renamed
    109. 

  109. POSTHOOK: type: ALTERTABLE_RENAME
    110. 

  110. POSTHOOK: Input: default@alter3_like
    111. 

  111. POSTHOOK: Output: default@alter3_like
    112. 

  112. POSTHOOK: Output: default@alter3_like_renamed
    113. 

  113. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    114. 

  114. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    115. 

  115. PREHOOK: query: describe extended alter3_like_renamed
    116. 

  116. PREHOOK: type: DESCTABLE
    117. 

  117. POSTHOOK: query: describe extended alter3_like_renamed
    118. 

  118. POSTHOOK: type: DESCTABLE
    119. 

  119. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    120. 

  120. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    121. 

  121. col1	string	
    122. 

  122. pcol1	string	
    123. 

  123. pcol2	string	
    124. 

  124. 	 	 
    125. 

  125. Detailed Table Information	Table(tableName:alter3_like_renamed, dbName:default, owner:pyang, createTime:1296517370, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/data/users/pyang/trunk/VENDOR.hive/trunk/build/ql/test/data/warehouse/alter3_like_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, last_modified_by=pyang, last_modified_time=1296517382, transient_lastDdlTime=1296517382, numRows=6, totalSize=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    126. 

  126. PREHOOK: query: -- Cleanup
    127. 

  127. DROP TABLE alter3_src
    128. 

  128. PREHOOK: type: DROPTABLE
    129. 

  129. PREHOOK: Input: default@alter3_src
    130. 

  130. PREHOOK: Output: default@alter3_src
    131. 

  131. POSTHOOK: query: -- Cleanup
    132. 

  132. DROP TABLE alter3_src
    133. 

  133. POSTHOOK: type: DROPTABLE
    134. 

  134. POSTHOOK: Input: default@alter3_src
    135. 

  135. POSTHOOK: Output: default@alter3_src
    136. 

  136. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    137. 

  137. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    138. 

  138. PREHOOK: query: DROP TABLE alter3_renamed
    139. 

  139. PREHOOK: type: DROPTABLE
    140. 

  140. PREHOOK: Input: default@alter3_renamed
    141. 

  141. PREHOOK: Output: default@alter3_renamed
    142. 

  142. POSTHOOK: query: DROP TABLE alter3_renamed
    143. 

  143. POSTHOOK: type: DROPTABLE
    144. 

  144. POSTHOOK: Input: default@alter3_renamed
    145. 

  145. POSTHOOK: Output: default@alter3_renamed
    146. 

  146. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    147. 

  147. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    148. 

  148. PREHOOK: query: DROP TABLE alter3_like_renamed
    149. 

  149. PREHOOK: type: DROPTABLE
    150. 

  150. PREHOOK: Input: default@alter3_like_renamed
    151. 

  151. PREHOOK: Output: default@alter3_like_renamed
    152. 

  152. POSTHOOK: query: DROP TABLE alter3_like_renamed
    153. 

  153. POSTHOOK: type: DROPTABLE
    154. 

  154. POSTHOOK: Input: default@alter3_like_renamed
    155. 

  155. POSTHOOK: Output: default@alter3_like_renamed
    156. 

  156. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    157. 

  157. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    158. 

  158. PREHOOK: query: SHOW TABLES
    159. 

  159. PREHOOK: type: SHOWTABLES
    160. 

  160. POSTHOOK: query: SHOW TABLES
    161. 

  161. POSTHOOK: type: SHOWTABLES
    162. 

  162. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    163. 

  163. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    164. 

  164. src
    165. 

  165. src1
    166. 

  166. src_json
    167. 

  167. src_sequencefile
    168. 

  168. src_thrift
    169. 

  169. srcbucket
    170. 

  170. srcbucket2
    171. 

  171. srcpart
    172. 

  172. PREHOOK: query: -- With non-default Database
    173. 

  173. 

  174. CREATE DATABASE alter3_db
    175. 

  175. PREHOOK: type: CREATEDATABASE
    176. 

  176. POSTHOOK: query: -- With non-default Database
    177. 

  177. 

  178. CREATE DATABASE alter3_db
    179. 

  179. POSTHOOK: type: CREATEDATABASE
    180. 

  180. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    181. 

  181. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    182. 

  182. PREHOOK: query: USE alter3_db
    183. 

  183. PREHOOK: type: SWITCHDATABASE
    184. 

  184. POSTHOOK: query: USE alter3_db
    185. 

  185. POSTHOOK: type: SWITCHDATABASE
    186. 

  186. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    187. 

  187. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    188. 

  188. PREHOOK: query: SHOW TABLES
    189. 

  189. PREHOOK: type: SHOWTABLES
    190. 

  190. POSTHOOK: query: SHOW TABLES
    191. 

  191. POSTHOOK: type: SHOWTABLES
    192. 

  192. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    193. 

  193. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    194. 

  194. PREHOOK: query: CREATE TABLE alter3_src (col1 STRING) STORED AS TEXTFILE
    195. 

  195. PREHOOK: type: CREATETABLE
    196. 

  196. POSTHOOK: query: CREATE TABLE alter3_src (col1 STRING) STORED AS TEXTFILE
    197. 

  197. POSTHOOK: type: CREATETABLE
    198. 

  198. POSTHOOK: Output: alter3_db@alter3_src
    199. 

  199. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    200. 

  200. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    201. 

  201. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/test.dat' OVERWRITE INTO TABLE alter3_src
    202. 

  202. PREHOOK: type: LOAD
    203. 

  203. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/test.dat' OVERWRITE INTO TABLE alter3_src
    204. 

  204. POSTHOOK: type: LOAD
    205. 

  205. POSTHOOK: Output: alter3_db@alter3_src
    206. 

  206. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    207. 

  207. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    208. 

  208. PREHOOK: query: CREATE TABLE alter3 (col1 STRING) PARTITIONED BY (pcol1 STRING, pcol2 STRING) STORED AS SEQUENCEFILE
    209. 

  209. PREHOOK: type: CREATETABLE
    210. 

  210. POSTHOOK: query: CREATE TABLE alter3 (col1 STRING) PARTITIONED BY (pcol1 STRING, pcol2 STRING) STORED AS SEQUENCEFILE
    211. 

  211. POSTHOOK: type: CREATETABLE
    212. 

  212. POSTHOOK: Output: alter3_db@alter3
    213. 

  213. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    214. 

  214. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    215. 

  215. PREHOOK: query: CREATE TABLE alter3_like LIKE alter3
    216. 

  216. PREHOOK: type: CREATETABLE
    217. 

  217. POSTHOOK: query: CREATE TABLE alter3_like LIKE alter3
    218. 

  218. POSTHOOK: type: CREATETABLE
    219. 

  219. POSTHOOK: Output: alter3_db@alter3_like
    220. 

  220. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    221. 

  221. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    222. 

  222. PREHOOK: query: INSERT OVERWRITE TABLE alter3 PARTITION (pCol1='test_part:', pcol2='test_part:') SELECT col1 FROM alter3_src
    223. 

  223. PREHOOK: type: QUERY
    224. 

  224. PREHOOK: Input: alter3_db@alter3_src
    225. 

  225. PREHOOK: Output: alter3_db@alter3@pcol1=test_part%3A/pcol2=test_part%3A
    226. 

  226. POSTHOOK: query: INSERT OVERWRITE TABLE alter3 PARTITION (pCol1='test_part:', pcol2='test_part:') SELECT col1 FROM alter3_src
    227. 

  227. POSTHOOK: type: QUERY
    228. 

  228. POSTHOOK: Input: alter3_db@alter3_src
    229. 

  229. POSTHOOK: Output: alter3_db@alter3@pcol1=test_part%3A/pcol2=test_part%3A
    230. 

  230. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    231. 

  231. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    232. 

  232. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    233. 

  233. PREHOOK: query: SELECT * FROM alter3 WHERE pcol1='test_part:' AND pcol2='test_part:'
    234. 

  234. PREHOOK: type: QUERY
    235. 

  235. PREHOOK: Input: alter3_db@alter3@pcol1=test_part%3A/pcol2=test_part%3A
    236. 

  236. PREHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-43-08_855_2995903611671905194/-mr-10000
    237. 

  237. POSTHOOK: query: SELECT * FROM alter3 WHERE pcol1='test_part:' AND pcol2='test_part:'
    238. 

  238. POSTHOOK: type: QUERY
    239. 

  239. POSTHOOK: Input: alter3_db@alter3@pcol1=test_part%3A/pcol2=test_part%3A
    240. 

  240. POSTHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-43-08_855_2995903611671905194/-mr-10000
    241. 

  241. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    242. 

  242. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    243. 

  243. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    244. 

  244. 1	test_part:	test_part:
    245. 

  245. 2	test_part:	test_part:
    246. 

  246. 3	test_part:	test_part:
    247. 

  247. 4	test_part:	test_part:
    248. 

  248. 5	test_part:	test_part:
    249. 

  249. 6	test_part:	test_part:
    250. 

  250. PREHOOK: query: ALTER TABLE alter3 RENAME TO alter3_renamed
    251. 

  251. PREHOOK: type: ALTERTABLE_RENAME
    252. 

  252. PREHOOK: Input: alter3_db@alter3
    253. 

  253. PREHOOK: Output: alter3_db@alter3
    254. 

  254. POSTHOOK: query: ALTER TABLE alter3 RENAME TO alter3_renamed
    255. 

  255. POSTHOOK: type: ALTERTABLE_RENAME
    256. 

  256. POSTHOOK: Input: alter3_db@alter3
    257. 

  257. POSTHOOK: Output: alter3_db@alter3
    258. 

  258. POSTHOOK: Output: alter3_db@alter3_renamed
    259. 

  259. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    260. 

  260. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    261. 

  261. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    262. 

  262. PREHOOK: query: DESCRIBE EXTENDED alter3_renamed
    263. 

  263. PREHOOK: type: DESCTABLE
    264. 

  264. POSTHOOK: query: DESCRIBE EXTENDED alter3_renamed
    265. 

  265. POSTHOOK: type: DESCTABLE
    266. 

  266. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    267. 

  267. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    268. 

  268. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    269. 

  269. col1	string	
    270. 

  270. pcol1	string	
    271. 

  271. pcol2	string	
    272. 

  272. 	 	 
    273. 

  273. Detailed Table Information	Table(tableName:alter3_renamed, dbName:alter3_db, owner:pyang, createTime:1296517384, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/data/users/pyang/trunk/VENDOR.hive/trunk/build/ql/test/data/warehouse/alter3_db.db/alter3_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, last_modified_by=pyang, last_modified_time=1296517389, transient_lastDdlTime=1296517389, numRows=6, totalSize=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    274. 

  274. PREHOOK: query: DESCRIBE EXTENDED alter3_renamed PARTITION (pCol1='test_part:', pcol2='test_part:')
    275. 

  275. PREHOOK: type: DESCTABLE
    276. 

  276. POSTHOOK: query: DESCRIBE EXTENDED alter3_renamed PARTITION (pCol1='test_part:', pcol2='test_part:')
    277. 

  277. POSTHOOK: type: DESCTABLE
    278. 

  278. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    279. 

  279. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    280. 

  280. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    281. 

  281. col1	string	
    282. 

  282. pcol1	string	
    283. 

  283. pcol2	string	
    284. 

  284. 	 	 
    285. 

  285. Detailed Partition Information	Partition(values:[test_part:, test_part:], dbName:alter3_db, tableName:alter3_renamed, createTime:1296517388, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null)], location:pfile:/data/users/pyang/trunk/VENDOR.hive/trunk/build/ql/test/data/warehouse/alter3_db.db/alter3_renamed/pcol1=test_part%3A/pcol2=test_part%3A, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{numFiles=1, transient_lastDdlTime=1296517388, numRows=6, totalSize=171})	
    286. 

  286. PREHOOK: query: SELECT * FROM alter3_renamed WHERE pcol1='test_part:' AND pcol2='test_part:'
    287. 

  287. PREHOOK: type: QUERY
    288. 

  288. PREHOOK: Input: alter3_db@alter3_renamed@pcol1=test_part%3A/pcol2=test_part%3A
    289. 

  289. PREHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-43-09_500_3780714796605710611/-mr-10000
    290. 

  290. POSTHOOK: query: SELECT * FROM alter3_renamed WHERE pcol1='test_part:' AND pcol2='test_part:'
    291. 

  291. POSTHOOK: type: QUERY
    292. 

  292. POSTHOOK: Input: alter3_db@alter3_renamed@pcol1=test_part%3A/pcol2=test_part%3A
    293. 

  293. POSTHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-43-09_500_3780714796605710611/-mr-10000
    294. 

  294. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    295. 

  295. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    296. 

  296. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    297. 

  297. 1	test_part:	test_part:
    298. 

  298. 2	test_part:	test_part:
    299. 

  299. 3	test_part:	test_part:
    300. 

  300. 4	test_part:	test_part:
    301. 

  301. 5	test_part:	test_part:
    302. 

  302. 6	test_part:	test_part:
    303. 

  303. PREHOOK: query: INSERT OVERWRITE TABLE alter3_like
    304. 

  304. PARTITION (pCol1='test_part:', pcol2='test_part:')
    305. 

  305. SELECT col1 FROM alter3_src
    306. 

  306. PREHOOK: type: QUERY
    307. 

  307. PREHOOK: Input: alter3_db@alter3_src
    308. 

  308. PREHOOK: Output: alter3_db@alter3_like@pcol1=test_part%3A/pcol2=test_part%3A
    309. 

  309. POSTHOOK: query: INSERT OVERWRITE TABLE alter3_like
    310. 

  310. PARTITION (pCol1='test_part:', pcol2='test_part:')
    311. 

  311. SELECT col1 FROM alter3_src
    312. 

  312. POSTHOOK: type: QUERY
    313. 

  313. POSTHOOK: Input: alter3_db@alter3_src
    314. 

  314. POSTHOOK: Output: alter3_db@alter3_like@pcol1=test_part%3A/pcol2=test_part%3A
    315. 

  315. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    316. 

  316. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    317. 

  317. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    318. 

  318. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    319. 

  319. PREHOOK: query: ALTER TABLE alter3_like RENAME TO alter3_like_renamed
    320. 

  320. PREHOOK: type: ALTERTABLE_RENAME
    321. 

  321. PREHOOK: Input: alter3_db@alter3_like
    322. 

  322. PREHOOK: Output: alter3_db@alter3_like
    323. 

  323. POSTHOOK: query: ALTER TABLE alter3_like RENAME TO alter3_like_renamed
    324. 

  324. POSTHOOK: type: ALTERTABLE_RENAME
    325. 

  325. POSTHOOK: Input: alter3_db@alter3_like
    326. 

  326. POSTHOOK: Output: alter3_db@alter3_like
    327. 

  327. POSTHOOK: Output: alter3_db@alter3_like_renamed
    328. 

  328. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    329. 

  329. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    330. 

  330. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    331. 

  331. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    332. 

  332. PREHOOK: query: DESCRIBE EXTENDED alter3_like_renamed
    333. 

  333. PREHOOK: type: DESCTABLE
    334. 

  334. POSTHOOK: query: DESCRIBE EXTENDED alter3_like_renamed
    335. 

  335. POSTHOOK: type: DESCTABLE
    336. 

  336. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    337. 

  337. POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    338. 

  338. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    339. 

  339. POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
    340. 

  340. col1	string	
    341. 

  341. pcol1	string	
    342. 

  342. pcol2	string	
    343. 

  343. 	 	 
    344. 

  344. Detailed Table Information	Table(tableName:alter3_like_renamed, dbName:alter3_db, owner:pyang, createTime:1296517384, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/data/users/pyang/trunk/VENDOR.hive/trunk/build/ql/test/data/warehouse/alter3_db.db/alter3_like_renamed, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, last_modified_by=pyang, last_modified_time=1296517393, transient_lastDdlTime=1296517393, numRows=6, totalSize=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    345. 

  345.