Hi, Does the MR jobs of a hive query write directly to the destination or are the results of the MR jobs moved to the destination at the end? To be more precise, is it safe to write query in the following way,
insert overwrite table X select do_something from X join Y on (some key) Was little reluctant to go by the experimental results and wanted to confirm. Thanks, Ram
