Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
3 of 4 tasks
safishhh opened this issue Mar 18, 2025 · 1 comment
Labels
bug Something isn't working

Comments

@safishhh
Copy link

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: ...
@safishhh safishhh added the bug Something isn't working label Mar 18, 2025
@qianmoQ
Copy link
Member

qianmoQ commented Mar 18, 2025

Message that will be displayed on users' first issue

@qianmoQ qianmoQ changed the title 🐛 [Bug] This is a bug name 🐛 [Bug] Hive connection fails with "Could not resolve table reference: 'information_schema.schemata'" error Mar 19, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants