distinct(batch)filter(stream)groupby(batch)join(batch)minusall(batch)orderby(batch)select(batch)split(stream)unionall(stream)where(batch)