drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yash Sharma <yash...@gmail.com>
Subject Issue in running LogicalPlan generated by drill
Date Mon, 13 Oct 2014 06:44:15 GMT
Hi Folks,
I am trying to run a LogicalPlan (generated by Drill) on the Web Interface.
I face this below error. Same query works directly on Sqlline.

Any Tips what might be wrong ?

Thanks

Error on executing logical plan on web console:
Query failed: Failure while parsing logical plan. Argument #0 of
constructor [constructor for org.apache.drill.common.logical.data.Join,
annotations: [null]] has no property name annotation; must have name when
multiple-paramater constructor annotated as Creator
[64eb4dc2-dd1d-456a-a820-2b1c68050b5e]


Query:
explain plan without implementation for(select c.c_custkey, c.c_name,
c.c_address, c.c_nationkey,  n.n_name, n.n_comment from
cp.`tpch/customer.parquet` c FULL OUTER JOIN cp.`tpch/nation.parquet` n ON
(c.c_nationkey = n.n_nationkey) limit 10) ;


Logical Plan Generated:
{
  "head" : {
    "version" : 1,
    "generator" : {
      "type" : "org.apache.drill.exec.planner.logical.DrillImplementor",
      "info" : ""
    },
    "type" : "APACHE_DRILL_LOGICAL",
    "options" : null,
    "queue" : 0,
    "resultMode" : "LOGICAL"
  },
  "storage" : {
    "cp" : {
      "type" : "file",
      "enabled" : true,
      "connection" : "classpath:///",
      "workspaces" : null,
      "formats" : {
        "csv" : {
          "type" : "text",
          "extensions" : [ "csv" ],
          "delimiter" : ","
        },
        "json" : {
          "type" : "json"
        },
        "parquet" : {
          "type" : "parquet"
        }
      }
    }
  },
  "query" : [ {
    "op" : "scan",
    "@id" : 1,
    "storageengine" : "cp",
    "selection" : {
      "format" : {
        "type" : "named",
        "name" : "parquet"
      },
      "files" : [ "/tpch/customer.parquet" ]
    }
  }, {
    "op" : "project",
    "@id" : 2,
    "input" : 1,
    "projections" : [ {
      "ref" : "`c_nationkey`",
      "expr" : "`c_nationkey`"
    }, {
      "ref" : "`c_custkey`",
      "expr" : "`c_custkey`"
    }, {
      "ref" : "`c_name`",
      "expr" : "`c_name`"
    }, {
      "ref" : "`c_address`",
      "expr" : "`c_address`"
    } ]
  }, {
    "op" : "scan",
    "@id" : 3,
    "storageengine" : "cp",
    "selection" : {
      "format" : {
        "type" : "named",
        "name" : "parquet"
      },
      "files" : [ "/tpch/nation.parquet" ]
    }
  }, {
    "op" : "project",
    "@id" : 4,
    "input" : 3,
    "projections" : [ {
      "ref" : "`n_nationkey`",
      "expr" : "`n_nationkey`"
    }, {
      "ref" : "`n_name`",
      "expr" : "`n_name`"
    }, {
      "ref" : "`n_comment`",
      "expr" : "`n_comment`"
    } ]
  }, {
    "op" : "join",
    "@id" : 5,
    "right" : 4,
    "left" : 2,
    "conditions" : [ {
      "relationship" : "==",
      "left" : "`c_nationkey`",
      "right" : "`n_nationkey`"
    } ],
    "type" : "FULL"
  }, {
    "op" : "project",
    "@id" : 6,
    "input" : 5,
    "projections" : [ {
      "ref" : "`c_custkey`",
      "expr" : "`c_custkey`"
    }, {
      "ref" : "`c_name`",
      "expr" : "`c_name`"
    }, {
      "ref" : "`c_address`",
      "expr" : "`c_address`"
    }, {
      "ref" : "`c_nationkey`",
      "expr" : "`c_nationkey`"
    }, {
      "ref" : "`n_name`",
      "expr" : "`n_name`"
    }, {
      "ref" : "`n_comment`",
      "expr" : "`n_comment`"
    } ]
  }, {
    "op" : "limit",
    "@id" : 7,
    "input" : 6,
    "first" : 0,
    "last" : 10
  }, {
    "op" : "store",
    "@id" : 8,
    "input" : 7,
    "target" : null,
    "storageEngine" : "--SCREEN--"
  } ]
}

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message