[
https://issues.apache.org/jira/browse/AIRFLOW-3856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16768008#comment-16768008
]
jack commented on AIRFLOW-3856:
-------------------------------
[https://cloud.google.com/bigquery/docs/parameterized-queries]
"This feature is only available with [standard SQL
syntax|https://cloud.google.com/bigquery/docs/reference/standard-sql/].";
> Incorrect treatment of use_legacy_sql in BigQueryOperator
> ---------------------------------------------------------
>
> Key: AIRFLOW-3856
> URL: https://issues.apache.org/jira/browse/AIRFLOW-3856
> Project: Apache Airflow
> Issue Type: Bug
> Components: api, gcp
> Affects Versions: 1.10.2
> Reporter: Ivan Ukhov
> Priority: Major
>
> BigQueryOperator does not allow use_legacy_sql set to False and query_params
> at the same time. The problem can be seen here:
> [https://github.com/apache/airflow/blob/1.10.2/airflow/contrib/hooks/bigquery_hook.py#L731]
> It is not the presence that matters but the actual value. This effectively
> prevents the usage of query parameters, as the default value for
> use_legacy_sql is True.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
