Get oldest n rows from Table in Azure Table Storage using Python

Question

I am trying to get the first(oldest) n rows of data from a table in Azure Table Storage - but am unable to find any documentation that allows doing so via Python. I use an integer-based hash value as my PartitionKey and by default, the table is sorted by PartitionKey. However, I need to fetch the oldest n rows. Is there any way or feasible hack I can use to do this?

Nope, it would count as a new row - but if that's the only way to get it done then I'm willing to compromise — Bhavik Shah
– Bhavik Shah, Commented Nov 10, 2020 at 3:05

Stanley Gong · Accepted Answer · 2020-11-10 03:29:42Z

1

Unfortunately there is no solution. Server side sorting is not supported in table storage. If you want to sort by timestamp, you have to set the PartitionKey's value to the timestamp, and then the query result will be sorted by timestamp in the reverse order.

answered Nov 10, 2020 at 3:29

Stanley Gong

12.2k1 gold badge12 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get oldest n rows from Table in Azure Table Storage using Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related