Thanks for sharing, I was not familiar with Spark Adapter. It's good to know you found a workaround.
Thomas Wang <[email protected]> 于2022年12月26日周一 21:37写道： > 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 > > > -- Best, Benchao Li
