drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4196) some TPCDS queries return wrong result when hash join is disabled
Date Mon, 08 Feb 2016 22:03:40 GMT

    [ https://issues.apache.org/jira/browse/DRILL-4196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15137810#comment-15137810
] 

Victoria Markman commented on DRILL-4196:
-----------------------------------------

Verified fixed in: 1.5.0

{code}
#Generated by Git-Commit-Id-Plugin
#Fri Feb 05 07:16:14 UTC 2016
git.commit.id.abbrev=af98e93
git.commit.user.email=hsuanyi@usc.edu
git.commit.message.full=DRILL-4323\: Handle skipAll query when use HiveDrillNativeParquetScan\n\nDo
not add Project when no column is needed to be read out from Scan (e.g., select count(*) from
hive.table)\n
git.commit.id=af98e93f09f13e82881637a68f40bbb0bc92586c
git.commit.message.short=DRILL-4323\: Handle skipAll query when use HiveDrillNativeParquetScan
git.commit.user.name=Hsuan-Yi Chu
git.build.user.name=Unknown
git.commit.id.describe=0.9.0-586-gaf98e93-dirty
git.build.user.email=Unknown
git.branch=master
git.commit.time=05.02.2016 @ 05\:11\:21 UTC
git.build.time=05.02.2016 @ 07\:16\:14 UTC
git.remote.origin.url=https\://github.com/apache/drill
{code}

> some TPCDS queries return wrong result when hash join is disabled
> -----------------------------------------------------------------
>
>                 Key: DRILL-4196
>                 URL: https://issues.apache.org/jira/browse/DRILL-4196
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Victoria Markman
>            Assignee: amit hadke
>             Fix For: 1.5.0
>
>         Attachments: 1.5.0-amit-branch_tpcds_sf1.txt, query40.tar, query52.tar
>
>
> With hash join disabled query52.sql and query40.sql returned incorrect result with 1.4.0
:
> {noformat}
> +-----------------+-------------------------------------------+---------------------------------------------------------------------+----------------------------+--------------+----------------------------+
> |     version     |                 commit_id                 |                     
     commit_message                            |        commit_time         | build_email
 |         build_time         |
> +-----------------+-------------------------------------------+---------------------------------------------------------------------+----------------------------+--------------+----------------------------+
> | 1.4.0-SNAPSHOT  | b9068117177c3b47025f52c00f67938e0c3e4732  | DRILL-4165 Add a precondition
for size of merge join record batch.  | 08.12.2015 @ 01:25:34 UTC  | Unknown      | 08.12.2015
@ 03:36:25 UTC  |
> +-----------------+-------------------------------------------+---------------------------------------------------------------------+----------------------------+--------------+----------------------------+
> 1 row selected (2.13 seconds)
> {noformat}
> Setup and options are the same as in DRILL-4190
> See attached queries (.sql), expected result (.e_tsv) and actual output (.out)



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

Mime
View raw message