[
https://issues.apache.org/jira/browse/IMPALA-11527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
gaoxiaoqing updated IMPALA-11527:
---------------------------------
Description:
Currently, Impala does not support user-defined table functions (UDTFs), some
Data Analysis Scenario need this feature such as funnel analysis, session
analysis and so on. Other database Hive, Max compute support udtf. for example
explode in hive:
https://github.com/apache/hive/blob/master/ql/src/test/results/clientpositive/llap/udtf_explode.q.out
Do we have plan to support impala udtf? The syntax of query is as follows,
select udtf_explode(info) as (name, phone) from table;
Besides, we can also support the following syntax,
select udtf_example(c1, c2, c3) over (partition by c1 order by c2) as (num, c1,
c2) from table;
Users can create udtf, the create grammar as follows:
create transform function udtf_example(BIGINT, STRING, STRING, ...)
location '/tmp/libimpalaExts.so' prepare_fn='' init_fn='' update_fn=''
finalize_fn='' close_fn=''
was:
Currently, Impala does not support user-defined table functions (UDTFs), some
Data Analysis Scenario need this feature such as funnel analysis, session
analysis and so on. Other database hive, Max compute support udtf. for example
explode in hive:
[https://github.com/apache/hive/blob/master/ql/src/test/results/clientpositive/llap/udtf_explode.q.out]
Do we have plan to support impala udtf? The query grammar as follows:
select udtf_explode(info) as (name, phone) from table;
select udtf_example(c1, c2, c3) over (partition by c1 order by c2) as (num, c1,
c2) from table;
Users can create udtf, the create grammar as follows:
create transform function udtf_example(BIGINT, STRING, STRING, ...)
location '/tmp/libimpalaExts.so' prepare_fn='' init_fn='' update_fn=''
finalize_fn='' close_fn=''
> SUPPORT user-defined table functions (UDTFs)
> --------------------------------------------
>
> Key: IMPALA-11527
> URL: https://issues.apache.org/jira/browse/IMPALA-11527
> Project: IMPALA
> Issue Type: New Feature
> Reporter: gaoxiaoqing
> Assignee: gaoxiaoqing
> Priority: Major
>
> Currently, Impala does not support user-defined table functions (UDTFs), some
> Data Analysis Scenario need this feature such as funnel analysis, session
> analysis and so on. Other database Hive, Max compute support udtf. for
> example explode in hive:
> https://github.com/apache/hive/blob/master/ql/src/test/results/clientpositive/llap/udtf_explode.q.out
> Do we have plan to support impala udtf? The syntax of query is as follows,
> select udtf_explode(info) as (name, phone) from table;
> Besides, we can also support the following syntax,
> select udtf_example(c1, c2, c3) over (partition by c1 order by c2) as (num,
> c1, c2) from table;
> Users can create udtf, the create grammar as follows:
> create transform function udtf_example(BIGINT, STRING, STRING, ...)
> location '/tmp/libimpalaExts.so' prepare_fn='' init_fn='' update_fn=''
> finalize_fn='' close_fn=''
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
