安装hive1..21

hive1.2.1
apache-hive-1.2.1-bin.tar.gz
wget http://mirrors.cnnic.cn/apache/hive/hive-1.2.1/apache-hive-1.2.1-bin.tar.gz

tar xzvf apache-hive-1.2.1-bin.tar.gz -C /home/pipstat/yarn/
SET hive.exec.dynamic.partition=true; hive> SET hive.exec.dynamic.partition.mode=nonstrict; hive> SET mapreduce.job.reduces=3; hive> SET hive.exec.reducers.bytes.per.reducer=256000000; hive> SET hive.exec.reducers.max=5; hive> SET hive.optimize.ppd=true; hive> SET hive.optimize.index.filter=true; hive> SET hive.exec.parallel=true; hive> SET hive.exec.parallel.thread.number=4; hive> INSERT OVERWRITE TABLE ads_brand_stats > SELECT > brand, > order_cnt, > total_amount, > avg_amount, > ROW_NUMBER() OVER (ORDER BY total_amount DESC) AS brand_rank, > ROUND(total_amount * 100.0 / total_sum, 2) AS market_share > FROM ( > SELECT > brand, > SUM(order_cnt) AS order_cnt, > ROUND(SUM(total_amount), 2) AS total_amount, > ROUND(AVG(avg_amount), 2) AS avg_amount, > SUM(SUM(total_amount)) OVER () AS total_sum > FROM dws_brand_day > WHERE dt BETWEEN '2025-10-11' AND '2025-11-11' > AND brand IS NOT NULL > GROUP BY brand > ) t; Query ID = root_20251031155406_c5476ff4-b66d-4100-a736-d153dd59f6b0 Total jobs = 4 Launching Job 1 out of 4 Number of reduce tasks not specified. Defaulting to jobconf value of: 3 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapreduce.job.reduces=<number> Starting Job = job_1761893573857_0017, Tracking URL = http://server01:8088/proxy/application_1761893573857_0017/ Kill Command = /opt/server/hadoop-3.2.2/bin/mapred job -kill job_1761893573857_0017 Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 3 2025-10-31 15:54:16,677 Stage-1 map = 0%, reduce = 0% 2025-10-31 15:54:21,897 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 3.88 sec 2025-10-31 15:54:27,057 Stage-1 map = 100%, reduce = 33%, Cumulative CPU 6.15 sec 2025-10-31 15:55:27,172 Stage-1 map = 100%, reduce = 33%, Cumulative CPU 6.15 sec 2025-10-31 15:56:28,091 Stage-1 map = 100%, reduce = 33%, Cumulative CPU 6.15 sec
最新发布
11-01
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值