[jira] [Updated] (DRILL-1049) Few types are not handled in ExpressionStringBuilder and ExpressionTreeMaterializer.castEqual

["Venki Korukanti (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Venki Korukanti updated DRILL-1049:
-----------------------------------

    Attachment: DRILL-1049-1.patch.txt

> Few types are not handled in ExpressionStringBuilder and ExpressionTreeMaterializer.castEqual
> ---------------------------------------------------------------------------------------------
>
>                 Key: DRILL-1049
>                 URL: https://issues.apache.org/jira/browse/DRILL-1049
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Venki Korukanti
>            Assignee: Venki Korukanti
>         Attachments: DRILL-1049-1.patch.txt
>
>
> Causing few queries to fail. An example query plan that fails:
> {code}
> Drill Plan : 
> {
>   "head" : {
>     "version" : 1,
>     "generator" : {
>       "type" : "DefaultSqlHandler",
>       "info" : ""
>     },
>     "type" : "APACHE_DRILL_PHYSICAL",
>     "options" : [ ],
>     "queue" : 0,
>     "resultMode" : "EXEC"
>   },
>   "graph" : [ {
>     "pop" : "hive-scan",
>     "@id" : 3,
>     "hive-table" : {
>       "table" : {
>         "tableName" : "voter_hive",
>         "dbName" : "default",
>         "owner" : "hadoop",
>         "createTime" : 1403280039,
>         "lastAccessTime" : 0,
>         "retention" : 0,
>         "sd" : {
>           "cols" : [ {
>             "name" : "voter_id",
>             "type" : "int",
>             "comment" : null
>           }, {
>             "name" : "name",
>             "type" : "string",
>             "comment" : null
>           }, {
>             "name" : "age",
>             "type" : "tinyint",
>             "comment" : null
>           }, {
>             "name" : "registration",
>             "type" : "string",
>             "comment" : null
>           }, {
>             "name" : "contributions",
>             "type" : "float",
>             "comment" : null
>           }, {
>             "name" : "voterzone",
>             "type" : "smallint",
>             "comment" : null
>           }, {
>             "name" : "create_time",
>             "type" : "timestamp",
>             "comment" : null
>           } ],
>           "location" : "file:/tmp/apachehive12_wh/voter_hive",
>           "inputFormat" : "org.apache.hadoop.mapred.TextInputFormat",
>           "outputFormat" : "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
>           "compressed" : false,
>           "numBuckets" : -1,
>           "serDeInfo" : {
>             "name" : null,
>             "serializationLib" : "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
>             "parameters" : {
>               "serialization.format" : "\t",
>               "field.delim" : "\t"
>             }
>           },
>           "sortCols" : [ ],
>           "parameters" : { }
>         },
>         "partitionKeys" : [ ],
>         "parameters" : {
>           "numPartitions" : "0",
>           "numFiles" : "1",
>           "transient_lastDdlTime" : "1403280064",
>           "totalSize" : "63118",
>           "numRows" : "0",
>           "rawDataSize" : "0"
>         },
>         "viewOriginalText" : null,
>         "viewExpandedText" : null,
>         "tableType" : "MANAGED_TABLE"
>       },
>       "partitions" : null
>     },
>     "storage-plugin" : "hive",
>     "cost" : 61.0
>   }, {
>     "pop" : "project",
>     "@id" : 2,
>     "exprs" : [ {
>       "ref" : "`voter_id`",
>       "expr" : "cast( (`voter_id` ) as INT )"
>     }, {
>       "ref" : "`name`",
>       "expr" : "cast( (`name` ) as VARCHAR(65535) )"
>     }, {
>       "ref" : "`age`",
>       "expr" : "cast( (`age` ) as TINYINT )"
>     }, {
>       "ref" : "`registration`",
>       "expr" : "cast( (`registration` ) as VARCHAR(65535) )"
>     }, {
>       "ref" : "`contributions`",
>       "expr" : "cast( (`contributions` ) as FLOAT4 )"
>     }, {
>       "ref" : "`voterzone`",
>       "expr" : "cast( (`voterzone` ) as SMALLINT )"
>     }, {
>       "ref" : "`create_time`",
>       "expr" : "cast( (`create_time` ) as TIMESTAMP )"
>     } ],
>     "child" : 3,
>     "initialAllocation" : 1000000,
>     "maxAllocation" : 10000000000,
>     "cost" : 61.0
>   }, {
>     "pop" : "project",
>     "@id" : 1,
>     "exprs" : [ {
>       "ref" : "`voter_id`",
>       "expr" : "`voter_id`"
>     }, {
>       "ref" : "`name`",
>       "expr" : "`name`"
>     }, {
>       "ref" : "`age`",
>       "expr" : "`age`"
>     }, {
>       "ref" : "`registration`",
>       "expr" : "`registration`"
>     }, {
>       "ref" : "`contributions`",
>       "expr" : "`contributions`"
>     }, {
>       "ref" : "`voterzone`",
>       "expr" : "`voterzone`"
>     }, {
>       "ref" : "`create_time`",
>       "expr" : "`create_time`"
>     } ],
>     "child" : 2,
>     "initialAllocation" : 1000000,
>     "maxAllocation" : 10000000000,
>     "cost" : 61.0
>   }, {
>     "pop" : "screen",
>     "@id" : 0,
>     "child" : 1,
>     "initialAllocation" : 1000000,
>     "maxAllocation" : 10000000000,
>     "cost" : 61.0
>   } ]
> }
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)