The following script is an example of how to create a base table events
, which contains columns event_id
, app_id
, time
, user_id
, device_id
, platform
, sdk_version
, and version_code
. Note that the table is partitioned on year
, month
, and day
.
CREATE EXTERNAL TABLE default.events (
event_id STRING,
app_id STRING,
time TIMESTAMP,
user_id STRING,
device_id STRING,
platform STRING,
sdk_version STRING,
version_code INT
)
PARTITIONED BY (
year INT,
month INT,
day INT
)
location '/warehouse/sales/events';