hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <>
Subject Hive handling of ingested data when source column changes size or new column added
Date Mon, 15 May 2017 20:08:07 GMT
Assuming we are ingesting into Hive table from an RDBMS Oracle table.

This is done through a daily mechanism.

My conclusion is this.

   1. The source column has moved from VARCHA2(50) to CARCHAR2(100). As I
   know this should not matter in Hive as every VARCHAR is stored as String in
   Hive. So moving from VARCHAR2(50) to VARCHAR2(100) at source with Hive
   column defined as Varchar(50) would not matter? Data will be ingested OK
   2. How about NUMERIC columns or DECIMAL columns at source. Will they
   have to be modified in Hive?

Also if we add another column to source table, then there is no other way
than adding that column to Hive. Also the existing Hive partitions will
stay as before but new partitions will have space reserved for additional


Dr Mich Talebzadeh

LinkedIn *

*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.

View raw message