Update column in HIVE

Asked Jan 14 '15 at 18:33

Active Jan 14 '15 at 18:33

Viewed 187 times

I have a table in php which is in this format:

CREATE EXTERNAL TABLE IF NOT EXISTS {$tableName} (fileContent VARCHAR(250), description VARCHAR(250), dimension DOUBLE, fileName VARCHAR(250)) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' STORED AS TEXTFILE LOCATION '/var/www/ASOIS_Proiect/metadata/'

I want for a situation to update only description field if fileName='a' and 'size'='12' already exist in database.

Any idea please? I tried to update the file create for insert with command LOAD and flag OVERWRITE but it is not working.

asked Jan 14 '15 at 18:33

OsomA

As far as I know, Hive does not support update that way. – LiMuBei Jan 15 '15 at 09:27
Hey, Yes but i think that it might be a way to update some columns.. – OsomA Jan 15 '15 at 16:24
Seems Hive 0.14 added update statement on tables that support ACID.https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Update – LiMuBei Jan 16 '15 at 12:54
Follow this [link][1] it may help you! [1]: http://stackoverflow.com/questions/6200871/update-set-option-in-hive – Yosser Abdellatif Goupil Jan 27 '15 at 09:54

Update column in HIVE

0 Answers0