phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel Reid <gabriel.r...@gmail.com>
Subject Re: Query returning different results in Apache Phoenix and MySQL
Date Mon, 12 Jan 2015 07:50:15 GMT
Hi Kunal,

I think you'll need to post some additional information to get an
answer to your question. You said that MySQL returns 35 rows and
Phoenix returns 32 rows, but it's not clear from your description what
the rows are that are missing from the Phoenix result, or what it is
that makes the Phoenix result incorrect and the MySQL result correct.

The best approach to resolving this would be to create a minimal case,
with a smaller number of rows, that demonstrates the issue that you're
encountering.

- Gabriel


On Mon, Jan 12, 2015 at 8:43 AM, Kunal Gupta <kunal1340@iiitd.ac.in> wrote:
> I have a table named as EVENTLOG which has 3 columns:
>
>     (CASEID VARCHAR(200), DATEPLUSTIME TIMESTAMP, SUBSTATUS VARCHAR(200))
>
> DATEPLUSTIME is in format of YYYY-MM-DD hh:mm:ss. Below is the query that
> will work on Apache phoenix as well as for MySQL.
>
>     SELECT DISTINCT E1.SUBSTATUS
>       FROM EVENTLOG AS E1
>         WHERE E1.DATEPLUSTIME IN
>              (SELECT MIN(E2.DATEPLUSTIME)
>                          FROM EVENTLOG AS E2
>                               GROUP BY E2.CASEID);
>
> Table contains 466738 records. When i perform the above query in MySQL , i
> get 35 rows of it but on Apache Phoenix i get 32 rows so it is missing 3
> rows why is there difference in their result.
> Table looks like the following(Records Striped).
>
>      +----+---+---+---+--+----------+----+-----------+
>      | CASEID |      DATEPLUSTIME  | SUBSTATUS |
>      +----+---+---+---+--------+-----+---+-----------+
>      |  1     | 2010-04-10 18:20:38      | Assignment|
>      |  1     | 2010-04-10 20:12:56      | Update    |
>      |  1     | 2010-11-23 23:12:34      | Assigned  |
>      |  1     | 2010-11-25 23:45:34      | Assigned  |
>      |  2     | 2010-12-30 12:32:23      | Reassigned|
>      |  2     | 2014-12-30 12:34:21      | Operator  |
>      |  2     | 2014-12-25 20:32:45      | Operator  |
>      |  3     | 2014-12-26 08:45:54      | Progress  |
>      |  3     | 2014-12-30 08:49:32      | Call      |
>      +----+---+---+---+---+----+------+--+-----------+
> [Expected Output]
>
>     Assignment
>     Reassigned
>     Progress
>
> MySQL does the task correctly butr Phoenix return incomplete result.
> Please help me.
>
>
> Thanks , Kunal
>

Mime
View raw message