创建[物化视图]时,使用创建的hive外部表, create materialized view mv_hive1 as select sex,count(*) as cnt from sr_hive group by sex;
说明:sr_hive是starrocks中创建的hive外部表
请问各位大神:执行物化视图刷新时,是把sr_hive表的数据拉到starrocks后然后做分组count吗?还是在hive端分组count后把结果数据写入物化视图?
创建[物化视图]时,使用创建的hive外部表, create materialized view mv_hive1 as select sex,count(*) as cnt from sr_hive group by sex;
说明:sr_hive是starrocks中创建的hive外部表
请问各位大神:执行物化视图刷新时,是把sr_hive表的数据拉到starrocks后然后做分组count吗?还是在hive端分组count后把结果数据写入物化视图?