Scratch pad directory of hive

Technical Discussions
#1

hi,
Where can I find the user’s scratch directory for hive for the logged in username ?
thanks

#2

Hi @utkarsh_rathor,

By user’s scratch diectory, do you mean the Hive warehouse?

#3

No, I mean Scratch pad directory not the warehouse

It is used in this context

“Hive also supports creating temporary tables. A temporary table is only visible to the current user session. It’s automatically deleted at the end of the session. The data of the temporary table is stored in the user’s scratch directory, such as /tmp/hive-. Therefore, make sure the folder is properly configured or secured when you have sensitive data in temporary tables.”