PageRenderTime 31ms CodeModel.GetById 12ms app.highlight 9ms RepoModel.GetById 1ms app.codeStats 1ms

/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
  1PREHOOK: query: create table alter3_src ( col1 string ) stored as textfile
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: create table alter3_src ( col1 string ) stored as textfile
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@alter3_src
  6PREHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table alter3_src
  7PREHOOK: type: LOAD
  8POSTHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table alter3_src
  9POSTHOOK: type: LOAD
 10POSTHOOK: Output: default@alter3_src
 11PREHOOK: query: create table alter3 ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile
 12PREHOOK: type: CREATETABLE
 13POSTHOOK: query: create table alter3 ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile
 14POSTHOOK: type: CREATETABLE
 15POSTHOOK: Output: default@alter3
 16PREHOOK: query: create table alter3_like like alter3
 17PREHOOK: type: CREATETABLE
 18POSTHOOK: query: create table alter3_like like alter3
 19POSTHOOK: type: CREATETABLE
 20POSTHOOK: Output: default@alter3_like
 21PREHOOK: query: insert overwrite table alter3 partition (pCol1='test_part:', pcol2='test_part:') select col1 from alter3_src
 22PREHOOK: type: QUERY
 23PREHOOK: Input: default@alter3_src
 24PREHOOK: Output: default@alter3@pcol1=test_part%3A/pcol2=test_part%3A
 25POSTHOOK: query: insert overwrite table alter3 partition (pCol1='test_part:', pcol2='test_part:') select col1 from alter3_src
 26POSTHOOK: type: QUERY
 27POSTHOOK: Input: default@alter3_src
 28POSTHOOK: Output: default@alter3@pcol1=test_part%3A/pcol2=test_part%3A
 29POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
 30PREHOOK: query: select * from alter3 where pcol1='test_part:' and pcol2='test_part:'
 31PREHOOK: type: QUERY
 32PREHOOK: Input: default@alter3@pcol1=test_part%3A/pcol2=test_part%3A
 33PREHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-42-57_025_6359929124129148420/-mr-10000
 34POSTHOOK: query: select * from alter3 where pcol1='test_part:' and pcol2='test_part:'
 35POSTHOOK: type: QUERY
 36POSTHOOK: Input: default@alter3@pcol1=test_part%3A/pcol2=test_part%3A
 37POSTHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-42-57_025_6359929124129148420/-mr-10000
 38POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
 391	test_part:	test_part:
 402	test_part:	test_part:
 413	test_part:	test_part:
 424	test_part:	test_part:
 435	test_part:	test_part:
 446	test_part:	test_part:
 45PREHOOK: query: alter table alter3 rename to alter3_renamed
 46PREHOOK: type: ALTERTABLE_RENAME
 47PREHOOK: Input: default@alter3
 48PREHOOK: Output: default@alter3
 49POSTHOOK: query: alter table alter3 rename to alter3_renamed
 50POSTHOOK: type: ALTERTABLE_RENAME
 51POSTHOOK: Input: default@alter3
 52POSTHOOK: Output: default@alter3
 53POSTHOOK: Output: default@alter3_renamed
 54POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
 55PREHOOK: query: describe extended alter3_renamed
 56PREHOOK: type: DESCTABLE
 57POSTHOOK: query: describe extended alter3_renamed
 58POSTHOOK: type: DESCTABLE
 59POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
 60col1	string	
 61pcol1	string	
 62pcol2	string	
 63	 	 
 64Detailed 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)	
 65PREHOOK: query: describe extended alter3_renamed partition (pCol1='test_part:', pcol2='test_part:')
 66PREHOOK: type: DESCTABLE
 67POSTHOOK: query: describe extended alter3_renamed partition (pCol1='test_part:', pcol2='test_part:')
 68POSTHOOK: type: DESCTABLE
 69POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
 70col1	string	
 71pcol1	string	
 72pcol2	string	
 73	 	 
 74Detailed 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})	
 75PREHOOK: query: select * from alter3_renamed where pcol1='test_part:' and pcol2='test_part:'
 76PREHOOK: type: QUERY
 77PREHOOK: Input: default@alter3_renamed@pcol1=test_part%3A/pcol2=test_part%3A
 78PREHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-42-57_884_3547980406449617618/-mr-10000
 79POSTHOOK: query: select * from alter3_renamed where pcol1='test_part:' and pcol2='test_part:'
 80POSTHOOK: type: QUERY
 81POSTHOOK: Input: default@alter3_renamed@pcol1=test_part%3A/pcol2=test_part%3A
 82POSTHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-42-57_884_3547980406449617618/-mr-10000
 83POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
 841	test_part:	test_part:
 852	test_part:	test_part:
 863	test_part:	test_part:
 874	test_part:	test_part:
 885	test_part:	test_part:
 896	test_part:	test_part:
 90PREHOOK: query: insert overwrite table alter3_like
 91partition (pCol1='test_part:', pcol2='test_part:')
 92select col1 from alter3_src
 93PREHOOK: type: QUERY
 94PREHOOK: Input: default@alter3_src
 95PREHOOK: Output: default@alter3_like@pcol1=test_part%3A/pcol2=test_part%3A
 96POSTHOOK: query: insert overwrite table alter3_like
 97partition (pCol1='test_part:', pcol2='test_part:')
 98select col1 from alter3_src
 99POSTHOOK: type: QUERY
