在hive中验证count(*) over(partition by) 和 count(字段) over(partition by) 在字段存在空的情况下结果是没有区别的,oracle中,结果是不同的
drop table t_ddt_ods_analytic_tmp1;
CREATE TABLE t_ddt_ods_analytic_tmp1 (
cust_no STRING,
company STRING,
prod_type STRING,
cust_level STRING
)
COMMENT '分析函数测试'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\001'
LOCATION '/RESULT/O_xxx/wlh/t_ddt_ods_analytic_tmp1';
insert into table t_ddt_ods_analytic_tmp1
SELECT cust_no,
company,
prod_type,
cust_level
FROM zkw_tmp_sales_all
where cust_no is not null limit 10;
hive> desc t_ddt_ods_analytic_tmp1;
OK
cust_no string
company string
prod_type string
cust_level string
hive> select * from t_ddt_ods_analytic_tmp1;