last_modified_time and transient_lastDdlTime - what is transient_lastDdlTime for.

2016-01-06 Thread Ophir Etzion
I want to know for each of my tables the last time it was modified. some of
my tables don't have last_modified_time in the table parameters but all
have transient_lastDdlTime.
transient_lastDdlTime seems to be the same as last_modified_time in some of
the tables I randomly cheked.

what is the time in transient_lastDdlTime? if it also the modified time why
is there also last_modified_time?

Thanks,
Ophir


RE: last_modified_time and transient_lastDdlTime - what is transient_lastDdlTime for.

2016-01-06 Thread Mich Talebzadeh
e designated recipient only, if you are not the intended 
recipient, you should destroy it immediately. Any information in this message 
shall not be understood as given or endorsed by Peridale Technology Ltd, its 
subsidiaries or their employees, unless expressly so stated. It is the 
responsibility of the recipient to ensure that this email is virus free, 
therefore neither Peridale Ltd, its subsidiaries nor their employees accept any 
responsibility.

 

From: Ophir Etzion [mailto:op...@foursquare.com] 
Sent: 06 January 2016 22:15
To: user@hive.apache.org
Subject: last_modified_time and transient_lastDdlTime - what is 
transient_lastDdlTime for.

 

I want to know for each of my tables the last time it was modified. some of my 
tables don't have last_modified_time in the table parameters but all have 
transient_lastDdlTime.
transient_lastDdlTime seems to be the same as last_modified_time in some of the 
tables I randomly cheked.

what is the time in transient_lastDdlTime? if it also the modified time why is 
there also last_modified_time?

 

Thanks,

Ophir