I have two questions regarding external tables: Every day I create a staging table based on a data dump of the previous days data, the table and feed have 10 columns. Yesterday they added an 11th column to the feed without teling me. If I create an external table with 10 columns and point it at the feed with 11 columns, will the first 10 columns be read and the 11th ignored? Also, if the feed goes from 10 columns to 9 columns, will the 10th column be NULL?
I am a newbie to hive so please forgive the question. Thanks!
