Skip to content

🐛 [Bug] Hive connection fails with "Could not resolve table reference: 'information_schema.schemata'" error #930

@safishhh

Description

@safishhh

Contribution guidelines

I've found a bug and checked that ...

  • ... the problem doesn't occur with the server or web themes
  • ... the documentation does not mention anything about my problem
  • ... there are no open or closed issues that are related to my problem

Affected Module

Core (Default)

Description

When connecting Hive to query the data source, the following error occurred, which seems to be written dead. When reading the table, it defaults to reading 'information_stemplate. schema', Hive does not have this database, it seems to be MySQL:2025-03-12 16:38:32,898 ERROR [http-nio-127.0.0.1-9096-exec-2] io.edurt.datacap.spi.adapter.JdbcAdapter [JdbcAdapter.java:107] Execute content failed content SELECT
SCHEMA_NAME AS object_name,
'DATABASE' AS object_type,
'' AS object_comment
FROM information_schema.SCHEMATA; exception
java.sql.SQLException: org.apache.hive.service.cli.HiveSQLException: AnalysisException: Could not resolve table reference: 'information_schema.schemata'

Expected behaviour

No response

Actual behaviour

No response

Steps to reproduce

No response

Package versions

  • Java: java --version
  • Node: node --version
  • Npm: npm -v
  • Server: ./mvnw -Dexec.executable='echo' -Dexec.args='${project.version}' --non-recursive exec:exec -Dorg.slf4j.simpleLogger.defaultLogLevel=WARN -Dorg.slf4j.simpleLogger.log.org.apache.maven.plugins.help=INFO | tail -1

Configuration

System information

  • Operating system: ...
  • Browser: ...

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions