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,

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedFeb 11, '11 at 8:51a
activeFeb 11, '11 at 8:51a

1 user in discussion

Cam Bazz: 1 post



site design / logo © 2022 Grokbase