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

Posted to dev@calcite.apache.org by Prasad V S <pr...@nanobianalytics.com> on 2016/12/05 09:35:58 UTC

Find Relations between tables

Hi Team,
Is there any ways to identify relations between table data.

Thanks,Prasad

Re: Find Relations between tables

Posted by Julian Hyde <jh...@apache.org>.

Calcite doesn’t model foreign keys. But of course the Schema API might be on top of a metastore that does model foreign keys.

The only thing similar to this is Lattice[1]. It models a star schema, and which has many-to-one relationships from the fact table to each dimension table.

Julian

[1] https://calcite.apache.org/docs/lattice.html <https://calcite.apache.org/docs/lattice.html>

> On Dec 5, 2016, at 1:35 AM, Prasad V S <pr...@nanobianalytics.com> wrote:
> 
> Hi Team,
> Is there any ways to identify relations between table data.
> 
> Thanks,Prasad