You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/06/16 23:36:04 UTC
[jira] [Resolved] (DRILL-395) ORDER-BY on an expression gives
CannotPlanException
[ https://issues.apache.org/jira/browse/DRILL-395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau resolved DRILL-395.
----------------------------------
Resolution: Fixed
> ORDER-BY on an expression gives CannotPlanException
> ---------------------------------------------------
>
> Key: DRILL-395
> URL: https://issues.apache.org/jira/browse/DRILL-395
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Aman Sinha
> Assignee: DrillCommitter
> Fix For: 1.0.0-BETA1
>
>
> The following query works ok.. it has an expression in the SELECT list and we are doing an ORDER-BY on that expression:
> select N_NATIONKEY + 1 from dfs.`/tmp/parquet/nation.parquet` order by 1;
> However, the following query which puts the same expression in the ORDER-BY clause throws an error:
> select N_NATIONKEY from dfs.`/tmp/parquet/nation.parquet` order by N_NATIONKEY + 1;
> Error 2935dcfa-2b22-45ea-b74f-05d0133a0608: Failure while parsing sql.
> org.eigenbase.relopt.RelOptPlanner$CannotPlanException: Node [rel#431:Subset#3.DRILL.[]] could not be implemented; planner state:
> Root: rel#431:Subset#3.DRILL.[]
> Original rel:
> AbstractConverter(subset=[rel#431:Subset#3.DRILL.[]], convention=[DRILL], sort=[[]]): rowcount = 1.7976931348623157E308, cumulative cost = {inf}, id = 432
> ProjectRel(subset=[rel#430:Subset#3.NONE.PRESERVE], N_NATIONKEY=[$0]): rowcount = 1.7976931348623157E308, cumulative cost = {1.7976931348623157E308 rows, 1.7976931348623157E308 cpu, 0.0 io}, id = 429
> SortRel(subset=[rel#428:Subset#2.NONE.[1 Ascending]], sort0=[$1], dir0=[Ascending]): rowcount = 1.7976931348623157E308, cumulative cost = {Infinity rows, 1.7976931348623157E308 cpu, 0.0 io}, id = 427
> ProjectRel(subset=[rel#426:Subset#1.NONE.[]], N_NATIONKEY=[$0], EXPR$1=[+($0, 1)]): rowcount = 100.0, cumulative cost = {100.0 rows, 200.0 cpu, 0.0 io}, id = 425
--
This message was sent by Atlassian JIRA
(v6.2#6252)