Hello,
The query below produces a blank file, when no results are found:
insert overwrite table selection_hourly_clicks partition (date_hour = PARTNAME)
select sel_sid, count(*) cc from (
select split(parse_url(iv.referrer_url,'PATH'), '_')[1] sel_sid from
item_raw iv where iv.date_hour='PARTNAME' AND iv.referrer_url is not
null AND substring(parse_url(iv.referrer_url,'PATH'),0,8)=='/target/'
) s group by sel_sid;
where the following query:
insert overwrite table item_hourly_stat partition (date_hour=PARTNAME)
select iv.e_sid, count(*) from item_raw iv where
iv.date_hour='PARTHANE' group by iv.e_sid";
does not produce a blank file when there is no log at that given hour...
this is not a problem or anything, but i am just trying to understand
what is going on. I am sure it is because the first query in question
is a inner query, or something like that.
best regards,
-c.b.
