Steve Carlin created HIVE-26676:
-----------------------------------
Summary: Count distinct in subquery returning wrong results
Key: HIVE-26676
URL: https://issues.apache.org/jira/browse/HIVE-26676
Project: Hive
Issue Type: Bug
Components: HiveServer2
Reporter: Steve Carlin
The following select query should return 1 row
{code:java}
CREATE TABLE t_test(
a tinyint
);
INSERT INTO t_test VALUES
(0), (1), (2), (3), (4), (5), (6), (7), (8), (9);
select 1 from (select count(distinct a) from t_test) x;
{code}
But it's returning 10 rows
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
