-
Notifications
You must be signed in to change notification settings - Fork 78
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[FEATURE REQUEST] Display timestamp fields in human-intelligible format #40
Comments
Can you share a sample parquet file? This should be doable |
Sure, here is the same parquet file shown in the screenshot in original post: testFyl.zip This time I'm posting from a different machine where it looks like this: Thanks for your efforts. |
Give this a shot and let me know if it works for you: I compared the values against https://www.online-toolz.com/tools/unix-timestamp-to-date.php and it looks okay to me. (Keep in mind this website converts to your local timezone whilst in Parquet Viewer it will remain as UTC) |
Excellent job. This version shows the timestamps properly. But I must apologize for providing an inadequate sample file which had time only upto hours and minutes and omitted out seconds. It is enough for displaying in ParquetViewer in almost all cases. But just in case it is needed, here is a second sample parquet file which has seconds also: sample2.zip The above version of ParquetViewer shows it as: While in RStudio, where I created the sample file, it shows the seconds also: I should reiterate that the current version shows timestamps properly and is adequate for me. But I thought that I should inform anyway. Thanks again for your efforts. |
ParquetViewer is the best parquet file viewer. However, it shows 'timestamp' fields in Unix epoch (or Unix time or POSIX time or Unix timestamp), i.e., the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT). For example,
The 'date' field is displayed just fine. It is requested that 'date-time' field be made viewable in human-intelligible format.
Meanwhile, I've posted a request at https://stackoverflow.com/questions/68741520/date-time-timestamp-field-in-parquet-file-shown-as-numbers-in-parquet-file-vie to see if something (like formatting change) could be done in R environment before exporting to parquet format so that it displays 'timestamp' field in human-intelligible format in ParquetViewer.
The text was updated successfully, but these errors were encountered: