- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-26-2024 03:48 PM
Some of our delta sharing tables are not working
May be related to this, or maybe not, we enabled predictive optimization on all tables a few days ago
es not working any more
but any new tables created works fine after setting this
SET TBLPROPERTIES (delta.enableDeletionVectors=false);
anyone experience same issue? thanks
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2024 01:32 PM
after some debugging, I find out a very unique cause if we used a JSON string in column comment, and it make sense that a JSON string in column comment breaks delta sharing
example: column COMMENT {"key": "primary_key", "is_identity": "true"}
The error said Unexpected character ('k' (code 107)): k comes from the "key" in JSON string leads me to find a solution is to set comment as blank
but
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-26-2024 05:38 PM
error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2024 01:32 PM
after some debugging, I find out a very unique cause if we used a JSON string in column comment, and it make sense that a JSON string in column comment breaks delta sharing
example: column COMMENT {"key": "primary_key", "is_identity": "true"}
The error said Unexpected character ('k' (code 107)): k comes from the "key" in JSON string leads me to find a solution is to set comment as blank
but