Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Sat, 13 Jul 2013 23:03:48 +0000 (UTC)
From: "Gunther Hagleitner (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12652334.1371021234540.46274.1373756628362@arcas>
In-Reply-To: <JIRA.12652334.1371021234540@arcas>
References: <JIRA.12652334.1371021234540@arcas>
Subject: [jira] [Commented] (HIVE-4721) Fix TestCliDriver.ptf_npath.q on
 0.23
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Gunther Hagleitner commented on HIVE-4721:
------------------------------------------

I think you've tried sorting in the wrong place. You need to make sure that the fl_num is in the sort key in the npath expression. Otherwise other rows of same date might come in between resulting in non-deterministic behavior.
                
> Fix TestCliDriver.ptf_npath.q on 0.23
> -------------------------------------
>
>                 Key: HIVE-4721
>                 URL: https://issues.apache.org/jira/browse/HIVE-4721
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Brock Noland
>            Assignee: Gunther Hagleitner
>         Attachments: HIVE-4721.1.patch
>
>
> In HIVE-4717 I tried changing the last line of ptf_npath.q from:
> {noformat}
> where fl_num = 1142;
> {noformat}
> to:
> {noformat}
> where fl_num = 1142 order by origin_city_name, fl_num, year, month, day_of_month, sz, tpath;
> {noformat}
> in order to make the test deterministic. However this results, not just different order, in different results for 0.23 and 0.20S. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira