CREATE TABLE stocks2  ( 
	symbol    	string, 
	ymd       	string, 
	price_open	float)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
stored as orc TBLPROPERTIES ('transactional'='true')
GO

ALTER TABLE stocks2
CLUSTERED BY (symbol,price_open)
INTO 51 BUCKETS
Go