hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sagi, Lee" <>
Subject Create os/local file from Hive Query
Date Tue, 22 Dec 2009 00:45:43 GMT
I'm trying to create a local os file from a hive query:

INSERT OVERWRITE LOCAL DIRECTORY '../../dwh_out/click_term_20091219.dat'
SELECT a.date_key, a.deal_id, a.is_roi, a.search_query,
a.traffic_source, a.country_id FROM str_click_term_final a

I expected to have a file "called click_term_20091219.dat" in directory
"'../../dwh_out", instead I got a directory named
"../../dwh_out/click_term_20091219.dat" and in it multifile files like

Any idea how I can have one file (I know I can "cat" on the os, but I'm
looking for Hive solution)


Lee Sagi | Data Warehouse Tech Lead & Architect 

View raw message