[ https://issues.apache.org/jira/browse/DRILL-4590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15230677#comment-15230677 ]
Dechang Gu commented on DRILL-4590: ----------------------------------- 1.2.0 release also show the same wrong results. > TPC-H q17 returns 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)