· 6 years ago · Apr 22, 2019, 06:12 AM
1CREATE TABLE IF NOT EXISTS DE.HISTORICAL_USED_PRICING (
2 ...
3 P.PRICE INTEGER, -- Dummy column to declare column family for price, price will be upserted into column named price_yyyyMMdd accordingly.
4 O.ODOMETER INTEGER, -- Dummy column to declare column family for odometer, odometer will be upserted into column named odometer_yyyyMMdd accordingly.
5 ...
6);