The query runs normally for the public dataset, but returns an error for the private dataset.
When using private datasets
%bigquery
#standardSQL
select idn
from privit_table
-> output : SQL Execution returned an error!
(However, this query is not a query problem because it outputs normal results when running on a big query.)
When using public datasets
%bigquery
#standardSQL
SELECT departure_airport,count(case when departure_delay>0 then 1 else 0 end) as no_of_delays
FROM `bigquery-samples.airline_ontime_data.flights`
group by departure_airport
order by 2 desc
limit 10
-> output : The query results are successfully output.
I'm currently running zeppelin-daemon on ubuntu and connecting from a remote server, and I set the environment variable for key.json through export GOOGLE_APPLICATION_CREDENTIALS.
I also specified the project ID.
The https://zeppelin.apache.org/docs/latest/storage/storage.html#notebook-storage-in-gcs link written as a reference in the official DOCS document is not currently working, so I have no reference.
Why does it work well on public datasets and only on private datasets get SQL Execution returned an error!? There was someone in StackOverflow who was in the same situation, but the replies didn't help. Please help me!
LinkedIn
Twitter
