You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Johannes Schulte <jo...@gmail.com> on 2016/05/09 18:56:13 UTC
Unnesting / exploding
Hi!
Is there a plan for introducing a way to explode the contents of a map,
similar to what hive and drill offer? Currently the only way of accessing
map entries is knowing the exact keys. I looked through the code but did
not find anything for this. Would this be a useful contribution?
Cheers,
Johannes
Re: Unnesting / exploding
Posted by Julian Hyde <jh...@gmail.com>.
Johannes,
I had a quick look at https://issues.apache.org/jira/browse/CALCITE-1250 <https://issues.apache.org/jira/browse/CALCITE-1250> and your work looks very promising. I made you a contributor so you won’t have any further problems with JIRA.
Julian
> On May 19, 2016, at 2:06 PM, Johannes Schulte <jo...@gmail.com> wrote:
>
> Never mind, it just worked and i hit the wrong button. Here is the pull
> request:
>
> https://github.com/apache/calcite/pull/235
>
> On Thu, May 19, 2016 at 10:37 PM, Johannes Schulte <
> johannes.schulte@gmail.com> wrote:
>
>> Hi,
>>
>> I did my best to implement this feature and would like to open an issue
>> and attach a pull request. Is it still the case that creating issues needs
>> special rights due to the recent spam attacks?
>>
>> Cheers,
>>
>> Johannes
>>
>> On Tue, May 10, 2016 at 12:07 PM, Johannes Schulte <
>> johannes.schulte@gmail.com> wrote:
>>
>>> Thanks Julian, I'll have a look into it and then file a issue!
>>>
>>> On Tue, May 10, 2016 at 12:42 AM, Julian Hyde <jh...@apache.org> wrote:
>>>
>>>> It would make a lot of sense if the UNNEST operator could work on MAP
>>>> the same way it works on ARRAY (except that it would produce 2 columns
>>>> rather than 1). Feel free to log a JIRA case for that or for whatever Drill
>>>> does.
>>>>
>>>> Julian
>>>>
>>>>
>>>>> On May 9, 2016, at 11:56 AM, Johannes Schulte <
>>>> johannes.schulte@gmail.com> wrote:
>>>>>
>>>>> Hi!
>>>>>
>>>>> Is there a plan for introducing a way to explode the contents of a map,
>>>>> similar to what hive and drill offer? Currently the only way of
>>>> accessing
>>>>> map entries is knowing the exact keys. I looked through the code but
>>>> did
>>>>> not find anything for this. Would this be a useful contribution?
>>>>>
>>>>> Cheers,
>>>>>
>>>>> Johannes
>>>>
>>>>
>>>
>>
Re: Unnesting / exploding
Posted by Johannes Schulte <jo...@gmail.com>.
Never mind, it just worked and i hit the wrong button. Here is the pull
request:
https://github.com/apache/calcite/pull/235
On Thu, May 19, 2016 at 10:37 PM, Johannes Schulte <
johannes.schulte@gmail.com> wrote:
> Hi,
>
> I did my best to implement this feature and would like to open an issue
> and attach a pull request. Is it still the case that creating issues needs
> special rights due to the recent spam attacks?
>
> Cheers,
>
> Johannes
>
> On Tue, May 10, 2016 at 12:07 PM, Johannes Schulte <
> johannes.schulte@gmail.com> wrote:
>
>> Thanks Julian, I'll have a look into it and then file a issue!
>>
>> On Tue, May 10, 2016 at 12:42 AM, Julian Hyde <jh...@apache.org> wrote:
>>
>>> It would make a lot of sense if the UNNEST operator could work on MAP
>>> the same way it works on ARRAY (except that it would produce 2 columns
>>> rather than 1). Feel free to log a JIRA case for that or for whatever Drill
>>> does.
>>>
>>> Julian
>>>
>>>
>>> > On May 9, 2016, at 11:56 AM, Johannes Schulte <
>>> johannes.schulte@gmail.com> wrote:
>>> >
>>> > Hi!
>>> >
>>> > Is there a plan for introducing a way to explode the contents of a map,
>>> > similar to what hive and drill offer? Currently the only way of
>>> accessing
>>> > map entries is knowing the exact keys. I looked through the code but
>>> did
>>> > not find anything for this. Would this be a useful contribution?
>>> >
>>> > Cheers,
>>> >
>>> > Johannes
>>>
>>>
>>
>
Re: Unnesting / exploding
Posted by Johannes Schulte <jo...@gmail.com>.
Hi,
I did my best to implement this feature and would like to open an issue and
attach a pull request. Is it still the case that creating issues needs
special rights due to the recent spam attacks?
Cheers,
Johannes
On Tue, May 10, 2016 at 12:07 PM, Johannes Schulte <
johannes.schulte@gmail.com> wrote:
> Thanks Julian, I'll have a look into it and then file a issue!
>
> On Tue, May 10, 2016 at 12:42 AM, Julian Hyde <jh...@apache.org> wrote:
>
>> It would make a lot of sense if the UNNEST operator could work on MAP the
>> same way it works on ARRAY (except that it would produce 2 columns rather
>> than 1). Feel free to log a JIRA case for that or for whatever Drill does.
>>
>> Julian
>>
>>
>> > On May 9, 2016, at 11:56 AM, Johannes Schulte <
>> johannes.schulte@gmail.com> wrote:
>> >
>> > Hi!
>> >
>> > Is there a plan for introducing a way to explode the contents of a map,
>> > similar to what hive and drill offer? Currently the only way of
>> accessing
>> > map entries is knowing the exact keys. I looked through the code but did
>> > not find anything for this. Would this be a useful contribution?
>> >
>> > Cheers,
>> >
>> > Johannes
>>
>>
>
Re: Unnesting / exploding
Posted by Johannes Schulte <jo...@gmail.com>.
Thanks Julian, I'll have a look into it and then file a issue!
On Tue, May 10, 2016 at 12:42 AM, Julian Hyde <jh...@apache.org> wrote:
> It would make a lot of sense if the UNNEST operator could work on MAP the
> same way it works on ARRAY (except that it would produce 2 columns rather
> than 1). Feel free to log a JIRA case for that or for whatever Drill does.
>
> Julian
>
>
> > On May 9, 2016, at 11:56 AM, Johannes Schulte <
> johannes.schulte@gmail.com> wrote:
> >
> > Hi!
> >
> > Is there a plan for introducing a way to explode the contents of a map,
> > similar to what hive and drill offer? Currently the only way of accessing
> > map entries is knowing the exact keys. I looked through the code but did
> > not find anything for this. Would this be a useful contribution?
> >
> > Cheers,
> >
> > Johannes
>
>
Re: Unnesting / exploding
Posted by Julian Hyde <jh...@apache.org>.
It would make a lot of sense if the UNNEST operator could work on MAP the same way it works on ARRAY (except that it would produce 2 columns rather than 1). Feel free to log a JIRA case for that or for whatever Drill does.
Julian
> On May 9, 2016, at 11:56 AM, Johannes Schulte <jo...@gmail.com> wrote:
>
> Hi!
>
> Is there a plan for introducing a way to explode the contents of a map,
> similar to what hive and drill offer? Currently the only way of accessing
> map entries is knowing the exact keys. I looked through the code but did
> not find anything for this. Would this be a useful contribution?
>
> Cheers,
>
> Johannes