Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of cambazz@gmail.com designates
 74.125.82.176 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=LLJdhUSvPUDwmhNnM6J9qmUo0h+J1ZqmJWc74JU/PFjzC0auUV/boqJJk+6hHa1nL2
         JNzQipLo2U69DbKnBR8BVLtRGOm9QRA0YyHT6kZfTFWAv00SdqhgkmQaDo2mOdvuEHgJ
         +JOqQ6BsXUIxzyVwdruRD+wYgHEne2UQe+rB4=
MIME-Version: 1.0
Date: Fri, 11 Feb 2011 10:51:23 +0200
Message-ID: <AANLkTikG1zpm1vJkAJa=TLXVREG+NDRsDy0gxCBCfjP7@mail.gmail.com>
Subject: why some queries produce blank files
From: Cam Bazz <cambazz@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1

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.