05-15-2017 09:04 PM
I need to upload a data table in HUE in a database but the issue is that the data is in Japanese so the data preview is showing the data to be crushed/scrambled.
Can you please help me with the steps to properly upload Japanese data table in Database.
05-15-2017 09:40 PM
Kindly try to alter table with below serialiaztion and let me know if it doesn't work.
ALTER TABLE person SET SERDEPROPERTIES ('serialization.encoding'='GBK');
Or you can create a fresh table
CREATE TABLE person(id INT, name STRING, desc STRING)ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerD
e' WITH SERDEPROPERTIES("serialization.encoding"='GBK');