Mailing-List: contact dev-help@kylin.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@kylin.apache.org
MIME-Version: 1.0
In-Reply-To: <CABtHjTuQqVo-TGtyMg3w7LZJ9g_fkHONUNNj8pJX_67nSMq4OA@mail.gmail.com>
References: <CABtHjTuQqVo-TGtyMg3w7LZJ9g_fkHONUNNj8pJX_67nSMq4OA@mail.gmail.com>
From: =?UTF-8?Q?Alberto_Ram=C3=B3n?= <a.ramonportoles@gmail.com>
Date: Mon, 10 Oct 2016 20:16:34 +0200
Message-ID: <CAEcyM14fiR3ky4kRj0Ohgbw_H_RMR3Se2usULOX_O3SPERtdSg@mail.gmail.com>
Subject: Re: Incorrect query result
To: dev@kylin.apache.org
Content-Type: multipart/alternative; boundary=089e0122f07c9a05cf053e86c269
archived-at: Mon, 10 Oct 2016 18:16:57 -0000

--089e0122f07c9a05cf053e86c269
Content-Type: text/plain; charset=UTF-8

can you try this
<http://apache-kylin.74782.x6.nabble.com/about-kylin-sql-key-words-IN-td5908.html>


BR, Alb

2016-10-10 16:30 GMT+02:00 Joel Victor <joelsvictor@gmail.com>:

> There are two columns in the table which are event date and event hour.
> I have attached the result and the plans for all three queries that I ran.
>
> The first query will *not* show the value for date 2016-09-28 and hour 0
> in the result
> The second query will show the value for date 2016-09-28 and hour 0 in the
> result
> The third query will also show the value for date 2016-09-28 and hour 0 in
> the result
> According to me the first query should also show the value for date
> 2016-09-28 and hour 0 in the result
>
> All the three queries look correct to me and their plans look correct as
> well.
> I would appreciate any help in debugging this.
>
> Following are the three queries:
>
> Query one:
> SELECT
>   event_date, event_hour, SUM(cnt)
> FROM analytics_issue_report
> WHERE ((((event_date IN ('2016-09-28')) AND event_hour = 0)
> OR ((event_date IN ('2016-09-28')) AND event_hour >= 1)
> OR ((event_date IN ('2016-10-04')) AND event_hour = 23)
> OR ((event_date IN ('2016-10-04')) AND event_hour < 23)
> OR event_date BETWEEN '2016-09-29' AND '2016-10-03')
> AND action_type=1)
> GROUP BY event_date, event_hour ORDER BY event_date, event_hour;
>
> Query two:
> SELECT
>   event_date, event_hour, SUM(cnt)
> FROM analytics_issue_report
> WHERE ((event_date BETWEEN '2016-09-28' AND '2016-10-04')
> AND action_type=1)
> GROUP BY event_date, event_hour ORDER BY event_date, event_hour;
>
> Query three:
> SELECT
>   event_date, event_hour, SUM(cnt)
> FROM analytics_issue_report
> WHERE ((((event_date IN ('2016-09-28')) AND event_hour <= 23)
> OR ((event_date IN ('2016-10-04')) AND event_hour = 23)
> OR ((event_date IN ('2016-10-04')) AND event_hour < 23)
> OR event_date BETWEEN '2016-09-29' AND '2016-10-03')
> AND action_type=1)
> GROUP BY event_date, event_hour ORDER BY event_date, event_hour;
>
>

--089e0122f07c9a05cf053e86c269--