Duplicate Limit in manual Queries

[weeco]

Bug Report

I want to create a Table which shows the most expensive BigQuery jobs ran by our users/services. Therefore I am forced to use the manual query anyways. My query looks like this:

SELECT UserId, Query, TotalCost
FROM `projectname.billing.bigquery_audit`
WHERE
  $__timeFilter(JobCreateTime)
ORDER BY TotalCost DESC
LIMIT 10

The query fails because of: "invalidQuery: Syntax error: Unexpected keyword LIMIT at [6:10]". That didn't make sense for me and hence I opened the query inspector. There I can see the generated query and that there's a second LIMIT parameter:

query:"SELECT UserId, Query, TotalCost FROM projectname.billing.bigquery_auditWHEREJobCreateTime BETWEEN TIMESTAMP_MILLIS (1567415998923) AND TIMESTAMP_MILLIS (1570007998923) ORDER BY TotalCost DESC LIMIT 10 LIMIT 795"

Expected Behavior

It shouldn't attach any further LIMIT parameter when I have specified an own one.

Actual Behavior

It always appends LIMIT 795, no matter whether I have specified a limit or not. I assume this is only the case when I use "Format as table".

Steps to Reproduce the Problem

Described above.

Specifications

• Version: 1.0.2
• Platform: Kubernetes
• Grafana Version: 6.4.0

[avivl]

It looks you are missing a time field in the query

[weeco]

Can you eloborate that? I am using the time filter macro and it seems like it does what I expected (see the where condition)

[weeco]

@avivl bump

[avivl]

In your select statement you should have a time filed(timestamp, datetime etc)

[weeco]

@avivl Why is that necessary? If I remove the LIMIT in my query it works completely fine (but I get hundreds of rows).

[avivl]

I tried it without any problems.
Can you try to recreate the visualization?

[weeco]

I have recreated the visualization but the issue is still exactly the same. I have attached a screenshot. Adding a time field hasn't helped either btw..