[ https://issues.apache.org/jira/browse/CALCITE-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16721037#comment-16721037 ]
Lai Zhou commented on CALCITE-1581: ----------------------------------- [~julianhyde] , I extended the native enummerable implemention of calcite to support Hive sql ,include UDF、UDAF and all the SqlSpecialOperator,which inspired by apache Drills. I modified the parser,type systems,and bridge the hive operator . How do you think of supporting a direct implemention of hive sql like this? I think it will be valueable when someone want to migrate his hive etl jobs to real-time scene.I opened a new issure to disccuss it, please see https://issues.apache.org/jira/browse/CALCITE-2741 > UDTF like in hive > ----------------- > > Key: CALCITE-1581 > URL: https://issues.apache.org/jira/browse/CALCITE-1581 > Project: Calcite > Issue Type: New Feature > Reporter: Xiaoyong Deng > Assignee: Sihua Zhou > Priority: Major > Labels: udtf > > Support one row in and multi-column/multi-row out(one-to-many mapping), just > like udtf in hive. > The query would like this: > {code} > select > func(c0, c1) as (f0, f1, f2) > from table_name; > {code} > c0 and c1 are 'table_name' columns. f0, f1 and f2 are new generated columns. -- This message was sent by Atlassian JIRA (v7.6.3#76005)