li-ang-666 commented on issue #9864:
URL: https://github.com/apache/hudi/issues/9864#issuecomment-1762715740
if i use sql:
**CREATE TABLE dwd_ratio_path_company(
id DECIMAL(20, 0),
company_id BIGINT,
shareholder_id STRING,
shareholder_entity_type SMALLINT,
shareholder_name_id BIGINT,
investment_ratio_total DECIMAL(24, 12),
is_controller SMALLINT,
is_ultimate SMALLINT,
is_big_shareholder SMALLINT,
is_controlling_shareholder SMALLINT,
equity_holding_path STRING,
create_time TIMESTAMP_LTZ(3),
update_time TIMESTAMP_LTZ(3),
is_deleted SMALLINT,
op_ts TIMESTAMP_LTZ(3),
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'hudi',
'path' = 'obs://hadoop-obs/hudi_ods/ratio_path_company016',
'table.type' = 'MERGE_ON_READ',
-- index
'index.type' = 'BUCKET',
'hoodie.bucket.index.num.buckets' = '128',
-- write
'write.tasks' = '4',
'write.task.max.size' = '512',
'write.batch.size' = '8',
'write.log_block.size' = '64',
'write.precombine' = 'true',
'write.precombine.field' = 'op_ts',
-- compaction
'compaction.async.enabled' = 'true',
'compaction.delta_commits' = '2',
-- clean
'clean.retain_commits' = '0',
-- hive
'hive_sync.enabled' = 'true',
'hive_sync.db' = 'hudi_ods',
'hive_sync.table' = 'ratio_path_company016',
'hive_sync.metastore.uris' = 'thrift://10.99.202.153:9083',
'hive_sync.mode' = 'hms',
'hive_sync.support_timestamp' = 'true'
);
insert into dwd_ratio_path_company select * from ods_ratio_path_company;**
it appear:
<img width="784" alt="image"
src="https://github.com/apache/hudi/assets/71430517/084fd0cb-a1fb-46d0-ab7c-abd0ed6e7e15";>
<img width="700" alt="image"
src="https://github.com/apache/hudi/assets/71430517/4cb1c3da-7d00-43c9-96fc-c57e418e14c4";>
--
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]
