云数据仓库的未来趋势：计算存储分离
作者:系统运维 来源:IT科技 浏览: 【大中小】 发布时间:2025-11-05 14:01:51 评论数:
复制select l_returnflag,云数 l_linestatus, sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price, sum(l_extendedprice * (1 - l_discount)) as sum_disc_price, sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge, avg(l_quantity) as avg_qty, avg(l_extendedprice) as avg_price, avg(l_discount) as avg_disc, count(*) as count_order from lineitem where l_shipdate <= date 1998-12-01 - interval 120 day group by l_returnflag, l_linestatus order by l_returnflag, l_linestatus; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.