我会先数一数你的钥匙

select  accountNum, date, status, time
from    yourTable
where   action in ('B', 'S')
group by accountNum, date, status, time
having  count(distinct action) = 2

然后，您可以将上面的表与初始表连接起来，以便只过滤所需的行

select  t1.*
from    yourTable t1
join    (
            select  accountNum, date, status, time
            from    yourTable
            where   action in ('B', 'S')
            group by accountNum, date, status, time
            having  count(distinct action) = 2
        ) t2
on      t1.accountNum = t2.accountNum and
        t1.date = t2.date and
        t1.status = t2.status and
        t1.time = t2.time

编辑
我不是HiveMaven，但如果 distinct 以及 having 不允许在子查询中使用，您可以这样编写查询

select  t1.*
from    yourTable t1
join    (
            select  accountNum, date, status, time, count(action) as cnt
            from    yourTable
            where   action in ('B', 'S')
            group by accountNum, date, status, time
        ) t2
on      t1.accountNum = t2.accountNum and
        t1.date = t2.date and
        t1.status = t2.status and
        t1.time = t2.time
where   t2.cnt = 2

你可以摆脱 distinct 如果相同的话 accountNum / date / time / status 组合不能有同一操作的多个示例。
这个 having 子句可以作为 where 条件。