Lets say i have 3 dimensions in my druid data source:

A,B,C where A,B are single valued dimensions and C is a multi valued dimension and i have 3 rows of data like this:

a b c1,c2,c3

a b c2,c3,c1

a b c3,c1,c2

assuming they all belong to same time interval will these 3 rows be rolled up in 1??They just differ in the order of multi dimension value.

Lets say we have 3 more rows

a b c1

a b c1,c2

a b c1,c2,c3

Will any sort of aggregation/rollup happen across these rows??

Also lets assume i have another datasource with 20+ dimensions in which 10 dimension are frequently queried together,and queries needing all 20 dimensions are less.Will it give any significant query performance improvement if i break it into 2 data source with 1 having frequently queried 10 dimension and another having all 20 dimension??This will reduce the number of rows that first data source will contain but will increase the total storage requirement of druid cluster.

Thanks

Rohit