PageRenderTime 19ms CodeModel.GetById 14ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 66 lines | 62 code | 4 blank | 0 comment | 0 complexity | ab415f058624ae829d3c38bab9592157 MD5 | raw file
 1PREHOOK: query: CREATE TABLE rcfile_default_format (key STRING)
 2PREHOOK: type: CREATETABLE
 3POSTHOOK: query: CREATE TABLE rcfile_default_format (key STRING)
 4POSTHOOK: type: CREATETABLE
 5POSTHOOK: Output: default@rcfile_default_format
 6PREHOOK: query: DESCRIBE EXTENDED rcfile_default_format
 7PREHOOK: type: DESCTABLE
 8POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format
 9POSTHOOK: type: DESCTABLE
10key	string	from deserializer
11	 	 
12Detailed Table Information	Table(tableName:rcfile_default_format, dbName:default, owner:heyongqiang, createTime:1290106787, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/rcfile_default_format, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1290106787}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
13PREHOOK: query: CREATE TABLE rcfile_default_format_ctas AS SELECT key,value FROM src
14PREHOOK: type: CREATETABLE_AS_SELECT
15PREHOOK: Input: default@src
16POSTHOOK: query: CREATE TABLE rcfile_default_format_ctas AS SELECT key,value FROM src
17POSTHOOK: type: CREATETABLE_AS_SELECT
18POSTHOOK: Input: default@src
19POSTHOOK: Output: default@rcfile_default_format_ctas
20PREHOOK: query: DESCRIBE EXTENDED rcfile_default_format_ctas
21PREHOOK: type: DESCTABLE
22POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_ctas
23POSTHOOK: type: DESCTABLE
24key	string	from deserializer
25value	string	from deserializer
26	 	 
27Detailed Table Information	Table(tableName:rcfile_default_format_ctas, dbName:default, owner:heyongqiang, createTime:1290106793, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/rcfile_default_format_ctas, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1290106793}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
28PREHOOK: query: CREATE TABLE rcfile_default_format_txtfile (key STRING) STORED AS TEXTFILE
29PREHOOK: type: CREATETABLE
30POSTHOOK: query: CREATE TABLE rcfile_default_format_txtfile (key STRING) STORED AS TEXTFILE
31POSTHOOK: type: CREATETABLE
32POSTHOOK: Output: default@rcfile_default_format_txtfile
33PREHOOK: query: INSERT OVERWRITE TABLE rcfile_default_format_txtfile SELECT key from src
34PREHOOK: type: QUERY
35PREHOOK: Input: default@src
36PREHOOK: Output: default@rcfile_default_format_txtfile
37POSTHOOK: query: INSERT OVERWRITE TABLE rcfile_default_format_txtfile SELECT key from src
38POSTHOOK: type: QUERY
39POSTHOOK: Input: default@src
40POSTHOOK: Output: default@rcfile_default_format_txtfile
41POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
42PREHOOK: query: DESCRIBE EXTENDED rcfile_default_format_txtfile
43PREHOOK: type: DESCTABLE
44POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_txtfile
45POSTHOOK: type: DESCTABLE
46POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
47key	string	
48	 	 
49Detailed Table Information	Table(tableName:rcfile_default_format_txtfile, dbName:default, owner:heyongqiang, createTime:1290106794, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/rcfile_default_format_txtfile, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{numPartitions=0, numFiles=1, transient_lastDdlTime=1290106803, numRows=500, totalSize=1906}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
50PREHOOK: query: CREATE TABLE textfile_default_format_ctas AS SELECT key,value FROM rcfile_default_format_ctas
51PREHOOK: type: CREATETABLE_AS_SELECT
52PREHOOK: Input: default@rcfile_default_format_ctas
53POSTHOOK: query: CREATE TABLE textfile_default_format_ctas AS SELECT key,value FROM rcfile_default_format_ctas
54POSTHOOK: type: CREATETABLE_AS_SELECT
55POSTHOOK: Input: default@rcfile_default_format_ctas
56POSTHOOK: Output: default@textfile_default_format_ctas
57POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
58PREHOOK: query: DESCRIBE EXTENDED textfile_default_format_ctas
59PREHOOK: type: DESCTABLE
60POSTHOOK: query: DESCRIBE EXTENDED textfile_default_format_ctas
61POSTHOOK: type: DESCTABLE
62POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
63key	string	
64value	string	
65	 	 
66Detailed Table Information	Table(tableName:textfile_default_format_ctas, dbName:default, owner:heyongqiang, createTime:1290106809, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/textfile_default_format_ctas, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1290106809}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)