Ramana Inukonda Nagaraj created DRILL-586:
---------------------------------------------
Summary: Order by on select * fails
Key: DRILL-586
URL: https://issues.apache.org/jira/browse/DRILL-586
Project: Apache Drill
Issue Type: Bug
Reporter: Ramana Inukonda Nagaraj
0: jdbc:drill:schema=dfs.drillTestDirP1> explain plan for select * from student
order by age;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query.[error_id: "e2eb9f49-d82b-41f3-a518-8ab698ed5812"
endpoint {
address: "drillats3.qa.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while setting up Foreman. < AssertionError:[ Internal error:
Conversion to relational algebra failed to preserve datatypes:\nvalidated
type:\nRecordType(ANY NOT NULL *) NOT NULL\nconverted type:\nRecordType(ANY NOT
NULL *, ANY NOT NULL age) NOT NULL\nrel:\nProjectRel(*=[$0], age=[$1])\n
SortRel(sort0=[$1], dir0=[ASC])\n ProjectRel(*=[$0], age=[$1], age0=[$1])\n
TableAccessRel(table=[[dfs, drillTestDirP1, student]])\n ]"
]
Error: exception while executing query (state=,code=0)
The query fails with the same error.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
