Hi Bhavesh, I am no expert in this matter but typical Hive use cases don't involve updates. If your workflow, relies considerably on updating existing data in Hive (i.e. in HDFS), you might need to re-think your design or the tools you use.
Mark Mark Grover, Business Intelligence Analyst OANDA Corporation www: oanda.com www: fxtrade.com e: mgro...@oanda.com "Best Trading Platform" - World Finance's Forex Awards 2009. "The One to Watch" - Treasury Today's Adam Smith Awards 2009. ----- Original Message ----- From: "Bhavesh Shah" <bhavesh25s...@gmail.com> To: user@hive.apache.org, d...@hive.apache.org Sent: Monday, February 13, 2012 5:20:33 AM Subject: How to do updation in Hive? Hello all, I want to update a columns every time. I have table consists of 50 columns. I am applying such condition so that every time I need to update a column. I know that Hive doesn't support UPDATE and If I think about using PARTITION COLUMN so how can I maintain these columns? Is there any way in Hive which helps me to update in Hive? or Is there any patch file which helps me to do this? (But I don't know to how apply Patch files in Linux as I am new to it?) Please suggest me some solution. I got stuck here and I am not getting what to do. (I am using hive-0.7.1) -- Regards, Bhavesh Shah