CREATE TABLE custom_playlog (
seqid BIGINT,
status INT,
profileid INT,
trackid INT,
playdate STRING,
sessionid STRING,
playerkey STRING,
usersubscriptionid INT,
terminalid INT,
clientname STRING,
cached STRING,
reported_date STRING,
deviceid STRING,
devicename STRING,
playedfrom STRING,
stationid STRING
)
PARTITIONED BY (dt string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
STORED AS RCFILE;