结果验证

参考创建Starrocks数据库和表通过ECS上安装的mysql客户端登录到StarRocks，执行如下sql：

select * from ods_orders;
select * from mv_dwd_order_detail;
select * from mv_dws_channel_summary;
SELECT
    stat_date AS 统计日期,
    total_orders AS 总订单数,
    total_amount AS 总消费金额,
    online_orders AS 线上订单数量,
    offline_orders AS 线下订单数量,
    online_amount AS 线上消费金额,
    offline_amount AS 线下消费金额
FROM mv_ads_sales_dashboard;

以ADS层销售渠道统计实时看板视图为例：