The local /tmp is non-executive configured by admin. When we do a "select ...limit 10" query on Hive, it copied some file to /tmp, and tried to execute it. But since the /tmp is non-executive, I always bumped out of the Hive shell with some binding error.
What is the setting to change this /tmp work folder to other directory?