[
https://issues.apache.org/jira/browse/DRILL-1718?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14213427#comment-14213427
]
Bob Rumsby commented on DRILL-1718:
-----------------------------------
Point taken, but I think this is still a minor bug because of the arcane error
message. I was playing around with an unfamiliar data set and a new function
just as many new Drill users will do. When users are writing and rewriting SQL
based on this kind of exploration, the error messages should help them
understand where they are going wrong. I don't think SQL application developers
will understand what this means: "buffer" is neither a method, a field, nor a
member class of "org.apache.drill.exec.expr.holders.RepeatedVarCharHolder."
> FLATTEN query returns "buffer is neither a method, a field, nor a member
> class..." error
> ----------------------------------------------------------------------------------------
>
> Key: DRILL-1718
> URL: https://issues.apache.org/jira/browse/DRILL-1718
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 0.7.0
> Environment: 0.7.0 snapshot on MacOSX in embedded mode
> Reporter: Bob Rumsby
>
> A query with a FLATTEN function and a WHERE clause constraint on the
> flattened column fails.
> 0: jdbc:drill:zk=local> select name, flatten(categories) as categories from
> dfs.yelp.`yelp_academic_dataset_business.json` where categories='Pizza';
> Query failed: Failure while running fragment., Line 68, Column 95: "buffer"
> is neither a method, a field, nor a member class of
> "org.apache.drill.exec.expr.holders.RepeatedVarCharHolder" [
> 67016271-7266-4438-9529-d8330b1e39a4 on 10.250.0.28:31010 ]
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> 0: jdbc:drill:zk=local> explain plan for select name, flatten(categories) as
> categories from dfs.yelp.`yelp_academic_dataset_business.json` where
> categories='Pizza';
> +------------+------------+
> | text | json |
> +------------+------------+
> | 00-00 Screen
> 00-01 Project(name=[$1], categories=[$2])
> 00-02 Flatten(flattenField=[$2])
> 00-03 Project(EXPR$0=[$0], EXPR$1=[$1], EXPR$2=[$0])
> 00-04 SelectionVectorRemover
> 00-05 Filter(condition=[=($0, 'Pizza')])
> 00-06 Scan(groupscan=[EasyGroupScan
> [selectionRoot=/Users/brumsby/drill/apache-drill-0.7.0-incubating-SNAPSHOT/yelpdata/yelp_academic_dataset_business.json,
> numFiles=1, columns=[`categories`, `name`],
> files=[file:/Users/brumsby/drill/apache-drill-0.7.0-incubating-SNAPSHOT/yelpdata/yelp_academic_dataset_business.json]]])
> | {
> "head" : {
> "version" : 1,
> "generator" : {
> "type" : "ExplainHandler",
> "info" : ""
> },
> "type" : "APACHE_DRILL_PHYSICAL",
> "options" : [ ],
> "queue" : 0,
> "resultMode" : "EXEC"
> },
> "graph" : [ {
> "pop" : "fs-scan",
> "@id" : 6,
> "files" : [
> "file:/Users/brumsby/drill/apache-drill-0.7.0-incubating-SNAPSHOT/yelpdata/yelp_academic_dataset_business.json"
> ],
> "storage" : {
> "type" : "file",
> "enabled" : true,
> "connection" : "file:///",
> "workspaces" : {
> "root" : {
> "location" : "/",
> "writable" : false,
> "defaultInputFormat" : null
> },
> "yelp" : {
> "location" :
> "/Users/brumsby/drill/apache-drill-0.7.0-incubating-SNAPSHOT/yelpdata",
> "writable" : true,
> "defaultInputFormat" : null
> }
> },
> "formats" : {
> "psv" : {
> "type" : "text",
> "extensions" : [ "tbl" ],
> "delimiter" : "|"
> },
> "csv" : {
> "type" : "text",
> "extensions" : [ "csv" ],
> "delimiter" : ","
> },
> "tsv" : {
> "type" : "text",
> "extensions" : [ "tsv" ],
> "delimiter" : "\t"
> },
> "parquet" : {
> "type" : "parquet"
> },
> "json" : {
> "type" : "json"
> }
> }
> },
> "format" : {
> "type" : "json"
> },
> "columns" : [ "`categories`", "`name`" ],
> "selectionRoot" :
> "/Users/brumsby/drill/apache-drill-0.7.0-incubating-SNAPSHOT/yelpdata/yelp_academic_dataset_business.json",
> "cost" : 36382.0
> }, {
> "pop" : "filter",
> "@id" : 5,
> "child" : 6,
> "expr" : "equal(`categories`, 'Pizza') ",
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 5457.3
> }, {
> "pop" : "selection-vector-remover",
> "@id" : 4,
> "child" : 5,
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 5457.3
> }, {
> "pop" : "project",
> "@id" : 3,
> "exprs" : [ {
> "ref" : "`EXPR$0`",
> "expr" : "`categories`"
> }, {
> "ref" : "`EXPR$1`",
> "expr" : "`name`"
> }, {
> "ref" : "`EXPR$2`",
> "expr" : "`categories`"
> } ],
> "child" : 4,
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 5457.3
> }, {
> "pop" : "flatten",
> "@id" : 2,
> "child" : 3,
> "column" : "`EXPR$2`",
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 5457.3
> }, {
> "pop" : "project",
> "@id" : 1,
> "exprs" : [ {
> "ref" : "`name`",
> "expr" : "`EXPR$1`"
> }, {
> "ref" : "`categories`",
> "expr" : "`EXPR$2`"
> } ],
> "child" : 2,
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 5457.3
> }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 5457.3
> } ]
> } |
> +------------+------------+
> 1 row selected (0.115 seconds)
> 0: jdbc:drill:zk=local>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
