CREATE MATERIALIZED TABLE catalog_jp.dwd.tb_agrt_policy_curr_dim_materialized4
( `policy_id` STRING,
source_policy_id STRING,
main_policy_owner_id STRING,
source_main_policy_owner_id STRING,
unified_main_policy_owner_id STRING,
joint_policy_owner_id STRING,
source_joint_policy_owner_id STRING,
unified_joint_policy_owner_id STRING,
channel_id STRING,
source_channel_id STRING,
servicing_agent_id STRING,
source_servicing_agent_id STRING,
agency_code STRING,
agency_registration_number STRING,
bank_agent_id STRING,
source_bank_agent_id STRING,
company_code STRING,
dispatch_address_country_code STRING,
dispatch_address_province_code STRING,
dispatch_address_postcode STRING,
dispatch_address_line_1 STRING,
dispatch_address_line_2 STRING,
dispatch_address_line_3 STRING,
dispatch_address_line_4 STRING,
dispatch_address_line_5 STRING,
policy_type_code STRING,
policy_status_code STRING,
policy_sub_status_code STRING,
policy_status_date DATE,
submit_date DATE,
issue_date DATE,
policy_effective_date DATE,
policy_end_date DATE,
inforce_date DATE,
lapse_date DATE,
reinstatement_date DATE,
surrender_date DATE,
termination_date DATE,
premium_status STRING,
premium_status_date DATE,
premium_start_date DATE,
premium_end_date DATE,
bill_to_date DATE,
paid_to_date DATE,
sum_assured DECIMAL(24, 4),
modal_premium DECIMAL(24, 4),
currency_code STRING,
billing_method_code STRING,
billing_frequency_code STRING,
billing_type STRING,
last_billing_date DATE,
payor_id STRING,
source_payor_id STRING,
unified_payor_id STRING,
standard_indicator STRING,
next_premium_amt DECIMAL(24, 4),
surrender_value DECIMAL(24, 4),
outstanding_balance DECIMAL(24, 4),
suspense_amt DECIMAL(24, 4),
first_issue_date DATE,
pledge_flag STRING,
bonus_premium DECIMAL(24, 4),
base_assured DECIMAL(24, 4),
final_assured DECIMAL(24, 4),
special_contract_type_code STRING,
special_contract_type_name STRING,
spouse_death_flag STRING,
living_needs_rider_indicator STRING,
specified_agent_claimant_rider_indicator STRING,
automated_loan_indicator STRING,
liability_start_date_specified_indicator STRING,
joint_solicitation_flag STRING,
corperate_policy_indicator STRING,
ape DECIMAL(24, 4),
grace_period_due_date DATE,
guarantee_period DECIMAL(5, 0),
guarantee_payment_amt DECIMAL(24, 4),
reserve_amt DECIMAL(24, 4),
saving_reserve_amt DECIMAL(24, 4),
general_reserve_amt DECIMAL(24, 4),
reserve_interest_rate DECIMAL(24, 4),
reserve_amt_calculation_date DATE,
death_benefit_amt DECIMAL(24, 4),
investment_perf_linked_indicator STRING,
fixed_life_transfer_indicator STRING,
annuity_payment_start_date DATE,
etl_valid_start_time TIMESTAMP(6),
etl_valid_end_time TIMESTAMP(6),
etl_is_current_flag STRING,
etl_create_time TIMESTAMP(6),
etl_create_by STRING,
etl_update_time TIMESTAMP(6),
etl_update_by STRING,
etl_source_system_record_time TIMESTAMP(6),
etl_source_bu STRING,
etl_source_system STRING,
etl_source_table STRING,
data_arrival_time TIMESTAMP(6),
dwd_data_arrival_time TIMESTAMP(6),
PRIMARY KEY (`policy_id`) NOT ENFORCED
)一样的报错
最新发布