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

Switch to Threaded View
Hive >> mail # user >> update a hive table


Copy link to this message
-
update a hive table
if I wang to update a table, e.g,
 
insert overwrite table mytable
select lower(col1), col2, col3 from mytable;
 
if mytable has many columns but I only need to update one of them, how can I write the
statement short?