You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2014/10/06 20:32:33 UTC
[jira] [Resolved] (DRILL-966) multiple distinct with group by
asserts
[ 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)