Dechang Gu created DRILL-4590:
---------------------------------
Summary: Queries return wrong results when applied to views
Key: DRILL-4590
URL: https://issues.apache.org/jira/browse/DRILL-4590
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Affects Versions: 1.6.0
Environment: RHEL 6.4 2.6.32-358.el6.x86_64
Reporter: Dechang Gu
Priority: Critical
When run tpch queries on views created from parquet tables, query 17 returned
wrong results:
[root@ucs-node1 bugs]# /opt/mapr/drill/drill-1.6.0/bin/sqlline -u
"jdbc:drill:schema=dfs.tpchViews" -f /tmp/TPCH_17.sql
1/1 select
sum(l.l_extendedprice) / 7.0 as avg_yearly
from
lineitem l,
part p
where
p.p_partkey = l.l_partkey
and p.p_brand = 'Brand#13'
and p.p_container = 'JUMBO CAN'
and l.l_quantity < (
select
0.2 * avg(l2.l_quantity)
from
lineitem l2
where
l2.l_partkey = p.p_partkey
);
+---------------------+
| avg_yearly |
+---------------------+
| 1139490.7042857148 |
+---------------------+
1 row selected (20.364 seconds)
While the same query directly on the parquet tables shows the correct results:
[root@ucs-node1 bugs]# /opt/mapr/drill/drill-1.6.0/bin/sqlline -u
"jdbc:drill:schema=dfs.parquet" -f /tmp/17_par100.q
1/1 select
sum(l.l_extendedprice) / 7.0 as avg_yearly
from
lineitem_par100 l,
part_par100 p
where
p.p_partkey = l.l_partkey
and p.p_brand = 'Brand#13'
and p.p_container = 'JUMBO CAN'
and l.l_quantity < (
select
0.2 * avg(l2.l_quantity)
from
lineitem_par100 l2
where
l2.l_partkey = p.p_partkey
);
+----------------------+
| avg_yearly |
+----------------------+
| 3.237333813714285E7 |
+----------------------+
1 row selected (25.266 seconds)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
