table.sql

CREATE EXTERNAL TABLE cflog (
    dt STRING,
    tm STRING,
    edge STRING,
    bytes STRING,
    ip STRING,
    method STRING,
    host STRING,
    uri STRING,
    status STRING,
    referer STRING,
    ua STRING,
    querySTRING STRING,
    cookie STRING,
    resultType STRING,
    requestId STRING,
    hostHeader STRING,
    protocol STRING,
    csBytes STRING
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
LOCATION '/data';