facts.hql

CREATE TABLE facts (
dimension1 STRING,
dimension3 STRING,
dimension4 STRING,
timestamp2 TIMESTAMP,
measure1 DECIMAL,
measure2 DECIMAL,
measure3 DECIMAL
) PARTITIONED BY(dimension2 STRING, timestamp1 TIMESTAMP)
CLUSTERED BY(dimension1) INTO 32 BUCKETS;

insert_select.hql

INSERT INTO TABLE facts PARTITION (dimension2, timestamp1) SELECT dimension1, dimension3, dimension4, timestamp2, measure1, measure2, measure3 FROM raw_facts;