When I run a query on a table as the table owner. I get the error (Error 400,Error: Something went wrong with the table you queried. Contact the table owner for assistance.). The same query might work or It might not work intermittently.
The jobId when the query worked is planar-fulcrum-837:bquijob_66c2e13e_15846fef94c The jobId when the query failed is planar-fulcrum-837:bquijob_cba7f3d_15846ff1370
Both query are the same. Only one table is affected while other table under the same project is unaffected.
The table in question has 37 columns as is 324 GB is size. Data are continuously streamed into the table. The query ran look something like this
SELECT substr(datehourminute,1,4) [year], substr(datehourminute,5,2) [month], substr(datehourminute,7,2) [day], substr(datehourminute,9,2) [hour], sidentifierid, pidentifierid ,count(*) as leads FROM iqleads.leads WHERE integer(substr(datehourminute,1,10)) between 2016051400 AND 2016051523 AND sidentifierid IN (10) GROUP BY year,month,day,hour,sidentifierid, pidentifierid order by year,month,day,hour,sidentifierid, pidentifierid
Many thanks in advance for reading through this question.