li-ang-666 commented on issue #9828:
URL: https://github.com/apache/hudi/issues/9828#issuecomment-1751573818
the mysql table is:
CREATE TABLE `ratio_path_company` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
`company_id` bigint NOT NULL DEFAULT '0' COMMENT '公司id',
`shareholder_id` varchar(120) NOT NULL DEFAULT '' COMMENT
'股东id,人存human-pid,公司存储company_id',
`shareholder_entity_type` smallint NOT NULL DEFAULT '0' COMMENT
'1-company,2-human,3-abnormal entity',
`shareholder_name_id` bigint NOT NULL DEFAULT '0' COMMENT '股东的gid',
`investment_ratio_total` decimal(24,12) NOT NULL DEFAULT '0.000000000000'
COMMENT '投资总比例',
`is_controller` smallint NOT NULL DEFAULT '0' COMMENT '1-controller, 0-not
controller 2-控制权',
`is_ultimate` smallint NOT NULL DEFAULT '0' COMMENT '1-ultimate, 0-not
ultimate',
`is_big_shareholder` smallint NOT NULL DEFAULT '0' COMMENT '1-is
big_shareholder, 0-not big_shareholder',
`is_controlling_shareholder` smallint NOT NULL DEFAULT '0' COMMENT '1-is
controlling_shareholder, 0-not controlling_shareholder',
`equity_holding_path` longtext COMMENT '持股路径',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT
'create_time',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP COMMENT 'update_time',
`is_deleted` smallint NOT NULL DEFAULT '0' COMMENT '1-deleted, 0-not
deleted',
PRIMARY KEY (`id`),
KEY `idx_company_controller` (`company_id`,`is_controller`),
KEY `idx_company_id_shareholder_id` (`company_id`,`shareholder_id`),
KEY `idx_company_ultimate` (`company_id`,`is_ultimate`),
KEY `idx_shardholder_graph`
(`shareholder_name_id`,`shareholder_entity_type`),
KEY `idx_shardholder_percent`
(`shareholder_id`,`shareholder_entity_type`,`investment_ratio_total`),
KEY `idx_shareholder_company` (`shareholder_id`,`company_id`),
KEY `idx_shareholder_controller` (`shareholder_id`,`is_controller`),
KEY `idx_shareholder_ultimate` (`shareholder_id`,`is_ultimate`)
) ENGINE=InnoDB
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
