kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Luke Han (JIRA)" <>
Subject [jira] [Commented] (KYLIN-751) Max on negative double values is not working
Date Wed, 19 Aug 2015 01:20:46 GMT


Luke Han commented on KYLIN-751:

Hi Yang, did you have check this issue?


> Max on negative double values is not working
> --------------------------------------------
>                 Key: KYLIN-751
>                 URL:
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine, REST Service
>    Affects Versions: v0.7.1
>            Reporter: Huang Hua
>            Assignee: liyang
> I spent some time to debug the kylin code and I think it's very likely a bug in Query
module. It keeps returning 4.9E-324 for max of negative values.
> The cube and the fact table was illustrated before in the last couple emails. The query
I used was "select id, sum(trans_at), max(trans_at) from max_neg group by id;".
> When the query hit the rest server, it will be passed to the function "private SQLResponse
execute(String sql, SQLRequest sqlRequest)" of "QueryService" class in kylin-server module.
> And in that function, it utilizes the calcite to parse the sql and the kylin-storage
module to actually fetch data from hbase. However, the following codes of the function packages
wrong results.
>             while ( {
>                 for (int i = 0; i < columnCount; i++) {
>                     oneRow.add((resultSet.getString(i + 1))); -- This produce wrong result
like [2c9083862fe1d8f00130062167480ce8-213582789, -86.4, 4.9E-324]
>                 }
>                 results.add(new LinkedList<String>(oneRow));
>                 oneRow.clear();
>             }
> I also checked the related functions of kylin-storage, and the results fetched from hbase
were all good, for example, the function "public Tuple next()" of "CubeSegmentTupleIterator"
class returned [2c9083862fe1d8f00130062167480ce8-0114097017, -59.0, 1, -59.0] and the function
"private Object[] convertCurrentRow(ITuple tuple)" of "CubeEnumerator" class also returned
[2c9083862fe1d8f00130062167480ce8-0114097017, -59.0, 1, -59.0] which I think both are correct.

This message was sent by Atlassian JIRA

View raw message