You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Paul Rogers (JIRA)" <ji...@apache.org> on 2017/03/17 21:46:41 UTC
[jira] [Updated] (DRILL-5364) Invalid
[ https://issues.apache.org/jira/browse/DRILL-5364?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Rogers updated DRILL-5364:
-------------------------------
Summary: Invalid (was: Planner inserts sort for simple constant value query)
> Invalid
> -------
>
> Key: DRILL-5364
> URL: https://issues.apache.org/jira/browse/DRILL-5364
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.10.0
> Reporter: Paul Rogers
> Priority: Minor
>
> Consider the following query:
> {code}
> SELECT CURRENT_TIMESTAMP FROM (VALUES(1))
> {code}
> The following is the plan generated for the query. Notice the inclusion of an unnecessary sort.
> {code}
> "graph" : [ {
> "pop" : "Values",
> "@id" : 4,
> "content" : [ {
> "EXPR$0" : {
> "$numberLong" : 1
> }
> } ],
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 1.0
> }, {
> "pop" : "project",
> "@id" : 3,
> "exprs" : [ {
> "ref" : "`CURRENT_TIMESTAMP`",
> "expr" : "current_timestamp() "
> } ],
> "child" : 4,
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 1.0
> }, {
> "pop" : "external-sort",
> "@id" : 2,
> "child" : 3,
> "orderings" : [ {
> "order" : "ASC",
> "expr" : "`CURRENT_TIMESTAMP`",
> "nullDirection" : "UNSPECIFIED"
> } ],
> "reverse" : false,
> "initialAllocation" : 20000000,
> "maxAllocation" : 10000000000,
> "cost" : 1.0
> }, {
> "pop" : "selection-vector-remover",
> "@id" : 1,
> "child" : 2,
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 1.0
> }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 1.0
> } ]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)