There isn’t a way of doing this currently. But I can see that federating metadata is useful.
The only information that Calcite accesses via its schema SPI is what it needs to prepare queries. I could see us adding an API so that Schema.unwrap(DatabaseMetaData.class) yields a DatabaseMetadata. Then Calcite’s JDBC driver could delegate to it. Log a JIRA case if this is of interest to you. > On Dec 14, 2016, at 7:54 AM, Riccardo Tommasini > <[email protected]> wrote: > > Hi all, > > I am trying to access db metadata through calcite. Playing around with the > sqline interface and checking the code, I understood that calcite accesses > those some metadata using the dedicate jdbc driver. However, some of them are > non > available yet. > > Is there a way to access primary keys for a table for instance? > > thanks in advance! > > Riccardo Tommasini > Master Degree Computer Science > PhD Student at Politecnico di Milano (Italy) > streamreasoning.org<http://streamreasoning.org/> > > Submitted from an iPhone, I apologise for typos.
