2. SQL 试题二
create table a(`date` string,v1 int) row format delimited fields
terminated by '\t';
create table b(`date` string,v2 int) row format delimited fields
terminated by '\t';
select nvl(a.date,b.date) as dt1,nvl(a.v1,0) as v1,nvl(b.v2,0) as v2
from a full join b on a.date = b.date
