You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by ling miao <li...@apache.org> on 2021/11/30 08:59:23 UTC
[New Feature] Support lateral view
At present, users often need to use the bitmap type of doris for
intersection or union query.
Sometimes it is also necessary to perform row-to-column operations on the
results of the query.
This requires Doris to support the function of lateral view.
I wrote a simple design [1]
Do you have any opinions on this feature?
[1] https://github.com/apache/incubator-doris/issues/6746
Ling Miao
Re: [New Feature] Support lateral view
Posted by ling miao <li...@apache.org>.
I added a PR[1] to support lateral view operations on the results of
sub-queries. (Only include the planning part)
The usage is similar to
```
select e1 from (select k2 from table) tmp1 lateral view explode_split(k2,
",") tmp2 as e1;
```
[1] https://github.com/apache/incubator-doris/pull/7269
Ling Miao
陈明雨 <mo...@163.com> 于2021年11月30日周二 17:54写道：
> I added the desing of execution on BE side here[1].
> And also submit a PR[2]
>
>
> [1] https://github.com/apache/incubator-doris/issues/6746
> [2] https://github.com/apache/incubator-doris/pull/7255
>
>
>
>
> --
>
> 此致！Best Regards
> 陈明雨 Mingyu Chen
>
> Email:
> chenmingyu@apache.org
>
>
>
>
>
> At 2021-11-30 16:59:23, "ling miao" <li...@apache.org> wrote:
> >At present, users often need to use the bitmap type of doris for
> >intersection or union query.
> >Sometimes it is also necessary to perform row-to-column operations on the
> >results of the query.
> >This requires Doris to support the function of lateral view.
> >I wrote a simple design [1]
> >Do you have any opinions on this feature?
> >
> >[1] https://github.com/apache/incubator-doris/issues/6746
> >
> >Ling Miao
>
Re:[New Feature] Support lateral view
Posted by 陈明雨 <mo...@163.com>.
I added the desing of execution on BE side here[1].
And also submit a PR[2]
[1] https://github.com/apache/incubator-doris/issues/6746
[2] https://github.com/apache/incubator-doris/pull/7255
--
此致！Best Regards
陈明雨 Mingyu Chen
Email:
chenmingyu@apache.org
At 2021-11-30 16:59:23, "ling miao" <li...@apache.org> wrote:
>At present, users often need to use the bitmap type of doris for
>intersection or union query.
>Sometimes it is also necessary to perform row-to-column operations on the
>results of the query.
>This requires Doris to support the function of lateral view.
>I wrote a simple design [1]
>Do you have any opinions on this feature?
>
>[1] https://github.com/apache/incubator-doris/issues/6746
>
>Ling Miao