in Big Data | Hadoop by
Q:
What is the use of TOUCH in ALTER statement?

▼ Show 1 Answer

0 votes
by
In Hive, TOUCH clause in ALTER statement is used to read the metadata and write it back. This operation will modify the last accessed time of a partition in Hive.

With TOUCH statement we can also execute the POST and PRE hooks on a table partition.

This statement cannot be used for

 

creating a table or partition if it does not exist yet.
Learn More with Madanswer
...