[jira] [Created] (PHOENIX-970) COUNT function against character column fails with "cast function for type BIT is not defined"

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

Krystal created PHOENIX-970:
-------------------------------

             Summary: 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.2#6252)