Advertisement
zzarbi

Hive Combined logs partition

Mar 13th, 2012
264
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.35 KB | None | 0 0
  1. CREATE EXTERNAL TABLE raw_datastore (
  2.   ip STRING,
  3.   hyphen STRING,
  4.   username STRING,
  5.   TIME STRING,
  6.   request STRING,
  7.   STATUS INT,
  8.   SIZE INT,
  9.   referrer STRING,
  10.   agent STRING)
  11. PARTITIONED BY(
  12.   YEAR STRING,
  13.   MONTH STRING,
  14.   DAY STRING,
  15.   HOUR STRING)
  16. ROW FORMAT DELIMITED
  17. FIELDS TERMINATED BY '\t'
  18. STORED AS TEXTFILE
  19. LOCATION '/logs';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement