- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ALTER TABLE RECOVER PARTITIONS not working
- Labels:
-
Apache Impala
Created on 07-30-2019 10:45 AM - last edited on 07-31-2019 03:14 AM by VidyaSargur
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
When I run an ALTER TABLE RECOVER PARTITIONS, my Impala table is not getting updated with the most recent data. All the parquet files are in the proper directory.
However, when I run a REFRESH TABLE, the table gets updated with the new data.
Why is the ALTER TABLE RECOVER PARTITIONS command not working in this case, but the REFRESH TABLE does?
Thank you!
Created 09-24-2019 03:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It depends on how you are updating your partitions. Are you creating completely new partitions, or adding files to existing partitions? ALTER TABLE RECOVER PARTITIONS is specifically used for adding newly created partition directories to a partitioned table - https://impala.apache.org/docs/build/html/topics/impala_alter_table.html