SHOW CREATE CUBE

概要

SHOW CREATE CUBE cube_name

描述

显示创建指定cube的SQL语句。

示例

在orders表上创建cubeorders_cube

CREATE CUBE orders_cube ON orders WITH (AGGREGATIONS = (avg(totalprice), sum(totalprice), count(*)), 
GROUP = (custKEY, ORDERkey), format= 'orc')

运行SHOW CREATE CUBE命令显示用于创建cubeorders_cube的SQL语句：

SHOW CREATE CUBE orders_cube;

CREATE CUBE orders_cube ON orders WITH (AGGREGATIONS = (avg(totalprice), sum(totalprice), count(*)), 
GROUP = (custKEY, ORDERkey), format= 'orc')