Have you tried constructing the table as a text file?
use the following at the end of the "CREATE table" statement :
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
It might be just that sequencefile puts in some information even if there is
no data.
Cheers,
Ajo.
On Wed, Feb
Hello,
I am making a query such that:
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 AN
