Skip to content

Instantly share code, notes, and snippets.

@zsxwing

zsxwing/create.sql

Created August 6, 2013 03:13
Show Gist options
  • Save zsxwing/6161717 to your computer and use it in GitHub Desktop.
Save zsxwing/6161717 to your computer and use it in GitHub Desktop.
Download ZIP
Hive - create external table
Raw
create.sql
CREATE EXTERNAL TABLE IF NOT EXISTS access (
ip STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
LOCATION '/user/mstr/access';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment