[password key=baike]
LOAD DATA LOCAL INPATH ‘get_wap_summary_lemmaId2.txt’ OVERWRITE INTO TABLE tmp_external_ids PARTITION (dt='{@date_timestamp}’);
SELECT
ta.lemma_title, tc.id
FROM
(SELECT id FROM tmp_external_ids WHERE dt='{@date_timestamp}’) tc
JOIN
(
SELECT
lemma_id,lemma_title
FROM
wikicore_tblLemma
WHERE
dt='{@date}’ AND latest_version_id>0 AND type=0
)ta
ON (tc.id=ta.lemma_id)
JOIN
(
SELECT
target_id, collect_set(tag_name) AS tags
FROM
wikitag_tbltagrel
WHERE
dt='{@date}’
AND
tag_name like ‘%医生%’ or tag_name like ‘%医师%’ or tag_name like’%医疗%’or tag_name like’%出诊%’or tag_name like’%医院%’
GROUP BY target_id
)tb
ON(ta.lemma_id=tb.target_id)
[/password]
