I have a SQL query that runs on Bigquery on a daily frequency. One of the SQL (mentioned below) started failing from last 5 days.
SQL: CREATE OR REPLACE TEMP TABLE products_intermidate_table as(
select p.productid,tPU.detlacolumn
from products p
inner join productdelta tPU with tPU.ProductID = p.ProductID);
Fixed Query: CREATE OR REPLACE TEMP TABLE products_intermidate_table as(
select p.productid,tPU.detlacolumn
from products p
inner join productdelta tPU on tPU.ProductID = p.ProductID);
If you notice, the inner join has a where clause instead of on. The SQL was running fine but started failing from last 5 days. Has something changed on BigQuery to produce this behaviour?
ERROR: Query error: INNER JOIN must have an immediately following ON or USING clause
The error makes sense as you would expect an "on" keyword after join, but I am not sure how the query ran for the last 1 year with the "with" keyword instead of "on".
LinkedIn
Twitter
