PageRenderTime 26ms CodeModel.GetById 12ms app.highlight 6ms RepoModel.GetById 2ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/hbase-handler/src/test/results/hbase_stats.q.out

#
text | 246 lines | 228 code | 18 blank | 0 comment | 0 complexity | e3664e2e1a85e7e27f34e8e1eb92e532 MD5 | raw file
  1PREHOOK: query: create table stats_src like src
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: create table stats_src like src
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@stats_src
  6PREHOOK: query: insert overwrite table stats_src select * from src
  7PREHOOK: type: QUERY
  8PREHOOK: Input: default@src
  9PREHOOK: Output: default@stats_src
 10POSTHOOK: query: insert overwrite table stats_src select * from src
 11POSTHOOK: type: QUERY
 12POSTHOOK: Input: default@src
 13POSTHOOK: Output: default@stats_src
 14POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 15POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 16PREHOOK: query: analyze table stats_src compute statistics
 17PREHOOK: type: QUERY
 18PREHOOK: Input: default@stats_src
 19PREHOOK: Output: default@stats_src
 20POSTHOOK: query: analyze table stats_src compute statistics
 21POSTHOOK: type: QUERY
 22POSTHOOK: Input: default@stats_src
 23POSTHOOK: Output: default@stats_src
 24POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 25POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 26PREHOOK: query: desc formatted stats_src
 27PREHOOK: type: DESCTABLE
 28POSTHOOK: query: desc formatted stats_src
 29POSTHOOK: type: DESCTABLE
 30POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 31POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 32# col_name            	data_type           	comment             
 33	 	 
 34key                 	string              	default             
 35value               	string              	default             
 36	 	 
 37# Detailed Table Information	 	 
 38Database:           	default             	 
 39Owner:              	null                	 
 40CreateTime:         	Tue Jan 25 14:48:20 PST 2011	 
 41LastAccessTime:     	UNKNOWN             	 
 42Protect Mode:       	None                	 
 43Retention:          	0                   	 
 44Location:           	pfile:/data/users/jsichi/open/hive-trunk/build/hbase-handler/test/data/warehouse/stats_src	 
 45Table Type:         	MANAGED_TABLE       	 
 46Table Parameters:	 	 
 47	transient_lastDdlTime	1295995714          
 48	 	 
 49# Storage Information	 	 
 50SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
 51InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
 52OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
 53Compressed:         	No                  	 
 54Num Buckets:        	-1                  	 
 55Bucket Columns:     	[]                  	 
 56Sort Columns:       	[]                  	 
 57Storage Desc Params:	 	 
 58	serialization.format	1                   
 59PREHOOK: query: create table hbase_part like srcpart
 60PREHOOK: type: CREATETABLE
 61POSTHOOK: query: create table hbase_part like srcpart
 62POSTHOOK: type: CREATETABLE
 63POSTHOOK: Output: default@hbase_part
 64POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 65POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 66PREHOOK: query: insert overwrite table hbase_part partition (ds='2010-04-08', hr = '11') select key, value from src
 67PREHOOK: type: QUERY
 68PREHOOK: Input: default@src
 69PREHOOK: Output: default@hbase_part@ds=2010-04-08/hr=11
 70POSTHOOK: query: insert overwrite table hbase_part partition (ds='2010-04-08', hr = '11') select key, value from src
 71POSTHOOK: type: QUERY
 72POSTHOOK: Input: default@src
 73POSTHOOK: Output: default@hbase_part@ds=2010-04-08/hr=11
 74POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 75POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 76POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 77POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 78PREHOOK: query: insert overwrite table hbase_part partition (ds='2010-04-08', hr = '12') select key, value from src
 79PREHOOK: type: QUERY
 80PREHOOK: Input: default@src
 81PREHOOK: Output: default@hbase_part@ds=2010-04-08/hr=12
 82POSTHOOK: query: insert overwrite table hbase_part partition (ds='2010-04-08', hr = '12') select key, value from src
 83POSTHOOK: type: QUERY
 84POSTHOOK: Input: default@src
 85POSTHOOK: Output: default@hbase_part@ds=2010-04-08/hr=12
 86POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 87POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 88POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 89POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 90POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 91POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 92PREHOOK: query: analyze table hbase_part partition(ds='2008-04-08', hr=11) compute statistics
 93PREHOOK: type: QUERY
 94PREHOOK: Input: default@hbase_part@ds=2008-04-08/hr=11
 95PREHOOK: Output: default@hbase_part
 96POSTHOOK: query: analyze table hbase_part partition(ds='2008-04-08', hr=11) compute statistics
 97POSTHOOK: type: QUERY
 98POSTHOOK: Input: default@hbase_part@ds=2008-04-08/hr=11
 99POSTHOOK: Output: default@hbase_part
100POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
101POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
102POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
103POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
104POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
105POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
106PREHOOK: query: analyze table hbase_part partition(ds='2008-04-08', hr=12) compute statistics
107PREHOOK: type: QUERY
108PREHOOK: Input: default@hbase_part@ds=2008-04-08/hr=12
109PREHOOK: Output: default@hbase_part
110POSTHOOK: query: analyze table hbase_part partition(ds='2008-04-08', hr=12) compute statistics
111POSTHOOK: type: QUERY
112POSTHOOK: Input: default@hbase_part@ds=2008-04-08/hr=12
113POSTHOOK: Output: default@hbase_part
114POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
115POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
116POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
117POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
118POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
119POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
120PREHOOK: query: desc formatted hbase_part
121PREHOOK: type: DESCTABLE
122POSTHOOK: query: desc formatted hbase_part
123POSTHOOK: type: DESCTABLE
124POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
125POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
126POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
127POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
128POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
129POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
130# col_name            	data_type           	comment             
131	 	 
132key                 	string              	default             
133value               	string              	default             
134	 	 
135# Partition Information	 	 
136# col_name            	data_type           	comment             
137	 	 
138ds                  	string              	None                
139hr                  	string              	None                
140	 	 
141# Detailed Table Information	 	 
142Database:           	default             	 
143Owner:              	null                	 
144CreateTime:         	Tue Jan 25 14:49:11 PST 2011	 
145LastAccessTime:     	UNKNOWN             	 
146Protect Mode:       	None                	 
147Retention:          	0                   	 
148Location:           	pfile:/data/users/jsichi/open/hive-trunk/build/hbase-handler/test/data/warehouse/hbase_part	 
149Table Type:         	MANAGED_TABLE       	 
150Table Parameters:	 	 
151	transient_lastDdlTime	1295995751          
152	 	 
153# Storage Information	 	 
154SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
155InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
156OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
157Compressed:         	No                  	 
158Num Buckets:        	-1                  	 
159Bucket Columns:     	[]                  	 
160Sort Columns:       	[]                  	 
161Storage Desc Params:	 	 
162	serialization.format	1                   
163PREHOOK: query: desc formatted hbase_part partition (ds='2010-04-08', hr = '11')
164PREHOOK: type: DESCTABLE
165POSTHOOK: query: desc formatted hbase_part partition (ds='2010-04-08', hr = '11')
166POSTHOOK: type: DESCTABLE
167POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
168POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
169POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
170POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
171POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
172POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
173# col_name            	data_type           	comment             
174	 	 
175key                 	string              	default             
176value               	string              	default             
177	 	 
178# Partition Information	 	 
179# col_name            	data_type           	comment             
180	 	 
181ds                  	string              	None                
182hr                  	string              	None                
183	 	 
184# Detailed Partition Information	 	 
185Partition Value:    	[2010-04-08, 11]    	 
186Database:           	default             	 
187Table:              	hbase_part          	 
188CreateTime:         	Tue Jan 25 14:49:26 PST 2011	 
189LastAccessTime:     	UNKNOWN             	 
190Protect Mode:       	None                	 
191Location:           	pfile:/data/users/jsichi/open/hive-trunk/build/hbase-handler/test/data/warehouse/hbase_part/ds=2010-04-08/hr=11	 
192Partition Parameters:	 	 
193	transient_lastDdlTime	1295995766          
194	 	 
195# Storage Information	 	 
196SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
197InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
198OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
199Compressed:         	No                  	 
200Num Buckets:        	-1                  	 
201Bucket Columns:     	[]                  	 
202Sort Columns:       	[]                  	 
203Storage Desc Params:	 	 
204	serialization.format	1                   
205PREHOOK: query: desc formatted hbase_part partition (ds='2010-04-08', hr = '12')
206PREHOOK: type: DESCTABLE
207POSTHOOK: query: desc formatted hbase_part partition (ds='2010-04-08', hr = '12')
208POSTHOOK: type: DESCTABLE
209POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
210POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
211POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
212POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
213POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
214POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
215# col_name            	data_type           	comment             
216	 	 
217key                 	string              	default             
218value               	string              	default             
219	 	 
220# Partition Information	 	 
221# col_name            	data_type           	comment             
222	 	 
223ds                  	string              	None                
224hr                  	string              	None                
225	 	 
226# Detailed Partition Information	 	 
227Partition Value:    	[2010-04-08, 12]    	 
228Database:           	default             	 
229Table:              	hbase_part          	 
230CreateTime:         	Tue Jan 25 14:49:52 PST 2011	 
231LastAccessTime:     	UNKNOWN             	 
232Protect Mode:       	None                	 
233Location:           	pfile:/data/users/jsichi/open/hive-trunk/build/hbase-handler/test/data/warehouse/hbase_part/ds=2010-04-08/hr=12	 
234Partition Parameters:	 	 
235	transient_lastDdlTime	1295995792          
236	 	 
237# Storage Information	 	 
238SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
239InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
240OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
241Compressed:         	No                  	 
242Num Buckets:        	-1                  	 
243Bucket Columns:     	[]                  	 
244Sort Columns:       	[]                  	 
245Storage Desc Params:	 	 
246	serialization.format	1