Skip to content

Instantly share code, notes, and snippets.

@timrobertson100

timrobertson100/export.sql

Created April 19, 2017 20:23
Show Gist options
  • Save timrobertson100/cbf04db9509097256739d02dc06b861b to your computer and use it in GitHub Desktop.
Save timrobertson100/cbf04db9509097256739d02dc06b861b to your computer and use it in GitHub Desktop.
Download ZIP
Export for JW
Raw
export.sql
SET hive.exec.compress.output = true;
SET avro.output.codec = gzip;
CREATE TABLE tim.jw1 STORED AS avro AS
SELECT * FROM prod_a.occurrence_hdfs
WHERE
dynamicProperties is not null or
occurrenceRemarks is not null or
organismRemarks is not null or
fieldNotes is not null
AND datasetKey!='4fa7b334-ce0d-4e88-aaae-2e0c138d049e'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment