Skip to content

Instantly share code, notes, and snippets.

@Arnold1

Arnold1/main.sql

Created January 23, 2018 17:20
Show Gist options
  • Save Arnold1/2774d77bc9a1c0e31c808835ab7b715f to your computer and use it in GitHub Desktop.
Save Arnold1/2774d77bc9a1c0e31c808835ab7b715f to your computer and use it in GitHub Desktop.
Download ZIP
query
Raw
main.sql
select mm_date, COUNT(DISTINCT mm_id)
from data1 join data2 on (data1.mm_id = data2.mm_id)
where mm_date between '2018-01-22' and '2018-01-22'
and data2.type <> 'test1' and data2.type <> 'test2'
FAILED: SemanticException Column mm_id Found in more than One Tables/Subqueries
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment