出现异常 - “属性值大于表服务允许的值”，azure 存储表中行的最大大小是多少

发布于 2024-10-02 16:56:03 字数 501 浏览 6 评论 0原文

尝试在 Azure 表存储中插入记录时出现异常“属性值大于表服务允许的值”。

以下是我的表结构， string PartitionKey,String RowKey,string Id , string site, string name , byte[ ] content,
public DateTime createdtime

我试图在内容字段中保存 83755 字节数组（82KB），其他字段最多为 35 个字符。

谁能告诉我天蓝色存储表的行的最大大小是多少？

以下是我提到的 url..其中提到该行最多可以有 1MB。但我的不超过100KB。

链接

谢谢，

戈皮纳特

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

む无字情书 2024-10-09 16:56:03

是的，每行最多可以有 1MB。但是，每个字节数组属性或字符串属性限制为 64K。有关每种数据类型的详细信息，请参阅此 MSDN 参考。

回复收藏 0 原文

許願樹丅啲祈禱 2024-10-09 16:56:03

我建议查看 Lokad.Cloud for Azure 框架（开源）。有一个经过生产测试的代码，用于将大型实体序列化到表存储中，限制为 960KB（属性分割和管理由框架处理）

以下是来自 FatEntities 维基

// TODO: change your connection string here
var providers = Standalone.CreateProviders(
   "DefaultEndpointsProtocol=https;AccountName=;AccountKey=");

// 'books' is the name of the table
var books = new CloudTable<Book>(providers.TableStorage, "books");

var potterBook = new Book 
   { Author = "J. K. Rowling", Title = "Harry Potter" };

var poemsBook = new Book 
   { Author = "John Keats", Title = "Complete Poems" };

// inserting (or updating record in Table Storage)
books.Upsert(new[]
    {
        new CloudEntity<Book> {
            PartitionKey = "UK", RowRey = "potter", Value = potterBook},
        new CloudEntity<Book> {
            PartitionKey = "UK", RowRey = "poems", Value = poemsBook}
    });

// reading from table
foreach(var entity in books.Get())
{
    Console.WriteLine("{0} by {1} in partition '{2}' and rowkey '{3}'",
        entity.Value.Title, entity.Value.Author, 
        entity.PartitionKey, entity.RowRey);
}

Console.WriteLine("Press enter to exit.");
Console.ReadLine();

I recommend to check out Lokad.Cloud for Azure framework (Open Source). There is a production-tested code for serializing large entities into the table storage with 960KB limit (property splitting and management is handled by the framework)

Here's the sample usage from FatEntities wiki

// TODO: change your connection string here
var providers = Standalone.CreateProviders(
   "DefaultEndpointsProtocol=https;AccountName=;AccountKey=");

// 'books' is the name of the table
var books = new CloudTable<Book>(providers.TableStorage, "books");

var potterBook = new Book 
   { Author = "J. K. Rowling", Title = "Harry Potter" };

var poemsBook = new Book 
   { Author = "John Keats", Title = "Complete Poems" };

// inserting (or updating record in Table Storage)
books.Upsert(new[]
    {
        new CloudEntity<Book> {
            PartitionKey = "UK", RowRey = "potter", Value = potterBook},
        new CloudEntity<Book> {
            PartitionKey = "UK", RowRey = "poems", Value = poemsBook}
    });

// reading from table
foreach(var entity in books.Get())
{
    Console.WriteLine("{0} by {1} in partition '{2}' and rowkey '{3}'",
        entity.Value.Title, entity.Value.Author, 
        entity.PartitionKey, entity.RowRey);
}

Console.WriteLine("Press enter to exit.");
Console.ReadLine();

回复收藏 0 原文