Jan 12, 2020 in Big Data | Hadoop
Q: What is the use of TOUCH in ALTER statement?

1 Answer

0 votes
Jan 12, 2020
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
Jan 12, 2020 in Big Data | Hadoop
0 votes
0 votes
Aug 19, 2019 in Selenium
...