tajo-storage/tajo-storage-kafka/src/test/resources/queries/TestKafkaQuery/testFullOuterJoin.sql

select u.id, u.name, p.id, p.prod_name, p.point from user u full outer join prod p on(u.id = p.id) order by u.id