[jira] [Commented] (HIVE-13165) resultset which query sql add 'order by' or 'sort by' return is different from not add it

["Gopal V (JIRA)" <ji...@apache.org>]

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

Gopal V commented on HIVE-13165:
--------------------------------

Try running this by disabling the FetchTask optimizer - {{set hive.fetch.task.conversion=none;}}

> resultset which query sql add 'order by' or 'sort by' return is different from not add it 
> ------------------------------------------------------------------------------------------
>
>                 Key: HIVE-13165
>                 URL: https://issues.apache.org/jira/browse/HIVE-13165
>             Project: Hive
>          Issue Type: Bug
>          Components: Clients
>    Affects Versions: 1.2.1
>         Environment: hadoop 2.5.2 hive 1.2.1 
>            Reporter: chillon_m
>            Assignee: Vaibhav Gumashta
>         Attachments: Hql not order.png, Hql with order.png
>
>
> resultset which query sql add 'order by' or 'sort by' return is different from not add it .size of resultset  and value of row is returned is different.



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