SQL query typos
Closed this issue · 1 comments
mave89 commented
All the queries with "interval #num days" will fail. "days" is a typo, it should be "day".
Problematic queries:
query12.sql
query16.sql
query20.sql
query21.sql
query32.sql
query37.sql
query40.sql
query5.sql
query77.sql
query80.sql
query82.sql
query92.sql
query94.sql
query95.sql
query98.sql
mave89 commented
Never mind. I was using an older version of hive. This error won't occur in version >= v2.2.