Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

azure storage size of partition key out of range?

according to this link , a partition key can be 1kb (https://docs.microsoft.com/en-us/rest/api/storageservices/Understanding-the-Table-Service-Data-Model?redirectedfrom=MSDN)

so why do I get error "the partition key is out of range" ?

I am putting a url value like https://xxx into the partition key . Maybe the slashes are a problem? Thanks,Peter

like image 916
petercli Avatar asked Nov 01 '17 01:11

petercli


People also ask

What is PartitionKey and RowKey?

The row key is a unique identifier for an entity within a given partition. Together the PartitionKey and RowKey uniquely identify every entity within a table. The row key is a string value that may be up to 1 KiB in size. You must include the RowKey property in every insert, update, and delete operation.

What does Microsoft recommend when choosing an azure cosmos DB partition key?

Selecting your partition key is a simple but important design choice in Azure Cosmos DB. Once you select your partition key, it is not possible to change it in-place. If you need to change your partition key, you should move your data to a new container with your new desired partition key.

What is the maximum size of an entity in Azure Table Storage?

An entity in Azure Storage can be up to 1MB in size. An entity in Azure Cosmos DB can be up to 2MB in size. Properties: A property is a name-value pair. Each entity can include up to 252 properties to store data.

Which of the following is a type of key used by Azure Table storage?

Table primary key. The primary key for an Azure entity consists of the combined PartitionKey and RowKey properties. The two properties form a single clustered index within the table. The PartitionKey and RowKey properties can store up to 1 KiB of string values.


1 Answers

https://blogs.msdn.microsoft.com/jmstall/2014/06/12/azure-storage-naming-rules/

The following characters are not allowed in values for the PartitionKey and RowKey properties:

  • The forward slash (/) character
  • The backslash () character
  • The number sign (#) character
  • The question mark (?) character
  • Control characters from U+0000 to U+001F, including:
    1. The horizontal tab (\t) character
    2. The linefeed (\n) character
    3. The carriage return (\r) character
  • Control characters from U+007F to U+009F
like image 53
Zhaoxing Lu Avatar answered Sep 21 '22 01:09

Zhaoxing Lu