Skip to content

Instantly share code, notes, and snippets.

@randyzwitch

randyzwitch/airlineview.hive

Last active December 21, 2015 13:30
Show Gist options
  • Save randyzwitch/6313253 to your computer and use it in GitHub Desktop.
Save randyzwitch/6313253 to your computer and use it in GitHub Desktop.
Download ZIP
Build airline view to remove bad records
Raw
airlineview.hive
-- Create view to "remove" 22 bad records from our table
create view vw_airline as
select * from airline
where uniquecarrier <> "UniqueCarrier";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment