CREATE
EXTERNAL
TABLE
raw_datastore
(
ip STRING
,
hyphen STRING
,
username STRING
,
TIME
STRING
,
request STRING
,
STATUS
INT
,
SIZE
INT
,
referrer STRING
,
agent STRING
)
PARTITIONED
BY
(
YEAR
STRING
,
MONTH
STRING
,
DAY
STRING
,
HOUR
STRING
)
ROW
FORMAT DELIMITED
FIELDS
TERMINATED
BY
'
\t
'
STORED
AS
TEXTFILE
LOCATION
'/logs'
;