drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-966) multiple distinct with group by asserts
Date Mon, 06 Oct 2014 18:32:33 GMT

     [ https://issues.apache.org/jira/browse/DRILL-966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Chun Chang resolved DRILL-966.
------------------------------
    Resolution: Fixed

#Thu Oct 02 17:49:48 PDT 2014
git.commit.id.abbrev=29dde76

It works with this commit now.

0: jdbc:drill:schema=dfs> select max(distinct(c_int)), max(distinct(c_bigint)), max(distinct(c_float4)),
max(distinct(c_float8)), max(distinct(cast(c_float4 as decimal(9,3)))), max(distinct(cast(c_decimal9
as decimal(28,9)))), max(distinct(cast(c_decimal18 as decimal(38,18)))) from data where c_row
<> 5 and c_row <> 14 and c_row <> 19 group by c_int;
+------------+------------+------------+------------+------------+------------+------------+
|   EXPR$0   |   EXPR$1   |   EXPR$2   |   EXPR$3   |   EXPR$4   |   EXPR$5   |   EXPR$6 
 |
+------------+------------+------------+------------+------------+------------+------------+
| 0          | 0          | 10.5       | 10.5       | 10.500     | 9999.990000000 | 0.000900000000000000
|
| 1          | 922337203685477580 | 100.06     | 10.5       | 100.060    | 1.000000000 | 4593.290000000000000000
|
| -1         | -1         | 10.5       | 4.9E-324   | 10.500     | 123456789.000000000 | 123456789.000000000000000000
|
| 12         | 12         | 100.006    | 1.23456789012345E14 | 100.006    | 999999999.000000000
| 999999999.000000000000000000 |
| 92032039   | -9223372036854775808 | 123456.0   | 4.9E-324   | 123456.000 | 1.0E-8     |
1.0000000000E-8 |
| -23395000  | 9223372036854775807 | 999999.0   | 4.9E-324   | 999999.000 | -1.0E-8    | -1.0000000000E-8
|
| -99392039  | 4567890123456789 | 1.4E-45    | 1.0        | -999999.000 | 12345.678900000
| 12345.678900000000000000 |
| -2147483648 | -4567890123456789 | 1.0E-5     | 1.2345E-10 | 0.000      | -9876.543210000
| 123456789.123456789000000000 |
| 2147483647 | 920320399049584 | 1.4E-45    | 1234.56789012345 | 0.000      | 123.450000000
| 999999999999999999.000000000000000000 |
| 32767      | -922337203685477580 | 0.1        | 4.9E-324   | 0.100      | -54.321000000
| -999999999999999999.000000000000000000 |
| -32767     | -99392039  | 0.5        | 4.9E-324   | 0.500      | 100.006000000 | 1.0E-17
   |
| 49032      | -2147483648 | 0.6        | 2.147483647E9 | 0.600      | -1.000060000 | -1.0E-17
  |
| 69834830   | 32767      | 1.4E-45    | 4.9E-324   | -456.678   | 999999.000000000 | 1234.567890123450000000
|
| 243        | -32767     | 1203.43    | 100.006    | 1203.430   | -999999.000000000 | -56789012345.123400000000000000
|
| -426432    | 49032      | 9999.99    | 4.9E-324   | 9999.990   | 0.000010000 | -2147483648.000000000000000000
|
| -3904      | -4989385   | 1.4E-45    | 123456.0   | -9999.990  | 0E-9       | 2147483647.000000000000000000
|
| 589032574  | 243        | 4593.29    | 4.9E-324   | 4593.290   | 0.500000000 | -32767.000000000000000000
|
| 340000504  | -426432    | 9302.21    | 1.0E-5     | 9302.210   | 0.600000000 | -9999.990000000000000000
|
+------------+------------+------------+------------+------------+------------+------------+
18 rows selected (4.073 seconds)

> multiple distinct with group by asserts
> ---------------------------------------
>
>                 Key: DRILL-966
>                 URL: https://issues.apache.org/jira/browse/DRILL-966
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>            Reporter: Chun Chang
>            Assignee: Chun Chang
>             Fix For: 0.6.0
>
>
> #Wed Jun 11 10:19:21 PDT 2014
> git.commit.id.abbrev=27a9c98
> With multiple distinct in query and with group by clause, drill bit asserted with the
following query:
> 0: jdbc:drill:schema=dfs> select max(distinct(c_int)), max(distinct(c_bigint)), max(distinct(c_float4)),
max(distinct(c_float8)), max(distinct(cast(c_float4 as decimal(9,3)))), max(distinct(cast(c_decimal9
as decimal(28,9)))), max(distinct(cast(c_decimal18 as decimal(38,18)))) from data where c_row
<> 5 and c_row <> 14 and c_row <> 19 group by c_int;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id:
"7f426693-9249-43bc-ba46-0ea42accd1c9"
> endpoint {
>   address: "qa-node118.qa.lab"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < AssertionError"
> ]
> Error: exception while executing query (state=,code=0)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message