yql/essentials/tests/sql/suites/stream_lookup_join/lookup_join.sql


1
2
3
4
5
6
7
8
9

pragma dq.UseWideChannels = "true";
use plato;

select e.id as id, e.ts as ts, e.host as host, h.fqdn as fqdn, h.ip4 as ip4, h.ip6 as ip6
    from Event as e 
    left join /*+ streamlookup() */ Host as h
    on (e.host == h.hostname)
;