Skip to content

Instantly share code, notes, and snippets.

@robert8138

robert8138/non_dynamic_partition_end.sql

Created February 6, 2018 06:13
Show Gist options
  • Save robert8138/2c4e051a857a293e9a7504f38f684448 to your computer and use it in GitHub Desktop.
Save robert8138/2c4e051a857a293e9a7504f38f684448 to your computer and use it in GitHub Desktop.
Download ZIP
Dynamic Partition Example 2
Raw
non_dynamic_partition_end.sql
INSERT OVERWRITE TABLE fct_bookings PARTITION (ds='{{ latest_ds }}')
SELECT
id_listing
, m_bookings
FROM
some_up_stream_booking_tables
WHERE
ds = '{{ latest_ds }}'
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment