# I am not able to extract more than 1000 records in canvas Elasticsearch SQL query **URL:** \ **Category:** Kibana\ **Tags:** canvas\ **Created:** [December 2, 2019, 1:20pm UTC](https://discuss.elastic.co/t/i-am-not-able-to-extract-more-than-1000-records-in-canvas-elasticsearch-sql-query/210186 "2019-12-02T13:20:36Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![anish\_jha](https://avatars.discourse-cdn.com/v4/letter/a/b4bc9f/32.png) [@anish\_jha](https://discuss.elastic.co/u/anish_jha)\ **Post date:** [December 2, 2019, 1:20pm UTC](https://discuss.elastic.co/t/i-am-not-able-to-extract-more-than-1000-records-in-canvas-elasticsearch-sql-query/210186/1 "2019-12-02T13:20:36Z")
I am using this query . SELECT transaction\_id FROM "dev\_\_event\*" limit 10000 Still i am getting only 1000 records , can anyone please help me on this. ![39%20PM](https://us1.discourse-cdn.com/elastic/original/3X/6/6/664bf599225e4622e787b62b6439edb822338807.jpeg) ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [December 2, 2019, 3:07pm UTC](https://discuss.elastic.co/t/i-am-not-able-to-extract-more-than-1000-records-in-canvas-elasticsearch-sql-query/210186/2 "2019-12-02T15:07:38Z")
Yes, this is a limitation/bug in the way Canvas is consuming ES SQL. [https://github.com/elastic/kibana/issues/51191](https://github.com/elastic/kibana/issues/51191) It could also highlight a logical issue- why do you need so many IDs to be loaded into Canvas? How will they be visualized? ---
**Author:** ![anish\_jha](https://avatars.discourse-cdn.com/v4/letter/a/b4bc9f/32.png) [@anish\_jha](https://discuss.elastic.co/u/anish_jha)\ **Post date:** [December 3, 2019, 5:55am UTC](https://discuss.elastic.co/t/i-am-not-able-to-extract-more-than-1000-records-in-canvas-elasticsearch-sql-query/210186/3 "2019-12-03T05:55:35Z")
Actually i need to show the number of transaction per 24 hours/week/month . I am using the count operation on transaction \_id so i will get the exact count of transaction . is there any other way to do that ? ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [December 3, 2019, 8:12pm UTC](https://discuss.elastic.co/t/i-am-not-able-to-extract-more-than-1000-records-in-canvas-elasticsearch-sql-query/210186/4 "2019-12-03T20:12:04Z")
Yes, try this: `SELECT HISTOGRAM("@timestamp", INTERVAL 24 HOURS), COUNT(*) FROM myindex GROUP BY HISTOGRAM("@timestamp", INTERVAL 24 HOURS)` ---
**Author:** ![anish\_jha](https://avatars.discourse-cdn.com/v4/letter/a/b4bc9f/32.png) [@anish\_jha](https://discuss.elastic.co/u/anish_jha)\ **Post date:** [December 4, 2019, 1:12pm UTC](https://discuss.elastic.co/t/i-am-not-able-to-extract-more-than-1000-records-in-canvas-elasticsearch-sql-query/210186/5 "2019-12-04T13:12:33Z")
> [@wylie](#): > > HISTOGRAM Sorry, I didn't get what this query means ,Can you please explain , as i am using time filter element in canvas do i still need to pass @timestamp in es SQL. ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [December 4, 2019, 2:45pm UTC](https://discuss.elastic.co/t/i-am-not-able-to-extract-more-than-1000-records-in-canvas-elasticsearch-sql-query/210186/6 "2019-12-04T14:45:06Z")
Try it out- you will see that the filters are applied in addition to SQL. The histogram function will apply a date histogram aggregation. [https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-grouping.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-grouping.html) ---
**Author:** ![anish\_jha](https://avatars.discourse-cdn.com/v4/letter/a/b4bc9f/32.png) [@anish\_jha](https://discuss.elastic.co/u/anish_jha)\ **Post date:** [December 5, 2019, 8:58am UTC](https://discuss.elastic.co/t/i-am-not-able-to-extract-more-than-1000-records-in-canvas-elasticsearch-sql-query/210186/7 "2019-12-05T08:58:02Z")
Thank you, your help is much appreciated. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 2, 2020, 9:02am UTC](https://discuss.elastic.co/t/i-am-not-able-to-extract-more-than-1000-records-in-canvas-elasticsearch-sql-query/210186/8 "2020-01-02T09:02:14Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.