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 "attempt_200912182309_0102_m_000036_0*", "attempt_200912182309_0102_m_000037_0*"...etc. Any idea how I can have one file (I know I can "cat" on the os, but I'm looking for Hive solution) Thanks. Lee Sagi | Data Warehouse Tech Lead & Architect
