drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-395) ORDER-BY on an expression gives CannotPlanException
Date Wed, 05 Mar 2014 22:40:47 GMT
Aman Sinha created DRILL-395:
--------------------------------

             Summary: 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
            Reporter: Aman Sinha


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)

Mime
View raw message