100POSTHOOK: Input: default@alter3_src
101POSTHOOK: Output: default@alter3_like@pcol1=test_part%3A/pcol2=test_part%3A
102POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
103POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
104PREHOOK: query: alter table alter3_like rename to alter3_like_renamed
105PREHOOK: type: ALTERTABLE_RENAME
106PREHOOK: Input: default@alter3_like
107PREHOOK: Output: default@alter3_like
108POSTHOOK: query: alter table alter3_like rename to alter3_like_renamed
109POSTHOOK: type: ALTERTABLE_RENAME
110POSTHOOK: Input: default@alter3_like
111POSTHOOK: Output: default@alter3_like
112POSTHOOK: Output: default@alter3_like_renamed
113POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
114POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
115PREHOOK: query: describe extended alter3_like_renamed
116PREHOOK: type: DESCTABLE
117POSTHOOK: query: describe extended alter3_like_renamed
118POSTHOOK: type: DESCTABLE
119POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
120POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
121col1	string	
122pcol1	string	
123pcol2	string	
124	 	 
125Detailed 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)	
126PREHOOK: query: -- Cleanup
127DROP TABLE alter3_src
128PREHOOK: type: DROPTABLE
129PREHOOK: Input: default@alter3_src
130PREHOOK: Output: default@alter3_src
131POSTHOOK: query: -- Cleanup
132DROP TABLE alter3_src
133POSTHOOK: type: DROPTABLE
134POSTHOOK: Input: default@alter3_src
135POSTHOOK: Output: default@alter3_src
136POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
137POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
138PREHOOK: query: DROP TABLE alter3_renamed
139PREHOOK: type: DROPTABLE
140PREHOOK: Input: default@alter3_renamed
141PREHOOK: Output: default@alter3_renamed
142POSTHOOK: query: DROP TABLE alter3_renamed
143POSTHOOK: type: DROPTABLE
144POSTHOOK: Input: default@alter3_renamed
145POSTHOOK: Output: default@alter3_renamed
146POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
147POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
148PREHOOK: query: DROP TABLE alter3_like_renamed
149PREHOOK: type: DROPTABLE
150PREHOOK: Input: default@alter3_like_renamed
151PREHOOK: Output: default@alter3_like_renamed
152POSTHOOK: query: DROP TABLE alter3_like_renamed
153POSTHOOK: type: DROPTABLE
154POSTHOOK: Input: default@alter3_like_renamed
155POSTHOOK: Output: default@alter3_like_renamed
156POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
157POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
158PREHOOK: query: SHOW TABLES
159PREHOOK: type: SHOWTABLES
160POSTHOOK: query: SHOW TABLES
161POSTHOOK: type: SHOWTABLES
162POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
163POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
164src
165src1
166src_json
167src_sequencefile
168src_thrift
169srcbucket
170srcbucket2
171srcpart
172PREHOOK: query: -- With non-default Database
173
174CREATE DATABASE alter3_db
175PREHOOK: type: CREATEDATABASE
176POSTHOOK: query: -- With non-default Database
177
178CREATE DATABASE alter3_db
179POSTHOOK: type: CREATEDATABASE
180POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
181POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
182PREHOOK: query: USE alter3_db
183PREHOOK: type: SWITCHDATABASE
184POSTHOOK: query: USE alter3_db
185POSTHOOK: type: SWITCHDATABASE
186POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
187POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
188PREHOOK: query: SHOW TABLES
189PREHOOK: type: SHOWTABLES
190POSTHOOK: query: SHOW TABLES
191POSTHOOK: type: SHOWTABLES
192POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
193POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
194PREHOOK: query: CREATE TABLE alter3_src (col1 STRING) STORED AS TEXTFILE
195PREHOOK: type: CREATETABLE
196POSTHOOK: query: CREATE TABLE alter3_src (col1 STRING) STORED AS TEXTFILE
197POSTHOOK: type: CREATETABLE
198POSTHOOK: Output: alter3_db@alter3_src
199POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
200POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
201PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/test.dat' OVERWRITE INTO TABLE alter3_src
202PREHOOK: type: LOAD
203POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/test.dat' OVERWRITE INTO TABLE alter3_src
204POSTHOOK: type: LOAD
205POSTHOOK: Output: alter3_db@alter3_src
206POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
207POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
208PREHOOK: query: CREATE TABLE alter3 (col1 STRING) PARTITIONED BY (pcol1 STRING, pcol2 STRING) STORED AS SEQUENCEFILE
209PREHOOK: type: CREATETABLE
210POSTHOOK: query: CREATE TABLE alter3 (col1 STRING) PARTITIONED BY (pcol1 STRING, pcol2 STRING) STORED AS SEQUENCEFILE
211POSTHOOK: type: CREATETABLE
212POSTHOOK: Output: alter3_db@alter3
213POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
214POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
215PREHOOK: query: CREATE TABLE alter3_like LIKE alter3
216PREHOOK: type: CREATETABLE
217POSTHOOK: query: CREATE TABLE alter3_like LIKE alter3
218POSTHOOK: type: CREATETABLE
219POSTHOOK: Output: alter3_db@alter3_like
220POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
221POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
222PREHOOK: query: INSERT OVERWRITE TABLE alter3 PARTITION (pCol1='test_part:', pcol2='test_part:') SELECT col1 FROM alter3_src
223PREHOOK: type: QUERY
224PREHOOK: Input: alter3_db@alter3_src
225PREHOOK: Output: alter3_db@alter3@pcol1=test_part%3A/pcol2=test_part%3A
226POSTHOOK: query: INSERT OVERWRITE TABLE alter3 PARTITION (pCol1='test_part:', pcol2='test_part:') SELECT col1 FROM alter3_src
227POSTHOOK: type: QUERY
228POSTHOOK: Input: alter3_db@alter3_src
229POSTHOOK: Output: alter3_db@alter3@pcol1=test_part%3A/pcol2=test_part%3A
230POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
231POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
232POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
233PREHOOK: query: SELECT * FROM alter3 WHERE pcol1='test_part:' AND pcol2='test_part:'
234PREHOOK: type: QUERY
235PREHOOK: Input: alter3_db@alter3@pcol1=test_part%3A/pcol2=test_part%3A
236PREHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-43-08_855_2995903611671905194/-mr-10000
237POSTHOOK: query: SELECT * FROM alter3 WHERE pcol1='test_part:' AND pcol2='test_part:'
238POSTHOOK: type: QUERY
239POSTHOOK: Input: alter3_db@alter3@pcol1=test_part%3A/pcol2=test_part%3A
240POSTHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-43-08_855_2995903611671905194/-mr-10000
241POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
242POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
243POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
2441	test_part:	test_part:
2452	test_part:	test_part:
2463	test_part:	test_part:
2474	test_part:	test_part:
2485	test_part:	test_part:
2496	test_part:	test_part:
250PREHOOK: query: ALTER TABLE alter3 RENAME TO alter3_renamed
251PREHOOK: type: ALTERTABLE_RENAME
252PREHOOK: Input: alter3_db@alter3
253PREHOOK: Output: alter3_db@alter3
254POSTHOOK: query: ALTER TABLE alter3 RENAME TO alter3_renamed
255POSTHOOK: type: ALTERTABLE_RENAME
256POSTHOOK: Input: alter3_db@alter3
257POSTHOOK: Output: alter3_db@alter3
258POSTHOOK: Output: alter3_db@alter3_renamed
259POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
260POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
261POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
262PREHOOK: query: DESCRIBE EXTENDED alter3_renamed
263PREHOOK: type: DESCTABLE
264POSTHOOK: query: DESCRIBE EXTENDED alter3_renamed
265POSTHOOK: type: DESCTABLE
266POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
267POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
268POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
269col1	string	
270pcol1	string	
271pcol2	string	
272	 	 
273Detailed 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)	
274PREHOOK: query: DESCRIBE EXTENDED alter3_renamed PARTITION (pCol1='test_part:', pcol2='test_part:')
275PREHOOK: type: DESCTABLE
276POSTHOOK: query: DESCRIBE EXTENDED alter3_renamed PARTITION (pCol1='test_part:', pcol2='test_part:')
277POSTHOOK: type: DESCTABLE
278POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
279POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
280POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
281col1	string	
282pcol1	string	
283pcol2	string	
284	 	 
285Detailed 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})	
286PREHOOK: query: SELECT * FROM alter3_renamed WHERE pcol1='test_part:' AND pcol2='test_part:'
287PREHOOK: type: QUERY
288PREHOOK: Input: alter3_db@alter3_renamed@pcol1=test_part%3A/pcol2=test_part%3A
289PREHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-43-09_500_3780714796605710611/-mr-10000
290POSTHOOK: query: SELECT * FROM alter3_renamed WHERE pcol1='test_part:' AND pcol2='test_part:'
291POSTHOOK: type: QUERY
292POSTHOOK: Input: alter3_db@alter3_renamed@pcol1=test_part%3A/pcol2=test_part%3A
293POSTHOOK: Output: file:/tmp/pyang/hive_2011-01-31_15-43-09_500_3780714796605710611/-mr-10000
294POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
295POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
296POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
2971	test_part:	test_part:
2982	test_part:	test_part:
2993	test_part:	test_part:
3004	test_part:	test_part:
3015	test_part:	test_part:
3026	test_part:	test_part:
303PREHOOK: query: INSERT OVERWRITE TABLE alter3_like
304PARTITION (pCol1='test_part:', pcol2='test_part:')
305SELECT col1 FROM alter3_src
306PREHOOK: type: QUERY
307PREHOOK: Input: alter3_db@alter3_src
308PREHOOK: Output: alter3_db@alter3_like@pcol1=test_part%3A/pcol2=test_part%3A
309POSTHOOK: query: INSERT OVERWRITE TABLE alter3_like
310PARTITION (pCol1='test_part:', pcol2='test_part:')
311SELECT col1 FROM alter3_src
312POSTHOOK: type: QUERY
313POSTHOOK: Input: alter3_db@alter3_src
314POSTHOOK: Output: alter3_db@alter3_like@pcol1=test_part%3A/pcol2=test_part%3A
315POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
316POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
317POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
318POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
319PREHOOK: query: ALTER TABLE alter3_like RENAME TO alter3_like_renamed
320PREHOOK: type: ALTERTABLE_RENAME
321PREHOOK: Input: alter3_db@alter3_like
322PREHOOK: Output: alter3_db@alter3_like
323POSTHOOK: query: ALTER TABLE alter3_like RENAME TO alter3_like_renamed
324POSTHOOK: type: ALTERTABLE_RENAME
325POSTHOOK: Input: alter3_db@alter3_like
326POSTHOOK: Output: alter3_db@alter3_like
327POSTHOOK: Output: alter3_db@alter3_like_renamed
328POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
329POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
330POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
331POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
332PREHOOK: query: DESCRIBE EXTENDED alter3_like_renamed
333PREHOOK: type: DESCTABLE
334POSTHOOK: query: DESCRIBE EXTENDED alter3_like_renamed
335POSTHOOK: type: DESCTABLE
336POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
337POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
338POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
339POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
340col1	string	
341pcol1	string	
342pcol2	string	
343	 	 
344Detailed 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)