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.
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.LazySimpleSerDe' WITH SERDEPROPERTIES("serialization.encoding"='GBK');