为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】:银河麒麟操作系统v10
【CPU】: 16核
【问题描述】*:查询分区表数据,在HIVE库中是5条数据,达梦库中只能查询出4条,有一条被隐藏,SQL中条件加上OR‘社会统一信用代码’能将隐藏的数据查询出来。
查询sql:
SELECT "COUNT"(entCreditCode) FROM (
SELECT (CASE WHEN vri."business_status" IN ('40',
'50',
'60') THEN '正常经营' WHEN vri."business_status" IN ('30',
'70',
'80') THEN '已搬迁' WHEN vri."business_status" = '10' THEN '已关闭' ELSE '已停产' END) AS manageStatus,
ei."uni_scid" AS entCreditCode
FROM ( SELECT *
FROM( SELECT *,
row_number() over (
PARTITION BY uni_scid
ORDER BY enter_date DESC nulls last,
rem_date DESC nulls last ) rn
FROM ads_keyno_ent_info_partition partition (SYS_P2978_2992) ) ci
WHERE "CI"."RN" = 1 AND ((YEAR(enter_date) <= '2023' AND rem_date IS NULL ) OR (YEAR(enter_date) <= '2023' AND YEAR(rem_date) > '2023' )) ) ei
LEFT JOIN ( SELECT *
FROM( SELECT *,
"ROW_NUMBER"()over (
PARTITION BY uni_scid
ORDER BY visi_date DESC nulls last ) rn
FROM (ads_scjg_visi_reco_info_partition partition (SYS_P2976_2980)) vri
WHERE 1=1 AND SUBSTR("vri"."visi_date", 1, 4) = SUBSTR('2023', 1, 4) ) vr
WHERE rn=1 ) vri
ON "vri"."uni_scid" ="EI"."uni_scid"
LEFT JOIN "scjg_market_yxwq" smy
ON "ei"."uni_scid" ="smy"."tyshxydm"
LEFT JOIN keyno_index_sszt_city_base_partition partition (SYS_P2002_2753) scb
ON "EI"."uni_scid" = "SCB"."uni_scid"
WHERE 1=1
AND "vri"."uni_scid" IS NOT NULL
AND vri.is_emi_inten = 1
AND "EI"."street_clean" = '新安街道'
) TOTAL
直接count(*)返回几条?查询SQL发一下