How can I find last modified timestamp for a table in Hive?

hive timestamp last-modified
user7375202 picture user7375202 · Jan 4, 2017 · Viewed 21k times · Source

I'm trying to fetch last modified timestamp of a table in Hive.

Answer

satznova picture satznova · Dec 13, 2018

Get the transient_lastDdlTime from your Hive table.

SHOW CREATE TABLE table_name;

Then copy paste the transient_lastDdlTime in below query to get the value as timestamp.

SELECT CAST(from_unixtime(your_transient_lastDdlTime_value) AS timestamp);

Related questions

Date comparison in Hive

I'm working with Hive and I have a table structured as follows: CREATE TABLE t1 ( id INT, created TIMESTAMP, some_value BIGINT ); I need to find every row in t1 that is less than 180 days old. The following query yields …

Read More
How to delete and update a record in Hive

I have installed Hadoop, Hive, Hive JDBC. which are running fine for me. But I still have a problem. How to delete or update a single record using Hive because delete or update command of MySQL is not working in …

Read More
How to know Hive and Hadoop versions from command prompt?

How can I find which Hive version I am using from the command prompt. Below is the details- I am using Putty to connect to hive table and access records in the tables. So what I did is- I opened …

Read More