浙江大学关于大数据的操作讲解

方体的操作 DMQL中的方体定义和计算 define cube sales[item, city, year]: sum(sales_in_dollars) compute cube sales 上述的compute cube子句可以转化为一个类似于SQL的语句 SELECT item, city, year, SUM (amount) FROM SALES CUBE BY item, city, year 需要计算以下的group by子句 (item, city, year) (item, city), (item year), (city, year) (item), (city), (year) () (item) (city) () (year) (city, item) (city, year) (item, year) (city, item, year)