AnsweredAssumed Answered

SELECT * FROM employees WHERE salary = (SELECT MAX(salary) FROM employees) this query is not supported by Impala in MapR

Question asked by vishal on Apr 13, 2015
Latest reply on Jun 25, 2015 by Hao Zhu
When I execute below sql on Impala with MapR Cluster found below error:

SELECT * FROM employees WHERE salary = (SELECT MAX(salary) FROM employees)

Error: AnalysisException: Syntax error in line 1:
...employees WHERE salary = (SELECT MAX(salary) FROM empl...
                             ^
Encountered: SELECT
Expected: CASE, CAST, FALSE, IF, INTERVAL, NOT, NULL, TRUE, IDENTIFIER

CAUSED BY: Exception: Syntax error (state=HY000,code=0)

Please give alternate way of subquery to execute on MapR Impala.

Outcomes