他的回复:
回复:劉 发表于 2021-4-7 16:42 能否提供一下建表语句和使用的FusionInsight版本,目前carbondata暂时不支持对int类型和bigint类型创建二级索引,如果需要对int类型或CREATE TABLE tpcds_carbondata.catalog_returns( cr_returned_time_sk bigint, cr_item_sk bigint, cr_refunded_customer_sk bigint, cr_refunded_cdemo_sk bigint, cr_refunded_hdemo_sk bigint, cr_refunded_addr_sk bigint, cr_returning_customer_sk bigint, cr_returning_cdemo_sk bigint, cr_returning_hdemo_sk bigint, cr_returning_addr_sk bigint, cr_call_center_sk bigint, cr_catalog_page_sk bigint, cr_ship_mode_sk bigint, cr_warehouse_sk bigint, cr_reason_sk bigint, cr_order_number bigint, cr_return_quantity int, cr_return_amount decimal(7,2), cr_return_tax decimal(7,2), cr_return_amt_inc_tax decimal(7,2), cr_fee decimal(7,2), cr_return_ship_cost decimal(7,2), cr_refunded_cash decimal(7,2), cr_reversed_charge decimal(7,2), cr_store_credit decimal(7,2), cr_net_loss decimal(7,2)) PARTITIONED BY (cr_returned_date_sk bigint) STORED AS CARBONDATA TBLPROPERTIES ('table_blocksize'='128');ALTER TABLE catalog_returns SET TBLPROPERTIES('SORT_COLUMNS'='cr_returned_date_sk,cr_order_number,cr_item_sk,cr_returned_time_sk');Fusioninsight版本为8.0.2