Stack Overflow
Stack Overflow

Questions tagged [azure-tablequery]

126 questions
2
votes
1 answer

Querying one record from tens of millions of records in Azure Table Storage

I have a typical scenario where a consumer is calling a Azure Function (EP1) (synchronously) which then queries Azure Table storage (having 5 million records), based upon the input parameters of the Azure Function API. Azure Table Storage has…
Rahul Roy
  • 37
  • 4
2
votes
1 answer

How to do a transaction with Azure.Data.Tables.TableClient?

I can use this TableClient SDK (for Azure Tables) to create, update, retrieve, delete....etc. But I'm not sure how to do updates (multiple records) in a transaction. I dont see any documentation of this anywhere (other than the mere mention of doing…
AlvinfromDiaspar
  • 6,611
  • 13
  • 75
  • 140
2
votes
2 answers

Angular MatPaginator and Azure Table Storage

I'm trying to implement an Angular material table with pagination, that is connected to the backend, that retrieves data from Azure Table Storage. I know, that Table Storage supports ExecuteQuerySegmentedAsync, which returns TableContinuationToken.…
Anna Melashkina
  • 422
  • 2
  • 13
2
votes
1 answer

Azure Table Storage Support empty columns field at the time of insert

Can Azure table support null value or empty value in the column field at the time of insert a record on the azure table? Let take an example if I have one table with below fields Where the column description is mentioned below: LastModifiedOn…
Rahul Dhoundiyal
  • 71
  • 11
2
votes
2 answers

Get more than 1000 datasets from an Azure Table Storage

I've an Azure Function to perform some operations on the datasets in an Azure Table Storage. Since grouping is not working in Azure Table Storages, I have to fetch all datasets in my table and perform the operations I want (grouping, filtering) in…
Konrad
  • 4,329
  • 10
  • 54
  • 88
2
votes
2 answers

Running a Contains operator in Azure Table Service linq query

I'd like to know why/how this query is running on a Azure Storage table, given that 'contains' are not allowed in Azure Table Service? Is this not doing what I think it's doing? It's running and fetching values. Also, is this fetching the whole…
chuckd
  • 13,460
  • 29
  • 152
  • 331
2
votes
2 answers

Suggestions to improve Azure Table Storage query performance

We have a table in Azure Table Storage which currently has 50,000 items since it is newly implemented. PartitionKey: DateTime value in form of string RowKey: numeric value in form of string We use TableQuery to generate a filter condition. The…
Vicky
  • 624
  • 2
  • 12
  • 35
2
votes
1 answer

Getting InvalidFilterException when querying a date range using Azure CosmosDb Table API

I'm trying to get a set of results with timestamp within a given date range from a CosmosDb using the Table API. This is how I'm constructing my query: var from = TableQuery.GenerateFilterConditionForDate("Timestamp",…
Tom Troughton
  • 3,941
  • 2
  • 37
  • 77
2
votes
3 answers

Azure Table not loading properties into object

I have an object Record that has a Name and a Theme. A Theme is a KeyValue pair embedded in a typed class, like "01"-"Sport", "02"-"Home" etc I have an object like this: public class DescriptionEntity : TableEntity { public string Description…
serge
  • 13,940
  • 35
  • 121
  • 205
2
votes
2 answers

Getting an error message "Error occurred while decoding OAEP padding" while trying to retrieve the entities from Azure Table Storage

I am encrypting the table in the following way. public TableRequestOptions EncryptTableStorage() { // Create the IKey used for encryption. var key = new RsaKey("mykey"); var policy = new TableEncryptionPolicy(key,…
tRuEsAtM
  • 3,517
  • 6
  • 43
  • 83
2
votes
1 answer

Getting first row in every partition in Azure Tables

I want to get only the first rows of every partition in Azure Tables. I can get all the data and then use the solution in this answer on that result. What I am asking is "Can I do that on Azure side without getting all that unnecessary results?"
Nuri Tasdemir
  • 9,720
  • 3
  • 42
  • 67
2
votes
1 answer

Azure tables: Retrieve entire table

I know how to get some table entities from an Azure table like this: CloudStorageAccount storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting(...); CloudTableClient tableClient =…
Eutherpy
  • 4,471
  • 7
  • 40
  • 64
2
votes
2 answers

Querying azure table without partitionkey and rowkey

I have Azure table called users which serveral fields related to user, I have PartitionKey as UserId and RowKey as CompanyId and I want to query the table via the Email field which is not an PartionKey or RowKey, Is it possible to query the table…
Jenish Zinzuvadiya
  • 999
  • 2
  • 15
  • 29
2
votes
1 answer

Run an Azure Table Storage Query w/o PartitionKey

Is it possible to run a query on an Azure Table Storage table without using the PartitionKey. For example, I'd say, RowKey starts with but do not use the PartitionKey Two questions: Is it possible to do this? Is it a good idea to do this? I'm…
Sam
  • 26,817
  • 58
  • 206
  • 383
2
votes
2 answers

Regarding Azure table design

I am working as freelancer and right now working on one of my game and trying to use Azure table service to log my user moves in Azure tables. The game is based on Cards. The flow is like this: Many users(UserId) will be playing on a table(TableId).…
user1955255
  • 219
  • 4
  • 18
1
2
3
…
8 9