如何在Pyspark中实现这个查询?
我需要将这个子句中使用exist的地方转换为另一个 Dataframe 。
SELECT
c.Id, c.Description, c.Code
FROM charlie as c
Where (
c.Status = 'ACTIVE' or
exists (
select 1 from beta as b
where c.Id = b.Id
)
)
1条答案
按热度按时间fhity93d1#