[
https://issues.apache.org/jira/browse/CALCITE-1838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16048601#comment-16048601
]
Sihua Zhou commented on CALCITE-1838:
-------------------------------------
Thanks， Julian Hyde.
I think it's a good idea for this feature not be enabled by default, just for
the user that migrate from hive. I have read the link [explain why you have
problems with including it in the SELECT
clause|https://www.postgresql.org/message-id/4dd881c0.9020...@postnewspapers.com.au]
in [CALCITE-1581|https://issues.apache.org/jira/browse/CALCITE-1581]
discussion. But if it's just for Hive-compatible syntax, why not support the
hive 's udtf form"select udtf(xxx) as ... from table;" purely, and it not be
enable by default. Any way, our purpose is to be friendly for the user that
migrate from hive.
> 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
>
> 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)
