记录一个很容易搞混的坑
直接说结论:在HIVE中对表名和字段名均可使用as来命名别名,但在Oracle中只允许对字段名使用as,对表名使用as会报错。
-- oracle对表使用as别名举例:
select employees_id, last_name, a.department_id, department_name
from employees as a, departments as b
where a.department_id = b.department_id;
ERROR at line 2:
ORA-00933:SQL command not properly ended