Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

query with custom-function doesn't respect LIMIT #122

Closed
galkk opened this issue Jul 18, 2019 · 2 comments
Closed

query with custom-function doesn't respect LIMIT #122

galkk opened this issue Jul 18, 2019 · 2 comments

Comments

@galkk
Copy link
Contributor

galkk commented Jul 18, 2019

The following request

GET _opendistro/_sql 
{
  "query" : "select date_format(utc_time, 'YYYY-MM-dd'), count(*) from kibana_sample_data_logs group by date_format(utc_time, 'YYYY-MM-dd') order by date_format(utc_time, 'YYYY-MM-dd') desc limit 1"
}

is expected to return 1 row, but returns all rows (limit is ignored)
@galkk
Copy link
Contributor Author

galkk commented Aug 29, 2019

Related to #75

@galkk galkk mentioned this issue Aug 29, 2019
Merged
@galkk
Copy link
Contributor Author

galkk commented Aug 29, 2019

Referenced PR sets requested limit properly, so it fixed this issue as well

@galkk galkk closed this as completed Aug 29, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@galkk