PageRenderTime 16ms CodeModel.GetById 12ms app.highlight 1ms RepoModel.GetById 2ms app.codeStats 0ms

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

#
text | 38 lines | 35 code | 3 blank | 0 comment | 0 complexity | 7fa1fd8bc072524083e08952e6e4fcc6 MD5 | raw file
 1PREHOOK: query: CREATE TABLE table_p1 (a STRING)
 2PREHOOK: type: CREATETABLE
 3POSTHOOK: query: CREATE TABLE table_p1 (a STRING)
 4POSTHOOK: type: CREATETABLE
 5POSTHOOK: Output: default@table_p1
 6PREHOOK: query: DESC EXTENDED table_p1
 7PREHOOK: type: DESCTABLE
 8POSTHOOK: query: DESC EXTENDED table_p1
 9POSTHOOK: type: DESCTABLE
10a	string	
11	 	 
12Detailed Table Information	Table(tableName:table_p1, dbName:default, owner:heyongqiang, createTime:1290111690, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table_p1, 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:{p1=v1, transient_lastDdlTime=1290111690, P2=v21=v22=v23}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
13PREHOOK: query: CREATE TABLE table_p2 LIKE table_p1
14PREHOOK: type: CREATETABLE
15POSTHOOK: query: CREATE TABLE table_p2 LIKE table_p1
16POSTHOOK: type: CREATETABLE
17POSTHOOK: Output: default@table_p2
18PREHOOK: query: DESC EXTENDED table_p2
19PREHOOK: type: DESCTABLE
20POSTHOOK: query: DESC EXTENDED table_p2
21POSTHOOK: type: DESCTABLE
22a	string	
23	 	 
24Detailed Table Information	Table(tableName:table_p2, dbName:default, owner:heyongqiang, createTime:1290111690, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table_p2, 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=1290111690}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
25PREHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1
26PREHOOK: type: CREATETABLE_AS_SELECT
27PREHOOK: Input: default@table_p1
28POSTHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1
29POSTHOOK: type: CREATETABLE_AS_SELECT
30POSTHOOK: Input: default@table_p1
31POSTHOOK: Output: default@table_p3
32PREHOOK: query: DESC EXTENDED table_p3
33PREHOOK: type: DESCTABLE
34POSTHOOK: query: DESC EXTENDED table_p3
35POSTHOOK: type: DESCTABLE
36a	string	
37	 	 
38Detailed Table Information	Table(tableName:table_p3, dbName:default, owner:heyongqiang, createTime:1290111696, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table_p3, 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:{p3=v3, transient_lastDdlTime=1290111696}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)