Re: INSERT OVERWRITE Failure Saftey

2019-11-06 Thread David M
aka.ms/ghei36> From: Shawn Weeks Sent: Wednesday, November 6, 2019 5:35:17 PM To: user@hive.apache.org Subject: Re: INSERT OVERWRITE Failure Saftey I’m not sure specific to Hive 1.3 but in other versions the data is written to a temp location and then at the end of the query the

Re: INSERT OVERWRITE Failure Saftey

2019-11-06 Thread Shawn Weeks
Shawn From: David M Reply-To: "user@hive.apache.org" Date: Wednesday, November 6, 2019 at 3:27 PM To: "user@hive.apache.org" Subject: INSERT OVERWRITE Failure Saftey All, I have a Hive 1.3 cluster running in production, and there was a question about INSERT OVERWRITE que

INSERT OVERWRITE Failure Saftey

2019-11-06 Thread David M
All, I have a Hive 1.3 cluster running in production, and there was a question about INSERT OVERWRITE queries on tables. If I perform an INSERT OVERWRITE query on a table, and the query fails half way through, will the old data still exist in the table? I'm not completely clear on the exact pro