You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@kylin.apache.org by Li Yang <li...@apache.org> on 2016/02/12 02:28:51 UTC

Re: FILTER clause not honored in query

Could you provide a full sql of the third case?  Just want to make sure we
all understand the same problem.

On Thu, Feb 11, 2016 at 6:40 AM, Jason Wang (WDG) <ja...@microsoft.com>
wrote:

> After my cube is built,
>
> “SELECT COUNT(*) FROM table” gives the correct result.
>
> “SELECT COUNT(*) FROM table WHERE condition” also gives the correct
> result, but
>
> “SELECT COUNT(*) FILTER (WHERE condition) FROM table” gives the wrong
> result – as if there is no filter at all.
>
>
>
> It is common to have multiple aggregates in one query, each with different
> conditions. Without the FILTER clause, we will have to write multiple
> queries then combine the results together.
>

Re: FILTER clause not honored in query

Posted by Li Yang <li...@apache.org>.

Found an example in https://issues.apache.org/jira/browse/KYLIN-899

This is valid request and the JIRA is there. Will work on it.

On Fri, Feb 12, 2016 at 9:28 AM, Li Yang <li...@apache.org> wrote:

> Could you provide a full sql of the third case?  Just want to make sure we
> all understand the same problem.
>
> On Thu, Feb 11, 2016 at 6:40 AM, Jason Wang (WDG) <ja...@microsoft.com>
> wrote:
>
>> After my cube is built,
>>
>> “SELECT COUNT(*) FROM table” gives the correct result.
>>
>> “SELECT COUNT(*) FROM table WHERE condition” also gives the correct
>> result, but
>>
>> “SELECT COUNT(*) FILTER (WHERE condition) FROM table” gives the wrong
>> result – as if there is no filter at all.
>>
>>
>>
>> It is common to have multiple aggregates in one query, each with
>> different conditions. Without the FILTER clause, we will have to write
>> multiple queries then combine the results together.
>>
>
>