drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-614) simple count on varchar fails
Date Fri, 23 May 2014 23:38:02 GMT

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

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

As of this build, this has not been fixed:

#Fri May 23 08:42:45 PDT 2014
git.commit.id.abbrev=f948d71

In addition, a simple count(int) gives wrong result, count(distinct(int)) gives correct results:

0: jdbc:drill:schema=dfs> select count(c_row) from data;
+------------+
|   EXPR$0   |
+------------+
| 0          |
+------------+
1 row selected (0.076 seconds)
0: jdbc:drill:schema=dfs> select count(distinct(c_row)) 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
>            Reporter: Chun Chang
>
> 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.2#6252)

Mime
View raw message