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<BIGINT>, properties MAP<STRING, STRING>,
                       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
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<BIGINT>, properties MAP<STRING, STRING>,
                       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: default@INPUTDDL4
PREHOOK: query: DESCRIBE INPUTDDL4
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL4
POSTHOOK: type: DESCTABLE
viewtime            	string              	None                
userid              	int                 	None                
page_url            	string              	None                
referrer_url        	string              	None                
friends             	array<bigint>       	None                
properties          	map<string,string>  	None                
ip                  	string              	IP Address of the User
ds                  	string              	None                
country             	string              	None                
	 	 
# Partition Information	 	 
# col_name            	data_type           	comment             
	 	 
ds                  	string              	None                
country             	string              	None                
PREHOOK: query: DESCRIBE EXTENDED INPUTDDL4
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL4
POSTHOOK: type: DESCTABLE
viewtime            	string              	None                
userid              	int                 	None                
page_url            	string              	None                
referrer_url        	string              	None                
friends             	array<bigint>       	None                
properties          	map<string,string>  	None                
ip                  	string              	IP Address of the User
ds                  	string              	None                
country             	string              	None                
	 	 
# Partition Information	 	 
# col_name            	data_type           	comment             
	 	 
ds                  	string              	None                
country             	string              	None                
	 	 
#### A masked pattern was here ####