COUNT
Descriptionβ
Returns the number of non-NULL records for the specified column, or the total number of records.
Syntaxβ
COUNT(DISTINCT <expr> [,<expr>,...])
COUNT(*)
COUNT(<expr>)
Parametersβ
Parameter | Description |
---|---|
<expr> | If an expression is specified, counts the number of non-NULL records; otherwise, counts the total number of rows. |
Return Valueβ
The return type is Bigint. If expr is NULL, it is not counted.
Exampleβ
-- setup
create table test_count(
id int,
name varchar(20),
sex int
) distributed by hash(id) buckets 1
properties ("replication_num"="1");
insert into test_count values
(1, '1', 1),
(2, '2', 1),
(3, '3', 1),
(4, '0', 1),
(4, '4', 1),
(5, NULL, 1);
create table test_insert(
id int,
name varchar(20),
sex int
) distributed by hash(id) buckets 1
properties ("replication_num"="1");
insert into test_insert values
(1, '1', 1),
(2, '2', 1),
(3, '3', 1),
(4, '0', 1),
(4, '4', 1),
(5, NULL, 1);
select count(*) from test_count;
+----------+
| count(*) |
+----------+
| 6 |
+----------+
select count(name) from test_insert;
+-------------+
| count(name) |
+-------------+
| 5 |
+-------------+
select count(distinct sex) from test_insert;
+---------------------+
| count(DISTINCT sex) |
+---------------------+
| 1 |
+---------------------+
select count(distinct id,sex) from test_insert;
+-------------------------+
| count(DISTINCT id, sex) |
+-------------------------+
| 5 |
+-------------------------+