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

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/inputddl4.q.out

#
text | 49 lines | 46 code | 3 blank | 0 comment | 0 complexity | 58a1ced88eed01af5ae1c9615ba3988d MD5 | raw file
 1PREHOOK: query: -- a simple test to test sorted/clustered syntax
 2
 3CREATE TABLE INPUTDDL4(viewTime STRING, userid INT,
 4                       page_url STRING, referrer_url STRING, 
 5                       friends ARRAY<BIGINT>, properties MAP<STRING, STRING>,
 6                       ip STRING COMMENT 'IP Address of the User') 
 7    COMMENT 'This is the page view table' 
 8    PARTITIONED BY(ds STRING, country STRING) 
 9    CLUSTERED BY(userid) SORTED BY(viewTime) INTO 32 BUCKETS
10PREHOOK: type: CREATETABLE
11POSTHOOK: query: -- a simple test to test sorted/clustered syntax
12
13CREATE TABLE INPUTDDL4(viewTime STRING, userid INT,
14                       page_url STRING, referrer_url STRING, 
15                       friends ARRAY<BIGINT>, properties MAP<STRING, STRING>,
16                       ip STRING COMMENT 'IP Address of the User') 
17    COMMENT 'This is the page view table' 
18    PARTITIONED BY(ds STRING, country STRING) 
19    CLUSTERED BY(userid) SORTED BY(viewTime) INTO 32 BUCKETS
20POSTHOOK: type: CREATETABLE
21POSTHOOK: Output: default@INPUTDDL4
22PREHOOK: query: DESCRIBE INPUTDDL4
23PREHOOK: type: DESCTABLE
24POSTHOOK: query: DESCRIBE INPUTDDL4
25POSTHOOK: type: DESCTABLE
26viewtime	string	
27userid	int	
28page_url	string	
29referrer_url	string	
30friends	array<bigint>	
31properties	map<string,string>	
32ip	string	IP Address of the User
33ds	string	
34country	string	
35PREHOOK: query: DESCRIBE EXTENDED INPUTDDL4
36PREHOOK: type: DESCTABLE
37POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL4
38POSTHOOK: type: DESCTABLE
39viewtime	string	
40userid	int	
41page_url	string	
42referrer_url	string	
43friends	array<bigint>	
44properties	map<string,string>	
45ip	string	IP Address of the User
46ds	string	
47country	string	
48	 	 
49Detailed Table Information	Table(tableName:inputddl4, dbName:default, owner:thiruvel, createTime:1286798568, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:viewtime, type:string, comment:null), FieldSchema(name:userid, type:int, comment:null), FieldSchema(name:page_url, type:string, comment:null), FieldSchema(name:referrer_url, type:string, comment:null), FieldSchema(name:friends, type:array<bigint>, comment:null), FieldSchema(name:properties, type:map<string,string>, comment:null), FieldSchema(name:ip, type:string, comment:IP Address of the User), FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:country, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/inputddl4, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:32, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[userid], sortCols:[Order(col:viewtime, order:1)], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:country, type:string, comment:null)], parameters:{transient_lastDdlTime=1286798568, comment=This is the page view table}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)