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.

Historical Disk Usage Report - date format in excel/csv

Solved Go to solution

Historical Disk Usage Report - date format in excel/csv

Contributor

Hello -

When I view the Historical Disk Usage report in CM for daily or weekly or monthly, the values displayed look like dates:    2017-02  or 2017-05-02.

 

However, when I download the report to excel or csv, the date column has values like:   1491020099000

 

Just wondering what that format is and how i can covert back to a date.

 

thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Historical Disk Usage Report - date format in excel/csv

Contributor

Hi all ...

 

According to Cloudera support the date value

  "...is an epoch timestamp includes milliseconds, which makes the the timestamp three digits longer than the date converter expects. You can either remove the last three characters using a substring function, or insert a period before the millisecond digits. Either of these commands will provide the correct timestamp for 1491020099000: date --date='@1491020099' date --date='@1491020099.000'"

 

So...if anyone else needs to know!

 

...douglas

1 REPLY 1
Highlighted

Re: Historical Disk Usage Report - date format in excel/csv

Contributor

Hi all ...

 

According to Cloudera support the date value

  "...is an epoch timestamp includes milliseconds, which makes the the timestamp three digits longer than the date converter expects. You can either remove the last three characters using a substring function, or insert a period before the millisecond digits. Either of these commands will provide the correct timestamp for 1491020099000: date --date='@1491020099' date --date='@1491020099.000'"

 

So...if anyone else needs to know!

 

...douglas

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