Dynamic partition in hive for timestamp

[#1 · Accepted solution]

@Gayathri Devi

As per logs you have shared 
starttime=2017-08-01 18:40:03.0
starttime=2017-08-02 18:40:03.0
starttime=2017-08-03 18:40:03.0
starttime=2017-08-04 18:40:03.0
starttime=2017-08-05 18:40:03.0
starttime=2017-08-06 18:40:03.0
starttime=2017-08-09 18:40:03.0 partitions are created to view them

Do

hive# desc formatted <database-name>.<table-name>

get the location where table got stored and check

the hdfs location

bash# hdfs dfs -ls -R <table-location>

[#2]

Shu

Thanks !!!