Rahul Challapalli created DRILL-1889:
----------------------------------------
Summary: 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: Execution - Flow
Reporter: Rahul Challapalli
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)
