Team, Looks like Hive doesn't like functions in the WHERE clause. Any ideas on how to deal with this? Also, I feel like this used to be supported in the past. Am I missing something?
SELECT y, m, d FROM emp_table WHERE concat(y, m, d) > '20181216' limit 10; FAILED: SemanticException InvalidObjectException(message:Operator 'concat(y, m, d) > '20181216'' expects to have a column name on a left side, but got 'concat(y, m, d)' (Service: AWSGlue; Status Code: 400; Error Code: InvalidInputException; This is on Hive 2.3.4 on AWS EMR (metadata on AWS Glue). This works on AWS Athena (Presto) by the way. Thanks, Andy