Data Studio
4.8K members online now
4.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Query error issue

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Open https://datastudio.google.com/open/0BxlJphQEIHquNDNFQzBmTzROYnM, list Adwords Keyword Perfomance.

  1. It shows loading indicator and then an error: Configuration error. 839ee597
  2. Click on. It shows the message
"Error Details

There`s a query error.

Error ID: 839ee597

 
Errors logged by Postgres:
2017-03-13 14:45:09 UTC [3903-1] datastudio@report_loader LOG: could not send data to client: Broken pipe
2017-03-13 14:45:09 UTC [3903-2] datastudio@report_loader STATEMENT: SELECT SUM(clicks) AS _clicks_, SUM(conv) AS _conv_, SUM(imps) AS _imps_, SUM(spend) AS _spend_, account_id, date, keyword_name FROM keywords_103_adwords AS t0 GROUP BY account_id, date, keyword_name ORDER BY _conv_ DESC
2017-03-13 14:45:09 UTC [3903-3] datastudio@report_loader FATAL: connection to client lost
2017-03-13 14:45:09 UTC [3903-4] datastudio@report_loader STATEMENT: SELECT SUM(clicks) AS _clicks_, SUM(conv) AS _conv_, SUM(imps) AS _imps_, SUM(spend) AS _spend_, account_id, date, keyword_name FROM keywords_103_adwords AS t0 GROUP BY account_id, date, keyword_name ORDER BY _conv_ DESC
 
Number of elements the query returns:
report_loader=# select count(*) from (SELECT SUM(clicks) AS _clicks_, SUM(conv) AS _conv_, SUM(imps) AS _imps_, SUM(spend) AS _spend_, account_id, date, keyword_name FROM keywords_103_adwords AS t0 GROUP BY account_id, date, keyword_name ORDER BY _conv_ DESC) as t;
count
---------
5085429
(1 row)
Time: 122411,121 ms
 
Number of elements the same query with WHERE conditions returns:
report_loader=# SELECT COUNT(*) FROM (SELECT SUM(clicks) AS _clicks_, SUM(conv) AS _conv_, SUM(imps) AS _imps_, SUM(spend) AS _spend_, account_id, date, keyword_name FROM keywords_103_adwords AS t0 WHERE "date" BETWEEN '2017-02-01' AND '2017-02-14' AND account_id='4604598940' GROUP BY account_id, date, keyword_name ORDER BY _conv_ DESC) AS t;
count
-------
15014
(1 row)
Time: 68,022 ms
 
 
Structure of the table:
keywords_103_adwords_table.png
 
The database table "keywords_103_adwords" contains data from 2016-10-01 to 2017-03-14. Requested account_id is 4604598940 and date interval is from 2017-02-01 to 2017-02-14.
DB server is hosted at AWS us-east-1 region. PostgreSQL version 9.5.4.
 
- Please tell what does error with this identifier mean?
- Why Datastudio executes this query? Notice that the report has "date" range and "account_id" filter specified but the query has no WHERE clause with any filter.
- It seems that Datastudio fetches all table data grouped by [account_id, date and keyword_name] and then filters received resultset by date and account_id client-side. Am i right? Possible some limits were exceeded by this query (timeout or resultset size)? What should we do here?

 

Thank you!