You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "grandfisher (Jira)" <ji...@apache.org> on 2023/08/09 08:43:00 UTC

[jira] [Updated] (CALCITE-5871) Data distributions need to be combined and represented.

     [ https://issues.apache.org/jira/browse/CALCITE-5871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

grandfisher updated CALCITE-5871:
---------------------------------
    Affects Version/s:     (was: 1.27.0)

> Data distributions need to be combined and represented.
> -------------------------------------------------------
>
>                 Key: CALCITE-5871
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5871
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>            Reporter: grandfisher
>            Priority: Major
>
> For a distributed partition database, the data may be partitioned by time, and also hash partitioned by the `region` field.
> If there is agg that  aggregate on "(Day,Region)", It's hard to show AGG rel distribution.（range(Day) hash(region))
> And for another hash shuffle join case  `( L join R  on L.a=R.c and L.b =R.d  ) as T` , now  T has satisfy two distributions, one is Hash(a,b) and  another is Hash(c,d),  it's not Hash(a,b,c,d). But we must lost one of them because the Reldistribution can  only  has one distribution.
> We think this is common in time-series distributed databases



--
This message was sent by Atlassian Jira
(v8.20.10#820010)