PREHOOK: query: -- a simple test to test sorted/clustered syntax CREATE TABLE INPUTDDL4(viewTime STRING, userid INT, page_url STRING, referrer_url STRING, friends ARRAY, properties MAP, ip STRING COMMENT 'IP Address of the User') COMMENT 'This is the page view table' PARTITIONED BY(ds STRING, country STRING) CLUSTERED BY(userid) SORTED BY(viewTime) INTO 32 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@INPUTDDL4 POSTHOOK: query: -- a simple test to test sorted/clustered syntax CREATE TABLE INPUTDDL4(viewTime STRING, userid INT, page_url STRING, referrer_url STRING, friends ARRAY, properties MAP, ip STRING COMMENT 'IP Address of the User') COMMENT 'This is the page view table' PARTITIONED BY(ds STRING, country STRING) CLUSTERED BY(userid) SORTED BY(viewTime) INTO 32 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@INPUTDDL4 PREHOOK: query: DESCRIBE INPUTDDL4 PREHOOK: type: DESCTABLE PREHOOK: Input: default@inputddl4 POSTHOOK: query: DESCRIBE INPUTDDL4 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@inputddl4 viewtime string userid int page_url string referrer_url string friends array properties map ip string IP Address of the User ds string country string # Partition Information # col_name data_type comment ds string country string PREHOOK: query: DESCRIBE EXTENDED INPUTDDL4 PREHOOK: type: DESCTABLE PREHOOK: Input: default@inputddl4 POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL4 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@inputddl4 viewtime string userid int page_url string referrer_url string friends array properties map ip string IP Address of the User ds string country string # Partition Information # col_name data_type comment ds string country string #### A masked pattern was here ####