You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "Tomasz Urbaszek (JIRA)" <ji...@apache.org> on 2019/08/09 11:08:00 UTC
[jira] [Commented] (AIRFLOW-3804) MySqlToGoogleCloudStorageOperator
success when it should fail
[ https://issues.apache.org/jira/browse/AIRFLOW-3804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16903808#comment-16903808 ]
Tomasz Urbaszek commented on AIRFLOW-3804:
------------------------------------------
Hey [~jackjack10] do you still experience this problem? The operator was refactored since your report.
> MySqlToGoogleCloudStorageOperator success when it should fail
> -------------------------------------------------------------
>
> Key: AIRFLOW-3804
> URL: https://issues.apache.org/jira/browse/AIRFLOW-3804
> Project: Apache Airflow
> Issue Type: Bug
> Components: gcp, operators
> Reporter: jack
> Priority: Major
> Fix For: 2.0.0
>
>
> Testing the following query on MySqlToGoogleCloudStorageOperator.
>
> {code:java}
> SELECT * FROM table where modifiedTS>2000-01-01 00:00:00 and modifiedTS<= 2019-02-04 13:55:21{code}
>
> The operator runs smoothly and report success so airflow continue to execute the down stream of the operator.
> However this query is invalid.
> Running it on MySQL will give:
>
> {code:java}
> Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00 and modifiedTS<= 2019-02-04 13:55:21' at line 11{code}
>
> The operator should have *FAILD* when running this query it has syntax error.
> There is probably a problem with how this operator treats the result of this query and confuses it with valid result of no rows returned.
>
> Not sure if it's related but I'm running the query with SQL file using : filename option of the operator.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)