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