[teiid-issues] [JBoss JIRA] (TEIID-3142) Vanilla Hive sorting issue

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13014000#comment-13014000 ] 

RH Bugzilla Integration commented on TEIID-3142:
------------------------------------------------

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1146522|https://bugzilla.redhat.com/show_bug.cgi?id=1146522] from NEW to MODIFIED

> Vanilla Hive sorting issue
> --------------------------
>
>                 Key: TEIID-3142
>                 URL: https://issues.jboss.org/browse/TEIID-3142
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>    Affects Versions: 8.7.1
>            Reporter: Filip Nguyen
>            Assignee: Steven Hawkins
>
> It seems that Vanilla Apache Hive 0.13 sorts in a yet another different way than what we expect and also differently from Cloudera Imapla (another Hive flavor).
> SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA order by BQT1.SmallA.StringNum
> 1: -1
> 2: -10
> 3: -11
> 4: -12
> 5: -13
> 6: -14
> 7: -15
> 8: -16
> 9: -17
> 10: -18
> 11: -19
> 12: -2
> 13: -20
> 14: -21
> 15: -22
> 16: -24
> 17: -3
> 18: -4
> 19: -5
> 20: -6
> 21: -8
> 22: -9
> 23: 0
> 24: 1
> 25: 10
> 26: 11
> 27: 12
> 28: 13
> 29: 14
> 30: 15
> 31: 16
> 32: 17
> 33: 18
> 34: 19
> 35: 2
> 36: 20
> 37: 21
> 38: 22
> 39: 23
> 40: 24
> 41: 3
> 42: 4
> 43: 5
> 44: 6
> 45: 7
> 46: 8
> 47: null
> 48: null
> 49: null
> 50: null



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)