Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Can I update just one row in Hive table using Hive INSERT OVERWRITE


Copy link to this message
-
Can I update just one row in Hive table using Hive INSERT OVERWRITE

Can I update ( delete and insert kind of)just one row keeping the remaining rows intact in Hive table using Hive INSERT OVERWRITE. There is no partition in the Hive table.

INSERT OVERWRITE TABLE tablename SELECT col1,col2,col3 from tabx where col2='abc';

Does the above work ? Please advise.