0 votes
in Big Data | Hadoop by
What is the use of TOUCH in ALTER statement?

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.

Related questions

0 votes
asked Sep 7, 2019 in Big Data | Hadoop by john ganales
+1 vote
asked Feb 10, 2020 in Big Data | Hadoop by miceperry
...