技术研发中心
搜索
知识库目录
- 知识库目录
分享知识库
知识库信息
回收站
辽宁自贸试验区（营口片区）桔子数字科技有限公司大数据研发内容数据应用个人空间王玉凯宜口袋-BI集群互通
辽宁自贸试验区（营口片区）桔子数字科技有限公司技术研发中心08-团队空间07-数据技术部大数据研发内容数据应用个人空间王玉凯宜口袋-BI集群互通
已经保存到云端
共有 1 个协作者
+0
0
- 所需表：
- dwd.dwd_beforeloan_order_examine_fd -> dm_ykd.ykd_dwd_beforeloan_order_examine_fd
- dwd.dwd_cap_repay_plan_fd -> dm_ykd.ykd_dwd_cap_repay_plan_fd
- dwd.dwd_beforeloan_auth_examine_fd-> dm_ykd.ykd_dwd_beforeloan_auth_examine_fd
- dwd.dwd_quota_credit_log_fd-> dm_ykd.ykd_dwd_quota_credit_log_fd
- dwd.dwd_inloan_api_to_shop_auth_log_fd-> dm_ykd.ykd_dwd_inloan_api_to_shop_auth_log_fd
- dwd.dwd_beforeloan_admission_rules_id-> dm_ykd.ykd_dwd_beforeloan_admission_rules_id
- dwd.dwd_cap_loan_fd-> dm_ykd.ykd_dwd_cap_loan_fd
- rds.rds_super_plus_plus_order_info-> dm_ykd.ykd_rds_super_plus_plus_order_info
- rds.rds_order_orders_base -> dm_ykd.ykd_rds_order_orders_base
- rds.rds_member_center_auth_order_info -> dm_ykd.ykd_rds_member_center_auth_order_info
- rds.rds_ykd_tong_epocket_register -> dm_ykd.ykd_rds_ykd_tong_epocket_register
- dwd.dwd_beforeloan_model_combine_id -> dm_ykd.ykd_dwd_beforeloan_model_combine_id
- 如下为反欺诈bi所需表
- rds.rds_qk_inloan_return_visit_channel_info -> dm_ykd.ykd_rds_qk_inloan_return_visit_channel_info
- rds.rds_qk_inloan_call_record_id -> dm_ykd.ykd_rds_qk_inloan_call_record_id
- rds.rds_qk_inloan_remind_ivr_info -> dm_ykd.ykd_rds_qk_inloan_remind_ivr_info
- rds.rds_rms_inloan_nephele_in_loan_customer_level -> dm_ykd.ykd_rds_rms_inloan_nephele_in_loan_customer_level
- rds.rds_rms_order_orders_id-> dm_ykd.ykd_rds_rms_order_orders_id
- rds.rds_qk_inloan_channel_setting -> dm_ykd.ykd_rds_qk_inloan_channel_setting
- rds.rds_qk_inloan_channel_setting_fail_code-> dm_ykd.ykd_rds_qk_inloan_channel_setting_fail_code
- 脚本：
- ykd2sk.sh
- sync_list.sh
- crontab
- 同步命令：
输入“/”快速插入内容
添加图标
添加封面
集群互通
集群互通
王玉凯今天修改
`level_score` string COMMENT '评定所用的分数',
`level_source` int COMMENT '客户来源 ： 1:新客一部 2:新客二部大复贷 3:新客二部新客 4:存量优质 5:存量复贷 6:存量API转商城',
`level_judge_way` int COMMENT '客户等级评定标签： 1:贷中规则 2: 贷中融合分 3:贷中评分卡1.0 4:贷前1.0评分卡 5:贷前0.5评分卡及TD反欺诈分 6:贷中新客 7:贷中大复贷',
`level_judge_params` string COMMENT '等级评定决策参数 json存储',
`push_status` int COMMENT '0:失败 1:成功',
`create_time` string COMMENT '创建时间',
`update_time` string COMMENT '修改时间')
COMMENT '客户等级评定记录表'
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
'field.delim'='',
'serialization.format'='',
'serialization.null.format'='NULL')
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat';
rds.rds_rms_order_orders_id-> dm_ykd.ykd_rds_rms_order_orders_id
CREATE TABLE `dm_ykd.ykd_rds_rms_order_orders_id`(
`_hoodie_commit_time` string,
`_hoodie_commit_seqno` string,
`_hoodie_record_key` string,
`_hoodie_partition_path` string,
`_hoodie_file_name` string,
`id` string,
`table_name` string,
`order_no` string,
`status` int,
`pushed` int,
`request_decision_no` string,
`init_param` string,
`customer_id` string,
`post_content` string,
`name` string,
`channel_id` string,
`channel_name` string,
`id_card` string,
`phone` string,
`operate_type` int,
`request_decision_param` string,
`request_decision_time` string,
`request_manual_param` string,
`manual_result` string,
`decision_result` string,
`scene_no` string,
`scene_name` string,
`create_time` string,
`update_time` string,
`artificial_flag` int,
`manual_pushed` int,
`store_flag` int,
`branch_info` string,
`indirect_user` string,
`indirect_flag` string,
`hulian_flag` string,
`review_team` string,
`first_result` int,
`first_team` string,
`first_review_time` string,
`second_result` int,
`second_team` string,
评论（0）
跳转至首条评论
本文暂未被其它文档引用
本文暂未引用其它文档
真诚点赞，手留余香
0 字
- 上传日志
- 联系客服
- 功能更新
- 帮助中心
- 效率指南