[jira] [Commented] (CALCITE-2741) Add operator table with Hive-specific built-in functions

["Lai Zhou (JIRA)" <ji...@apache.org>]

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

Lai Zhou commented on CALCITE-2741:
-----------------------------------

hi,[~julianhyde] , [~zabetak],[~zhztheplayer], [~hyuan],[~francischuang]

I create a new adapter of Calcite that support hive sql queries on dataset. 

Since the extensions is made base on Calcite 1.18.0, I pushed the project to a new codebase. 

[[https://github.com/51nb/marble]|[https://github.com/51nb/marble]].

And I proposed a Table API to make it easy to execute a sql query.

We use it in our company's core financial business to unify the way to compute lots of model variables .

This project shows how we extend Calcite core to support hive sql queries, it may be helpful to people 

who wants to build a customized sql engine on top of Calcite.

 

 

 

 

> Add operator table with Hive-specific built-in functions
> --------------------------------------------------------
>
>                 Key: CALCITE-2741
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2741
>             Project: Calcite
>          Issue Type: New Feature
>          Components: core
>            Reporter: Lai Zhou
>            Priority: Minor
>
> [~julianhyde],
> I write a hive adapter for calcite to support Hive sql ,includes UDF、UDAF、UDTF and some of SqlSpecialOperator.
> 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.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)