topic Re: tbigqueryinput support for DML statements in Talend Studio

tbigqueryinput support for DML statements

Anonymous — Sat, 16 Nov 2024 07:26:45 GMT

Hi All,

I am trying to run an insert DDL statement against a table in Big Query. I know now Talend tbigqueryinput component supports DML statements. However i am getting the following error for all types of DML INSERT, UPDATE, DELETE

My query is perfectly valid as i ran it against BigQuery directly. Also it happened for all types of DML queries. DDL queries are working fine.

Sample DML :

#standardSQL\r\n INSERT `SurveyMonkey.Survey_Monkey_Customer_Names` (person_customer_id, person_customer_name) SELECT * FROM SurveyMonkey.Survey_Monkey_Customer_Names"

Talend Job looks like this:

What am i doing wrong?

Re: tbigqueryinput support for DML statements

Anonymous — Mon, 22 Oct 2018 05:41:37 GMT

Hello,

Our Google BigQuery components rely on Google "SQL". This is a subset of SQL, that limits actions to simple selections.

Google now offers "Standard SQL" in their Data Manipulation Language (DML), which features extended actions (such as insert, update, delete operations).

For some examples of their DML cf. https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax

Here exists a jira issue:https://jira.talendforge.org/browse/TBD-5959.

Best regards

Sabrina

Re: tbigqueryinput support for DML statements

Anonymous — Mon, 22 Oct 2018 16:03:02 GMT

Yeah i know tbiqueryinput does not implicitly support StandardSQL. But i am using #StandardSQL on top of the query to interpret it as Standard SQL. But i am still getting this error.