[
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)
