[
https://issues.apache.org/jira/browse/BEAM-7758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16889378#comment-16889378
]
Rui Wang commented on BEAM-7758:
--------------------------------
[~rahul8383]
I think we can skip the DDL part at the beginning. We could start from
https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/src/main/java/org/apache/beam/sdk/extensions/sql/SqlTransform.java#L186.
As you can see, within Java program, users could construct a TableProvider,
within which we have a table which is used to construct PCollectionView later.
DDL (the create external table syntax) is used for pure SQL case(e.g. SQL
shell) which we could handle later.
User should be able to use the table created above to do a JOIN with Unbounded
Data source. It's less clear how this idea work with other SQL operator now.
But join should be a direct use case that we can pursue for this JIRA.
> Table returns PCollectionView in BeamSQL
> ----------------------------------------
>
> Key: BEAM-7758
> URL: https://issues.apache.org/jira/browse/BEAM-7758
> Project: Beam
> Issue Type: New Feature
> Components: dsl-sql
> Reporter: Rui Wang
> Priority: Major
>
> We might be able to define a table with properties that says this table
> return a PCollectionView. By doing so we will have a trigger based
> PCollectionView available in SQL rel nodes.
> Relevant thread:
> https://lists.apache.org/thread.html/602121ee49886590ce4975f66aa0d270b4a5d64575337fca8bef1232@%3Cdev.beam.apache.org%3E
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
