hadoop - 嵌套选择不适用于配置单元

Question

FROM (
 SELECT upper(name), salary, deductions["service tax"] as service_tax,
 round(salary * (1 - deductions["service tax"])) as salary_minus_service_taxes
 FROM employees
 ) e
 SELECT e.name, e.salary_minus_service_taxes
 WHERE e.salary_minus_service_taxes > 70000;

当我运行上述查询时，出现以下错误

FAILED: SemanticException [Error 10002]: Line 6:10 Invalid column reference 'name'

Answer 1

该列应为别名:

SELECT upper(name) as name