Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Dynamic partition in hive for timestamp

Solved Go to solution

Dynamic partition in hive for timestamp

New Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Dynamic partition in hive for timestamp

Super Guru
@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 REPLIES 2

Re: Dynamic partition in hive for timestamp

Super Guru
@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>
Highlighted

Re: Dynamic partition in hive for timestamp

New Contributor

Shu

Thanks !!!

Don't have an account?
Coming from Hortonworks? Activate your account here