David,
I saw this demo as an opportunity to explore the potential of this type of integration (foreign server), as the concept appears to offer a highly versatile and general-purpose solution.Initially, my plan was to integrate DuckDB; however, I encountered some challenges during the process. Consequently, I chose to begin with the simplest integration, with the intention of gradually expanding it to include additional variants over time.
If the namespaces are running on a single instance, the solution you described seems like an excellent approach and likely offers better performance as well. By the way: Your approach might also work with multiple instances if the database is integrated as a remote database?! However, I haven't had a chance to test this, so I'm not sure how the IRIS SQL engine would handle such a setup.
Andreas
It seems to me that this might be a case of an imperfect implementation of the external tables.
Hi!
I'm really looking forward to testing the new release, but I seem to be missing a few clues—it's a bit like trying to solve a mystery without any hints! The page at this link is still empty, and I'm wondering if you could share some details about what's changed. It would be a huge help to know what new features have been implemented so we can put them to the test.
Thanks a lot for your assistance!