建表语句:
CREATE TABLE `sales_info`(
`sku_id` string COMMENT '商品id',
`sku_name` string COMMENT '商品名称',
`category_id3` string COMMENT '三级分类id',
`price` double COMMENT '销售价格',
`sales_count` bigint COMMENT '销售数量'
)
COMMENT '商品销售信息表'
PARTITIONED BY(
`dt` string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
NULL DEFINED AS ''
STORED AS TEXTFILE
LOCATION
'hdfs://ns1/abc/sales_info'
语句1:
select category_id3,sum(sales_count*price)
from sales_info where dt = '2019-04-26'
group by category_id3
order by sum(sales_count*price)
报错&