[
https://issues.apache.org/jira/browse/PHOENIX-3740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16738579#comment-16738579
]
Lars Hofhansl commented on PHOENIX-3740:
----------------------------------------
This is the same as Google Spanner's INTERLEAVED tables.
We'd inline a 1:many relationship into the the top level table, so joins are
simple scan, scan on the top table, though, would require SKIP scans.
> Allow scanning of a main table only, skipping views
> ---------------------------------------------------
>
> Key: PHOENIX-3740
> URL: https://issues.apache.org/jira/browse/PHOENIX-3740
> Project: Phoenix
> Issue Type: Bug
> Reporter: Lars Hofhansl
> Priority: Major
>
> That would allow us to to main and inner tables, and support joins between
> the two just through a simple scan.
> We can also add syntactic sugar like PARENT and CHILD (or INNER) tables.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
