Add Japanese data using HUE

[tarunjangid]

Hi There,

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.

Thanks,

Tarun

[Khanna]

Hi Tarun,

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');

Regards

Nitish Khanna