search

apache / dolphinscheduler

Apache DolphinScheduler is the modern data orchestration platform. Agile to create high performance workflow with low-code
https://dolphinscheduler.apache.org/
Apache License 2.0
12.8k stars 4.6k forks source link

[sqoop] sqoop import mysql into hdfs,use sql to conditionally export exceptions? condition auto add 1=0 #4425

Closed zheng-zy closed 3 months ago

zheng-zy commented 3 years ago

原sql：select * from tbl_onlineorder WHERE OrderDatetime BETWEEN "2021-01-10 00:00:00" AND "2021-01-11 00:00:00"

执行日志上的sql：select * from tbl_onlineorder WHERE OrderDatetime BETWEEN "2021-01-10 00:00:00" AND "2021-01-11 00:00:00" AND (1 = 0)

导出sql上会添加1=0条件，导致没有数据导出来，这个是官方自己加的，该如何去除？

davidzollo commented 3 years ago

please paste the screenshot about the sql ? which verison ?

Please add/update the title and desc in English, thx

zheng-zy commented 3 years ago

please paste the screenshot about the sql ? which verison ?

Please add/update the title and desc in English, thx

dolphinscheduler version 1.3.3，sql picture see https://imgchr.com/i/sYETgK

SuperHeroBigData commented 3 years ago

i also meet this problem ,how can we solve it?

SuperHeroBigData commented 3 years ago

have you solve this problem ?

github-actions[bot] commented 3 months ago

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

github-actions[bot] commented 3 months ago

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.