Closed MattBlissett closed 7 months ago
'year' is a constant string in SQL. The parser accepts an expression like 'year' >= 1100, but Hive rejects it as a string/integer comparison.
'year'
'year' >= 1100
(year is the date function, "year" must be used.)
year
"year"
'year'is a constant string in SQL. The parser accepts an expression like'year' >= 1100, but Hive rejects it as a string/integer comparison.(
yearis the date function,"year"must be used.)