Hi @Shashank Chauhan
Are you using hive cli or beeline? or something else, like hive view in ambari? The solution is different depending on this.
If you are on cli/beeline, try setting the LANG env viariable before you run your query in beeline
export LANG=ja_JP.UTF-8
If you are using ambari views, you may have to add that into ambari-env.sh
Update: BTW you may also have to set the SERDEPROPERTIES for your table, if you havent already. Ex.
ALTER TABLE your_table SET SERDEPROPERTIES ('serialization.encoding'='SJIS');