Saranviveka commented on issue #6853:
URL: https://github.com/apache/iceberg/issues/6853#issuecomment-1433718015
@Fokko the idea of defining partitions is to reduce our I/O and now based on
your inference if it ends up in scanning all the files , then we don't have to
lean on creating partitions and directly scan the whole table.
This is how the file path looks like
iceberg_table/data/order_id_bucket=3/trans_ts_day=2019-06-13/trans_ts_year=2019/trans_ts_month=2019-06/trans_ts_hour=2019-06-13-17/category=soap/00000-0-848b50e9-2f4d-42f0-baf6-fe543a2a4e88-00001.parquet
It is evident that the date value is exactly used on the folder hierarchy in
that case why it has to be converted to timestamp even when I am casting the
value field as date while doing a equality check
trino>select * from iceberg.glue_catalog.iceberg_table where
trans_ts=date'2019-06-13';
order_id | customer_id | order_amount | category | trans_ts
----------+-------------+--------------+----------+----------
(0 rows)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
