Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- -- This will register the "planet" table within your AWS account
- --
- 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/';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement