[jira] [Commented] (CALCITE-1838) Support hive's udtf grammar.

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-1838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16048077#comment-16048077 ] 

Julian Hyde commented on CALCITE-1838:
--------------------------------------

It's a reasonable feature. If it causes ambiguity with the existing grammar, then we will have to figure out how to add it, and whether it is enabled by default. We should make it clear that it is syntactic sugar for "SELECT ... FROM TABLE Udtf(...)".

I personally don't have the cycles to implement this feature. If someone wants it, they should contribute a pull request.

> Support hive's udtf grammar.
> ----------------------------
>
>                 Key: CALCITE-1838
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1838
>             Project: Calcite
>          Issue Type: New Feature
>          Components: core
>    Affects Versions: 1.12.0
>            Reporter: Sihua Zhou
>            Assignee: Julian Hyde
>            Priority: Blocker
>              Labels: features
>
> Now Calcite doesn't support the hive form of UDTF, eg:
> _select udtf(arg1, arg2) as (seg1, seg2, seg3) from table_
> Instead, it provide a table function. But we found that hive's udtf form is more easier for users to understand.
> We are building a stream sql framework with calcite, which allow user to process data stream by write sql. And most users are migrated from using hive to process offline data. So, use hive's udtf is more friendly to them.
> Can you add the feature to support hive udtf in calcite? We really need it.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)