hive 里面为什么第一条 sql 查不到数据呢?
select t1.pubmed_id,t2.issn from docs_list_temp t1 inner join ods.docs_merge t2 on t1.pubmed_id = t2.pubmed_id where t1.pubmed_id in (29492850,32277430);
能查出来 2 条数据
select * from docs_list_temp t1 where t1.pubmed_id in (29492850,32277430);
能查出来 2 条数据
select * from ods.docs_merge t2 where t2.pubmed_id in (29492850,32277430);
select t1.pubmed_id,t2.issn from docs_list_temp t1 inner join ods.docs_merge t2 on t1.pubmed_id = t2.pubmed_id where t1.pubmed_id in (29492850,32277430);
能查出来 2 条数据
select * from docs_list_temp t1 where t1.pubmed_id in (29492850,32277430);
能查出来 2 条数据
select * from ods.docs_merge t2 where t2.pubmed_id in (29492850,32277430);