[jira] [Commented] (DRILL-614) simple count on varchar fails

["Chun Chang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14233792#comment-14233792 ] 

Chun Chang commented on DRILL-614:
----------------------------------

verified fix:
#Wed Dec 03 15:18:01 EST 2014
git.commit.id.abbrev=58994af

0: jdbc:drill:schema=dfs.drillTestDirMondrian> select count(c_varchar) from data;
+------------+
|   EXPR$0   |
+------------+
| 23         |
+------------+

> simple count on varchar fails
> -----------------------------
>
>                 Key: DRILL-614
>                 URL: https://issues.apache.org/jira/browse/DRILL-614
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>            Reporter: Chun Chang
>            Assignee: Jacques Nadeau
>            Priority: Minor
>             Fix For: 0.7.0
>
>
> The c_varchar column in table data contains string.
> 0: jdbc:drill:schema=dfs> select count(c_varchar) from data;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "8af0fb93-c65b-4e06-9e7a-84b16f42a99a"
> endpoint {
>   address: "qa-node119.qa.lab"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < RuntimeException:[ cast function for type BIT is not defined ]"
> ]
> Error: exception while executing query (state=,code=0)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)