Thanks Benchao. I was able to connect to a Hive metastore through a Spark JDBC connection and successfully performed a validation. My Spark is connected to the Hive metastore standalone version.
Thomas On Mon, Dec 26, 2022 at 3:11 AM Benchao Li <[email protected]> wrote: > Hi Thomas, > > There is no builtin Schema implementation for Hive in Calcite now. > To build one, you can take a took at the tutorial[1]. > > [1] https://calcite.apache.org/docs/tutorial.html > > Thomas Wang <[email protected]> 于2022年12月26日周一 04:25写道： > > > Hi Calcite community, > > > > I'm trying to validate a SQL statement that contains tables from two > > different schemas (one from a MySQL database and the other from a Hive > > metastore). It looks like, in order to do that, I will need to have a > model > > file that contains these two schemas. For MySQL, it looks like I should > be > > using a JDBC adapter, but I didn't find anything about connecting to a > Hive > > metastore. Any suggestions on how I can connect to a Hive metastore? > > Thanks. > > > > Thomas > > > > > -- > > Best, > Benchao Li >
