Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement