AnsweredAssumed Answered

What will happen if a hive(0.13) SELECT and INSERT OVERWRITE is running at the same time

Question asked by ryansun on Oct 20, 2015
Hey all,

I would like to know what will happen if a hive SELECT and INSERT OVERWRITE is running at the same time. Please help me to understand what will hive query return in the below scenarios.

 1. Run the query first, while the query is running, INSERT OVERWRITE the same table.
 2. Run the INSERT OVERWRITE first, while overwriting, pull the data from the same table with SELECT.

Are we going to get the old data, new data, mixed data, nothing, or unpredictable data?

Best regards,
Ryan

Outcomes