-
luofei369 初学数据Lv2
发表于2021-4-8 10:50
悬赏5
已解决
楼主
我配置了两个维表 两个配置基本上一模一样 唯一的区别就是一个维表数据多一点 一个少一些
然后主题表各有2个字段绑定不同的维表 但是数据多的那个维表 就无法自动翻译出来,我把SQL拉出来看了一下 SQL里有关联维表 但是结果里还是数字 不晓得是为什么
SELECT
*
FROM
(SELECT
a.vendor_id AS B3,
a.account_name AS D3,
a.contract_code AS E3,
a.inquiry_type AS F3,
b.fee_project_name AS G3,
a.is_standard_contract_text AS H3,
a.container_type AS I3,
a.goods_name AS J3,
a.service_type AS K3,
a.start_place AS N3,
a.end_place AS O3,
a.job_place_name AS P3,
a.total_distance AS Q3,
a.base_price AS R3,
a.price_unit AS S3,
a.settlement_method AS T3,
a.payment_method AS U3,
a.payment_type AS V3,
a.bond AS W3,
a.start_period AS X3,
a.end_period AS Y3,
b.tax_rate AS Z3,
a.remark AS AA3,
a.created_at AS AB3,
a.created_by AS AC3,
c.firm_name AS AD3,
a.sender_name AS AE3,
a.recipient_name AS AF3,
a.courier_type AS AG3,
a.sender_at AS AH3,
d.id AS AI3,
a.courier_number AS AJ3,
a.recycle_name AS AK3,
a.recycle_at AS AL3,
a.recycle_type AS AM3,
e.id AS AN3,
a.recycle_number AS AO3,
a.is_scan_upload AS AP3,
a.is_courier_invalid AS AQ3,
a.is_more_than_recycled AS AR3,
a.organization_name AS C3,
f.cv_name AS mc_B30,
d.express_name AS mc_AI330,
e.express_name AS mc_AN335
FROM
ESISVEND_CONT1 a
LEFT JOIN ESISUSER_FIRM c
ON (a.CREATED_ID = c.ID)
LEFT JOIN ESISBASE_FEE_PROJECT_INFO b
ON (a.FEE_ITEM = b.ID)
LEFT JOIN express_company_info d
ON (
a.courier_express_code = d.express_code
)
LEFT JOIN express_company_info e
ON (
a.recycle_express_code = e.express_code
)
LEFT JOIN base_cv_info f
ON (a.vendor_id = f.id)) AS temp_
LIMIT 1000
红色字体就是关联维表的SQL,我看计算逻辑里是有的,但是最终结果不出来
然后主题表各有2个字段绑定不同的维表 但是数据多的那个维表 就无法自动翻译出来,我把SQL拉出来看了一下 SQL里有关联维表 但是结果里还是数字 不晓得是为什么
SELECT
*
FROM
(SELECT
a.vendor_id AS B3,
a.account_name AS D3,
a.contract_code AS E3,
a.inquiry_type AS F3,
b.fee_project_name AS G3,
a.is_standard_contract_text AS H3,
a.container_type AS I3,
a.goods_name AS J3,
a.service_type AS K3,
a.start_place AS N3,
a.end_place AS O3,
a.job_place_name AS P3,
a.total_distance AS Q3,
a.base_price AS R3,
a.price_unit AS S3,
a.settlement_method AS T3,
a.payment_method AS U3,
a.payment_type AS V3,
a.bond AS W3,
a.start_period AS X3,
a.end_period AS Y3,
b.tax_rate AS Z3,
a.remark AS AA3,
a.created_at AS AB3,
a.created_by AS AC3,
c.firm_name AS AD3,
a.sender_name AS AE3,
a.recipient_name AS AF3,
a.courier_type AS AG3,
a.sender_at AS AH3,
d.id AS AI3,
a.courier_number AS AJ3,
a.recycle_name AS AK3,
a.recycle_at AS AL3,
a.recycle_type AS AM3,
e.id AS AN3,
a.recycle_number AS AO3,
a.is_scan_upload AS AP3,
a.is_courier_invalid AS AQ3,
a.is_more_than_recycled AS AR3,
a.organization_name AS C3,
f.cv_name AS mc_B30,
d.express_name AS mc_AI330,
e.express_name AS mc_AN335
FROM
ESISVEND_CONT1 a
LEFT JOIN ESISUSER_FIRM c
ON (a.CREATED_ID = c.ID)
LEFT JOIN ESISBASE_FEE_PROJECT_INFO b
ON (a.FEE_ITEM = b.ID)
LEFT JOIN express_company_info d
ON (
a.courier_express_code = d.express_code
)
LEFT JOIN express_company_info e
ON (
a.recycle_express_code = e.express_code
)
LEFT JOIN base_cv_info f
ON (a.vendor_id = f.id)) AS temp_
LIMIT 1000
红色字体就是关联维表的SQL,我看计算逻辑里是有的,但是最终结果不出来
最佳答案
luofei369 发表于 2021-4-8 11:29
维表自动翻译好像有问题?还是我配置问题?
问题同帖子https://bbs.esensoft.com/thread-139624-1-1.html最佳答案
6个回答
大的维表里有 2000+数据 小的维表是1000+数据 小维表可以自动翻译出来 ,大维表不行...
xxxl 发表于 2021-4-8 10:58
大维表的结构设置看看
维表自动翻译好像有问题?还是我配置问题?
左边是自动翻译的 右边是我查询的实际的正确数据
SELECT
*
FROM
(SELECT
a.customer_name AS C3,
a.customer_id AS B3,
b.cv_name AS mc_B30
FROM
ESISCONT_SALE_CONT a
LEFT JOIN base_cv_info b
ON (a.customer_id = b.id)) AS temp_
LIMIT 1000
SQL看起来是正确的...难道是维表入库成临时表的时候id错乱导致匹配不上了?
luofei369 发表于 2021-4-8 11:29
维表自动翻译好像有问题?还是我配置问题?
问题同帖子https://bbs.esensoft.com/thread-139624-1-1.html最佳答案