[ https://issues.apache.org/jira/browse/DRILL-1889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau resolved DRILL-1889. ----------------------------------- Resolution: Fixed > when 'select *' is used along with an order by on length of a column, Drill > is adding the computed length to the list of columns > -------------------------------------------------------------------------------------------------------------------------------- > > Key: DRILL-1889 > URL: https://issues.apache.org/jira/browse/DRILL-1889 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Reporter: Rahul Challapalli > Assignee: Jinfeng Ni > Priority: Critical > Fix For: 0.9.0 > > Attachments: > 0001-DRILL-1889-Fix-star-column-prefix-and-subsume-logic-.patch.3 > > > git.commit.id.abbrev=9dfa4a1 > Dataset : > {code} > { > "col1":1, > "col2":"a" > } > { > "col1":2, > "col2":"b" > } > { > "col1":2, > "col2":"abc" > } > {code} > Query : > {code} > select * from `b.json` order by length(col2); > +------------+------------+------------+ > | col1 | col2 | EXPR$1 | > +------------+------------+------------+ > | 1 | a | 1 | > | 2 | b | 1 | > | 2 | abc | 3 | > +------------+------------+------------+ > {code} > Drill adds the length column. (EXPR$1) Not sure if this is intended behavior > since postgres does not do this -- This message was sent by Atlassian JIRA (v6.3.4#6332)