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/07/25 13:42:00 UTC

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

grandfisher created CALCITE-5871:
------------------------------------

             Summary: 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: server
            Reporter: grandfisher


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.



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)