需求：hivesql中有一列动态查询数量实现： SELECT (select count(*) as cnt from dept) as num, id, name from users; 报错：Error while compi

hive 测试数据CREATE TABLE users(id int,name string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'; CREATE TABLE dept(id i