drop table if exists encodelat1;
create table encodelat1 (name STRING) 
 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
 WITH SERDEPROPERTIES ('serialization.encoding'='ISO8859_1');
load data local inpath '../../data/files/encoding_iso-8859-1.txt' overwrite into table encodelat1;
select * from encodelat1;