网页游戏制作软件_中卫网站推广营销_全国疫情高峰感染进度查询_2021最近最火的关键词

sqoop抽数报错Every derived table must have its own alias

报错如下：
ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: Every derived table must have its own alias

修改前脚本：
–query "select * from (select APPNO,COMPANY from cs.gf_app t ) where $CONDITIONS " \

修改后脚本：
–query "select * from (select APPNO,COMPANY from cs.gf_app t ) t1 where $CONDITIONS " \

报错原因：
子查询需要加上别名