You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2014/12/18 19:04:14 UTC
[jira] [Created] (DRILL-1889) 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
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)