CREATE EXTERNAL TABLE userinfo0921(
userid INT,
username STRING,
Gender STRING, referrer_url STRING,
age STRING COMMENT 'IP Address of the User',
height STRING COMMENT 'country of origination')
PARTITIONED BY (day_id string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
STORED AS TEXTFILE
LOCATION '/test/mh0921';
