Skip to content

Instantly share code, notes, and snippets.

@skipperkongen
Last active March 18, 2019 12:51
Show Gist options
  • Save skipperkongen/70cd738534f48abf16d4e0c8d38c3667 to your computer and use it in GitHub Desktop.
Save skipperkongen/70cd738534f48abf16d4e0c8d38c3667 to your computer and use it in GitHub Desktop.
Select next weeks with year in Spark SQL
select
year(dt) as departure_year,
weekofyear(dt) as departure_week
from (
select date_add(current_date(), x) as dt
from `table_that_contains_integers_0_to_n_as_x`
where x % 7 = 0
)
order by dt
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment