You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2015/02/10 21:27:12 UTC
[jira] [Resolved] (PHOENIX-970) COUNT function against character
column fails with "cast function for type BIT is not defined"
[ https://issues.apache.org/jira/browse/PHOENIX-970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor resolved PHOENIX-970.
----------------------------------
Resolution: Cannot Reproduce
No activity, so closing. Please reopen if problem persists.
> COUNT function against character column fails with "cast function for type BIT is not defined"
> ----------------------------------------------------------------------------------------------
>
> Key: PHOENIX-970
> URL: https://issues.apache.org/jira/browse/PHOENIX-970
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 1.0
> Reporter: Krystal
>
> The following query failed:
> select count(distinct(name)) from voter;
> 2014-05-05 14:59:18 INFO DrillTestBase:191 - Query dispatch start time: 2014/05/05 14:59:18.0018
> java.sql.SQLException: exception while executing query
> at net.hydromatic.avatica.Helper.createException(Helper.java:40)
> at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:406)
> at net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:350)
> at net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:78)
> at org.apache.drill.test.framework.GenericQueryDispatcher.dispatchQueryJDBC(GenericQueryDispatcher.java:89)
> at org.apache.drill.test.framework.DrillTestBase$RunThread.run(DrillTestBase.java:257)
> Caused by: java.sql.SQLException: Failure while trying to get next result batch.
> at org.apache.drill.jdbc.DrillCursor.next(DrillCursor.java:101)
> at org.apache.drill.jdbc.DrillResultSet.execute(DrillResultSet.java:89)
> at org.apache.drill.jdbc.DrillResultSet.execute(DrillResultSet.java:43)
> at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
> ... 4 more
> Explicitly cast the "name" column to a varchar (select count(distinct(cast(name as varchar(25)))) from voter;) gave the same error.
> Also, casting an integer column to a varchar with count resulted in the same error:
> select count(cast(age as varchar(5))) from student;
> Failure while running fragment. < RuntimeException:[ cast function for type BIT is not defined
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)