Hi Ryan Thanks for the update. Agree for a new RC. Let me take a look on your PR.
Regards JB On Sat, Mar 2, 2024 at 8:08 PM Ryan Blue <b...@tabular.io> wrote: > > I did more digging and I think the reason why queries work and views fail is > that the ResolveViews rule is inserted at the end of the resolution batch. > Table resolution runs first because of rule ordering, but there are cases > where that isn't necessarily going to happen. Since it's a bad practice to > rely on rule ordering within a batch, I think we need to fix this and move > forward with a new RC. Please take a look at the PR. > > On Sat, Mar 2, 2024 at 10:53 AM Ryan Blue <b...@tabular.io> wrote: >> >> I opened a PR that I think will fix this to get feedback on the approach: >> https://github.com/apache/iceberg/pull/9853 >> >> On Sat, Mar 2, 2024 at 10:36 AM Ryan Blue <b...@tabular.io> wrote: >>> >>> -1 (binding) >>> >>> I'm hitting an exception when testing views that prevents loading tables in >>> Spark. The problem is that the REST catalog I'm using is a view catalog, >>> but the underlying REST service does not support views. As a result, when >>> `loadView` is called, it results in an error instead of >>> `NoSuchViewException`. That error is uncaught and stops SQL query from >>> running, even though a later `loadTable` check will work. >>> >>> I'm looking into why I can read tables normally and why this appears to >>> fail when the load is in a view, but I want to highlight this as a blocker >>> since the vote is otherwise passing. >>> >>> Otherwise, this looks good: >>> - Verified signature, checksums >>> - Ran license checks >>> - Built and tested >>> - Ran manual checks in Spark 3.5 with views >>> >>> On Fri, Mar 1, 2024 at 5:19 PM Daniel Weeks <dwe...@apache.org> wrote: >>>> >>>> +1 (binding) >>>> >>>> Verified sigs/sums/licenses/build/test (Java 17) >>>> >>>> One thing I noticed while testing views is that there is a discrepancy >>>> between the spark catalog behavior of SHOW TABLES and what I see using an >>>> Iceberg catalog (jdbc or REST). >>>> >>>> The "SHOW TABLES" command in spark catalog shows both tables and views, >>>> but only shows tables for Iceberg catalogs. >>>> >>>> I couldn't find any tests that would indicate the expectation of one vs >>>> the other and it appears that there is no standard behavior across >>>> databases, but I was expecting behavior consistent with spark. >>>> >>>> I don't consider this a blocker since it's not defined, but I'm happy to >>>> change my vote if others think differently. >>>> >>>> -Dan >>>> >>>> On Fri, Mar 1, 2024 at 4:18 PM Szehon Ho <szehon.apa...@gmail.com> wrote: >>>>> >>>>> +1 (binding) >>>>> >>>>> - Verified signature >>>>> - Verified checksum >>>>> - RAT check >>>>> - Compiled >>>>> - Manually ran basic queries on Spark 3.5 >>>>> >>>>> On Fri, Mar 1, 2024 at 6:13 AM Fokko Driesprong <fo...@apache.org> wrote: >>>>>> >>>>>> +1 (binding) >>>>>> >>>>>> - Checked checksum and signature >>>>>> - Ran a modified version of dbt-spark to take advantage of the views, >>>>>> and it worked like a charm! 🥳 >>>>>> >>>>>> Cheers, Fokko >>>>>> >>>>>> Op vr 1 mrt 2024 om 06:43 schreef Ajantha Bhat <ajanthab...@gmail.com>: >>>>>>> >>>>>>> Gentle reminder. >>>>>>> >>>>>>> On Wed, Feb 28, 2024 at 8:34 PM Eduard Tudenhoefner <edu...@tabular.io> >>>>>>> wrote: >>>>>>>> >>>>>>>> +1 (non-binding) >>>>>>>> >>>>>>>> * validated checksum and signature >>>>>>>> * checked license docs & ran RAT checks >>>>>>>> * ran build and tests with JDK11 >>>>>>>> * built new docker images and ran through >>>>>>>> https://iceberg.apache.org/spark-quickstart/ >>>>>>>> * tested with Trino & Presto >>>>>>>> * tested view support with Spark 3.5 + JDBC/REST catalog >>>>>>>> * tested view behavior when creating/reading/dropping views from >>>>>>>> Spark/Trino using the diff from >>>>>>>> https://github.com/trinodb/trino/pull/19818 >>>>>>>> >>>>>>>> Eduard >>>>>>>> >>>>>>>> On Wed, Feb 28, 2024 at 1:55 PM Jean-Baptiste Onofré >>>>>>>> <j...@nanthrax.net> wrote: >>>>>>>>> >>>>>>>>> +1 (non binding) >>>>>>>>> >>>>>>>>> I checked: >>>>>>>>> - Signature and checksum are OK >>>>>>>>> - Build is OK on the source distribution >>>>>>>>> - ASF headers are present >>>>>>>>> - No binary file found in the source distribution >>>>>>>>> - Tested on iceland (sample project) + trino and also JDBC Catalog >>>>>>>>> >>>>>>>>> Thanks ! >>>>>>>>> Regards >>>>>>>>> JB >>>>>>>>> >>>>>>>>> On Tue, Feb 27, 2024 at 1:16 PM Ajantha Bhat <ajanthab...@gmail.com> >>>>>>>>> wrote: >>>>>>>>> > >>>>>>>>> > Hi Everyone, >>>>>>>>> > >>>>>>>>> > I propose that we release the following RC as the official Apache >>>>>>>>> > Iceberg 1.5.0 release. >>>>>>>>> > >>>>>>>>> > The commit ID is e39ec185d7879c1a310769d33e0b1b6ad12486a9 >>>>>>>>> > * This corresponds to the tag: apache-iceberg-1.5.0-rc4 >>>>>>>>> > * https://github.com/apache/iceberg/commits/apache-iceberg-1.5.0-rc4 >>>>>>>>> > * >>>>>>>>> > https://github.com/apache/iceberg/tree/e39ec185d7879c1a310769d33e0b1b6ad12486a9 >>>>>>>>> > >>>>>>>>> > The release tarball, signature, and checksums are here: >>>>>>>>> > * >>>>>>>>> > https://dist.apache.org/repos/dist/dev/iceberg/apache-iceberg-1.5.0-rc4 >>>>>>>>> > >>>>>>>>> > You can find the KEYS file here: >>>>>>>>> > * https://dist.apache.org/repos/dist/dev/iceberg/KEYS >>>>>>>>> > >>>>>>>>> > Convenience binary artifacts are staged on Nexus. The Maven >>>>>>>>> > repository URL is: >>>>>>>>> > * >>>>>>>>> > https://repository.apache.org/content/repositories/orgapacheiceberg-1158/ >>>>>>>>> > >>>>>>>>> > Please download, verify, and test. >>>>>>>>> > >>>>>>>>> > Please vote in the next 72 hours. >>>>>>>>> > >>>>>>>>> > [ ] +1 Release this as Apache Iceberg 1.5.0 >>>>>>>>> > [ ] +0 >>>>>>>>> > [ ] -1 Do not release this because... >>>>>>>>> > >>>>>>>>> > Only PMC members have binding votes, but other community members >>>>>>>>> > are encouraged to cast >>>>>>>>> > non-binding votes. This vote will pass if there are 3 binding +1 >>>>>>>>> > votes and more binding >>>>>>>>> > +1 votes than -1 votes. >>>>>>>>> > >>>>>>>>> > - Ajantha >>> >>> >>> >>> -- >>> Ryan Blue >>> Tabular >> >> >> >> -- >> Ryan Blue >> Tabular > > > > -- > Ryan Blue > Tabular