Saranviveka commented on issue #6853:
URL: https://github.com/apache/iceberg/issues/6853#issuecomment-1433559210
Equality doesnt work. So we can't use the date value with equal symbol.
In addition, it seems that it is mandate to provide a full date on the
filter query at all the time, even though we have partitioned on date, year,
month, day.
It means, bare minimal we have to provide the full date that includes yyyy
mm dd and we have to use greater than, lesser than or between conditions to
filter on year or month or day.
Example: If i have to get all June months data of 2019, then I have to frame
the following query.
trino> select * from iceberg.catbdsql_glue_catalog.iceberg_table where
trans_ts between date '2019-06-01' and date '2019-06-30' ;
order_id | customer_id | order_amount | category | trans_ts
----------+-------------+--------------+----------+--------------------------------
10001 | 1 | 6.17 | soap | 2019-06-13
17:22:30.000000 UTC
Or is there an alternatively way to query it effectively ?
If the above statement is true, then we have to educate the end user on how
to use the filter conditions to get correct results. Which seems to be more
complicated than instructing them to have the partition field to cut down I/O.
--
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]
