druid-io / pydruid

A Python connector for Druid
Other
506 stars 194 forks source link

[Question] Does PyDruid support queries Pagination ? #229

Open wanaminn opened 4 years ago

wanaminn commented 4 years ago

Question Hi,

When we do the druid queries in Jupyter notebook, can we make the output shown in pagination?

armanaxh commented 4 years ago

Hi, I don't know what the problem is, but A select query returns raw Druid rows and supports pagination. You can get information from here. And here.

I hope I was able to help.

wanaminn commented 4 years ago

Hi Arman, Currently, I'm using druid version 0.18.1, the select query is has been removed and replaced by the Scan query. May I know if is there any ways to do besides using select query?

armanaxh commented 4 years ago

I have no idea. I had seen the pagination on the Druid panel and was hoping that the feature has existed. And I checked, but It uses the SQL limit and always get the previous ones. :) And can not be used OFFSET in SQL Druid. Best,