示例代码
SHOW CATALOGS;SELECT current_catalog;CREATE SCHEMA IF NOT EXISTS hive.wedata_demo_db;-- 创建一个用户信息表create table if not exists hive.wedata_demo_db.user_info (user_id string COMMENT '用户ID',user_name string COMMENT '用户名称',user_age int COMMENT '年龄',city string COMMENT '城市') COMMENT '用户信息表';-- 向用户信息表中插入数据insert into hive.wedata_demo_db.user_info values ('001', '张三', 28, 'beijing');insert into hive.wedata_demo_db.user_info values ('002', '李四', 35, 'shanghai');insert into hive.wedata_demo_db.user_info values ('003', '王五', 22, 'shenzhen');insert into hive.wedata_demo_db.user_info values ('004', '赵六', 45, 'guangzhou');insert into hive.wedata_demo_db.user_info values ('005', '小明', 20, 'beijing');insert into hive.wedata_demo_db.user_info values ('006', '小红', 30, 'shanghai');insert into hive.wedata_demo_db.user_info values ('007', '小刚', 25, 'shenzhen');insert into hive.wedata_demo_db.user_info values ('008', '小李', 40, 'guangzhou');insert into hive.wedata_demo_db.user_info values ('009', '小张', 23, 'beijing');insert into hive.wedata_demo_db.user_info values ('010', '小王', 50, 'shanghai');-- 查询数据select * from hive.wedata_demo_db.user_info;