1.现象
sqoop导入oracle的数据报错
20/06/22 09:27:11 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
2.原因
检查导入的sql错误
select * from esoc_ordergoods where substr(TS,1,10 ) =< '$do_date' and \$CONDITIONS
3.解决方案
将sql的=< 改为 <= 后恢复