Suppose I am having a table which is hash distributed , without partition , and it's clustered column stored index . So the underneath storage is
1 file per segment / per column ? in the blob storage ?
or 1 file per segment only ?
Suppose I am having a table which is hash distributed , without partition , and it's clustered column stored index . So the underneath storage is
1 file per segment / per column ? in the blob storage ?
or 1 file per segment only ?
Hello @sakuraime ,
Thanks for the ask and using the Microsoft Q&A platform .
At this time, we are reaching out to the internal team to get some help on this . We will update you once we hear back from them.
Thanks
Himanshu
Hi sakuraime,
While Synapse dedicated pools do utilize Storage to hold the data, the storage account behind them is not accessible like it is for Spark pools. As Himanshu mentioned there's a discussion started with the product team to see if there is anything else we can share about the internal architecture.
hello. see if the column stored index is
column01 / per distribution/ per blob
column02 / per distribution/ per blob
??
thanks
6 people are following this question.