Skip to content

Instantly share code, notes, and snippets.

@l1x

l1x/gist:9011482

Created February 14, 2014 23:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save l1x/9011482 to your computer and use it in GitHub Desktop.
Save l1x/9011482 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
CREATE EXTERNAL TABLE uservisits(
sourceIP STRING,
destURL STRING,
visitDate TIMESTAMP,
adRevenue FLOAT,
userAgent STRING,
countryCode STRING,
languageCode STRING,
searchWord STRING,
duration INT
)
STORED AS SEQUENCEFILE LOCATION 'hdfs://namespace/user/user/uservisits';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment