search

doitintl / bigquery-grafana

Google BigQuery Datasource Plugin for Grafana. (NO LONGER MAINTAINED)
https://www.doit-intl.com/labs/
MIT License
242 stars 76 forks source link

UNION ALL does not return any data back #395

Closed epragalakis closed 2 years ago

epragalakis commented 2 years ago

Bug Report

The following query works as expected in GCP but not in grafana.

Actual Behavior

Error: Can't access property of 0. e.errors is undefined

Steps to Reproduce the Problem

SELECT
    TIMESTAMP_SECONDS(DIV(UNIX_SECONDS(combined_table.timestamp), 3600) * 3600) AS time,
    COUNT(*) AS rowCount,
FROM (
  SELECT timestamp FROM `table1` UNION ALL
  SELECT timestamp FROM `table2` UNION ALL
  SELECT timestamp FROM `table3` UNION ALL
  SELECT date FROM `table4`
) combined_table
WHERE $__timeFilter(_PARTITIONTIME) OR _PARTITIONTIME IS NULL
GROUP BY time
ORDER BY time
ofir5300 commented 2 years ago

We are retiring the DoiT International BigQuery DataSource plugin for Grafana. We recommend that you migrate to the official Google BigQuery data source maintained by Grafana. In August 2022, we will cease all development and archive the GitHub project.

We are sorry for any inconvenience.