Stack Overflow
Stack Overflow

Questions tagged [azure-tablequery]

126 questions
61
votes
3 answers

How to get all rows in Azure table Storage in C#?

I am trying to get a list of all entities inside an azure table. Any idea of how I would write this query?
SKLAK
  • 3,825
  • 9
  • 33
  • 57
19
votes
3 answers

Can PartitionKey be queried with StartsWith?

In Azure Table Storage, is it possible to query PartitionKey with a StartsWith or some other operator e.g. Contains, etc. I know I can do this with RowKeys but is it possible to do it with PartitionKeys? A follow up question is: even if it's doable,…
Sam
  • 26,817
  • 58
  • 206
  • 383
10
votes
5 answers

how to speed up a query with partitionkey in azure table storage

How do we increase the speed of this query? We have approximately 100 consumers within the span of 1-2 minutes executing the following query. Each one of these runs represents 1 run of a consumption function. TableQuery…
Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
10
votes
4 answers

Create a TableEntity with Array or List property?

I have stored in an Azure Table some enumerations like this pk rk | en fr de ... foo 1 | 'Eune' 'Fune' 'Dune' ... foo 2 | 'Edoe' 'Fdoe' 'Ddoe' ... bar 1 | 'Unee' 'Unef' 'Trid' ... bar 2 | 'Diee' 'Dief' 'Died' ... bar 3 …
serhio
  • 28,010
  • 62
  • 221
  • 374
8
votes
4 answers

How to Filter the query result for pagination in TableClient.QueryAsync() [Azure.Data.Tables]

I am using the Azure.Data.Tables package & TableClient.QueryAsync() method to get the query result. I wants the result to use it for pagination. I came across this code in…
sachin sachu
  • 107
  • 1
  • 1
  • 10
8
votes
3 answers

Max $filter comparisons in an Azure Table Query

This page (https://learn.microsoft.com/en-us/rest/api/storageservices/querying-tables-and-entities) says: Note that no more than 15 discrete comparisons are permitted within a $filter string. However in my experiments I have hit that limit and not…
Agendum
  • 1,697
  • 1
  • 18
  • 36
6
votes
1 answer

Selecting from many partition keys in Azure Table Storage

In Azure Table Storage, I store news updates and the partition key is the keyword assigned to a news category e.g. "politics", "sports", etc. When the user logs in, I want to be able to select records based on user's interests -- which are persisted…
Sam
  • 26,817
  • 58
  • 206
  • 383
5
votes
3 answers

Batch Insert in Azure storage table

I am new to using azure storage table. I was trying to insert my entities in batch but I found that you cannot do batch operation having different partition key. Is there some way I can do that there are about 10,000 - 20,000 of file details which I…
Sushant Baweja
  • 202
  • 1
  • 5
  • 14
4
votes
2 answers

How to specify a Take value with TableClient.QueryAsync

I'm updating my project to use Azure.Data.Tables 12.6.1, and I can't figure out where to specify a Take value to limit the number of entities returned from a query. In other words, I want to do something like this: var limit = 150; var results =…
Brian Rak
  • 4,912
  • 6
  • 34
  • 44
4
votes
2 answers

Getting "The values are not specified for all properties in the entity" error while using Azure Table Storage

My Entity Class public class VerifyVariableEntity : TableEntity { public VerifyVariableEntity() { } public VerifyVariableEntity(string consumerId, string score) { PartitionKey = consumerId; RowKey = score; …
tRuEsAtM
  • 3,517
  • 6
  • 43
  • 83
3
votes
1 answer

How can I access the most recent entry in the Azure Storage Table using python sdk?

I am using the following code: from azure.cosmosdb.table.tableservice import TableService from azure.cosmosdb.table.models import Entity table_service = TableService(account_name='', account_key='') task = table_service.get_entity('table1',…
New_to_work
  • 253
  • 2
  • 5
  • 16
3
votes
0 answers

Unexpected EDM type from the Azure Table Service

I have created a asp.net core 2.0 web app on which you can query an azure table on Partitionkey and 2 double fields (rating and temperature). The Table storage is updated 4 times a day in another process using a python script. Once in a while the…
Rik
  • 41
  • 3
3
votes
1 answer

Maximum number of FilterCondition's in TableQuery.CombineFilters

I need to do something like a batch get using Azure table storage. I have a list of known RowKeys and PartitionKeys and I would like retrieve each one. I was wondering if there was a better way than querying for each entity individually - like a…
TomSelleck
  • 6,706
  • 22
  • 82
  • 151
3
votes
2 answers

Azure Table Storage Query For Unique Partition Key

My problem is as follows, I have an Azure Table Storage that is set up like this: Partition Key : string Row Key : number I want to make a query such that given a number X, I want to return the highest number Row Key that is less than X for each…
maxnelso
  • 85
  • 1
  • 6
2
votes
1 answer

How to query the most recent n records from Azure Table Storage?

I am using the following query in c# .net: TableQuery query = new TableQuery().Take(50); This works in grabbing 50 records, but I want to grab the most recent (descending) records from the table. I have looked at other answers, but…
jamesdlivesinatree
  • 1,016
  • 3
  • 11
  • 36
1
2 3
…
8 9