-
Notifications
You must be signed in to change notification settings - Fork 5.3k
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
Document types of $file_size and $file_modified_time #22627
Comments
@agrawalreetika, I believe this was originally your contribution. Can you confirm if $file_size and $file_modified_time are int32s or int64s? |
@steveburnett : $file_size and $file_modified_time are int64_t for Presto Native Engine. I recently added these in Velox. ref This would be compatible with Presto java. Though please confirm with Reetika as well. |
@steveburnett : $file_size and $file_modified_time are int64_t for Presto Java as well. |
Thanks @aditi-pandit and @agrawalreetika! I will open a doc PR to update the page. |
On https://prestodb.io/docs/current/connector/hive.html I see
The Hive connector exposes extra hidden metadata columns in Hive tables. You can query these columns as a part of SQL query like any other columns of the table.
$path : Filepath for the given row data
$file_size : Filesize for the given row
$file_modified_time : Last file modified time for the given row
However this fails to say whether these are int32s or int64s. Add that detail. I'm pretty sure the correct answer is int64.
The text was updated successfully, but these errors were encountered: