Queries That Run Successfully in Airpal may Fail in Airbnb

[jefffeng]

We've encountered several SQL queries that will complete successfully in Airpal, but will fail in SQL Lab with either the Run Query or the "Run Async" button. Here is an example query below, as well as the screenshots for Airpal

Example 1

create table tmp.holidaycards as
select a.id_guest, a.id_host, a.dim_host_language, a.dim_guest_language
from (select * from magical_booking.fct_bookings_detail where ds>='2016-01-01') a
left join (select * from core_data.fct_cancellations where ds>='2016-01-01' ) b
on a.id_reservation=b.id_reservation
join (select * from core_data.fct_reviews_of_guest where ds>='2016-01-01' and dim_overall_rating in ('4','5')) c
on a.id_reservation=c.id_reservation
join (select * from core_data.fct_reviews_of_host where ds>='2016-01-01' and dim_overall_rating in ('4','5')) d
on a.id_reservation=d.id_reservation
where b.id_reservation is null

Query works in Airpal:

Query does not work in SQL Lab:

[jfeng15]

Issue can be closed now. Query now works in SQL Lab