Categories

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

1 Answer

Jan 12
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.
Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Madanswer
Jan 12 in Big Data | Hadoop
Oct 30, 2019 in DBMS
Apr 22 in DBMS
...