How to change the FIELD TERMINATED value for an existing Hive table?

hive >

ALTER TABLE table_name    
set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES ('field.delim' = '|');

It works. Check DESC FORMATTED tbl_name before and after applying the query. Hope this helps!

Related