012-Hive爱之初体验

create database if not exists test;

use test;

create table if not exists test
(
    user_id  int,
    username string not null,
    password string not null
);

insert into test (user_id, username, password) values (1, '孙悟空', '111111');
insert into test values (2, '赵子龙', '999999'), (3, '鲁智深', '888888'), (4, '贾宝玉', '666666');

select * as count from test;
select count(*) as count from test group by username;