sqoop报错 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErro
1.现象sqoop导入oracle的数据报错20/06/22 09:27:11 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00936: missing expressionjava.sql.SQLSyntaxErrorException: ORA-00936:
·
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的=< 改为 <= 后恢复
技术共进，成长同行——讯飞AI开发者社区
更多推荐
0
0- 0
已为社区贡献3条内容
所有评论(0)