Skip to content

Instantly share code, notes, and snippets.

@matthewberryman
Created February 14, 2018 04:02
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 matthewberryman/729f1db6a485d604a96a80eed450b5fb to your computer and use it in GitHub Desktop.
Save matthewberryman/729f1db6a485d604a96a80eed450b5fb to your computer and use it in GitHub Desktop.
CREATE EXTERNAL TABLE planet (
id BIGINT,
type STRING,
tags MAP<STRING,STRING>,
lat DECIMAL(9,7),
lon DECIMAL(10,7),
nds ARRAY<STRUCT<ref: BIGINT>>,
members ARRAY<STRUCT<type: STRING, ref: BIGINT, role: STRING>>,
changeset BIGINT,
timestamp TIMESTAMP,
uid BIGINT,
user STRING,
version BIGINT
)
STORED AS ORCFILE
LOCATION 's3://osm-pds/planet/';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment