Re: filter partitions

Hi Oliver,

You can use the below query to get output for filtering table partition 2,4.

select p,item from parent_table where item='D' and p in (2,4) group by
p,item;

Hope this helps.

<http://www.shreeyansh.com>

On Tue, Feb 13, 2018 at 8:37 PM, Olivier Leprêtre <o(dot)lepretre(at)gmail(dot)com>
wrote:

> Hi,
>
>
>
> I wonder how could it be possible to extract partitions that contains a
> peculiar item
>
>
>
> Consider 4 partitions 1, 2, 3, 4 with different items A, B, C... inside
>
>
>
> P item
>
> 1 A
>
> 1 B
>
> 1 C
>
> 2 B
>
> *2 D*
>
> 2 G
>
> 2 H
>
> 3 B
>
> 3 C
>
> 4 X
>
> *4 D*
>
> 4 Z
>
>
>
>
>
> How could a select return partitions 2,4 because they both contains D item
> ?
>
>
>
> As a result, I would get :
>
>
>
> 2 B
>
> 2 D
>
> 2 G
>
> 2 H
>
> 4 X
>
> 4 D
>
> 4 Z
>
>
>
> I can filter partitions with lag, lead, nth_value... but how could I write
> something like "select P,any (item=D) over (partition by P) from..."
>
>
>
> Thanks for any help,
>
>
>
>
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> Garanti
> sans virus. www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
> <#m_-6275419886238405028_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>