Cannot connect to hive

[Valeriy Trofimov]

Hi All,

I'm trying to connect to Hive DB via Thrift JDBC Server.

I get error: "Object 'test' not found within 'thrift'".

The error occurs by the IdentifierNamespace.resolveImpl() method. The
method checks that schema looks correct based on my query.

Schema:

{
  version: '1.0',
  schemas: [
    {
      name: 'thrift',
      type: 'custom',
      factory: 'org.apache.calcite.adapter.jdbc.JdbcSchema$Factory',
      operand: {
        jdbcDriver: 'org.apache.hive.jdbc.HiveDriver',
        jdbcUrl: 'jdbc:hive2://127.0.0.1:10000/default', // please use
VirtualBox port forwarding to the VM with Thrift server running
        jdbcUser: '',
        jdbcPassword: ''
      }
    }
  ]
}

Test query:

String query = "select * from \"thrift\".\"test\"";

I've double checked that you can connect to Thrift Server and that there is
a database called "default" and table called "test".

It looks like the error is caused by Calcite trying to find entries for
"tables" in the schema. But I am confused why it would look for it. JDBC
schema doesnt require these entries and adding them actually shows error
about "tables" not needing to be there.

Repro steps for this issue are too long, but I can provide if someone is
interested in digging deeper into this.

Thanks,
Val