weihua zhang created IMPALA-14168:
-------------------------------------

             Summary: Calcite Planner: Could not find the Impala function for 
COUNT
                 Key: IMPALA-14168
                 URL: https://issues.apache.org/jira/browse/IMPALA-14168
             Project: IMPALA
          Issue Type: Sub-task
            Reporter: weihua zhang


{code:sql}
CREATE TABLE test_varchar_col(varchar_col VARCHAR(20));
INSERT INTO test_varchar_col values(CAST('grape' AS VARCHAR(20)));
set use_calcite_planner=1;         
SELECT COUNT(DISTINCT varchar_col) FROM test_varchar_col;

2025-06-18 07:40:21 [Exception]  ERROR: Query 7d4d22d4e91e20ea:cbf92e3400000000 
failed:
IllegalStateException: Could not find the Impala function for COUNT


set use_calcite_planner=0;                            
SELECT COUNT(DISTINCT varchar_col) FROM test_varchar_col;
+-----------------------------+
| count(distinct varchar_col) |
+-----------------------------+
| 1                           |
+-----------------------------+
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to