[CALCITE-1838] Support hive's udtf grammar.

• Type: New Feature
• Status: Closed
• Priority: Blocker
• Resolution: Duplicate
• Affects Version/s: 1.12.0
• Fix Version/s: 1.13.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Sihua Zhou
• Created: 13/Jun/17 07:36
• Updated: 21/Jul/17 01:41
• Resolved: 13/Jun/17 16:20

Description

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.

Issue Links

• is related to: CALCITE-1581 UDTF like in hive