Hive Catalog 'show tables' works fine but querying errors: "java.net.UnknownHostException: xxxxx"

Question

After I created a Hive catalog, show tables works fine, but querying errors:

java.net.UnknownHostException: xxxxx

The steps to reproduce are:

Create a Hive catalog (Hive is on HDFS):

CREATE CATALOG hive_catalog PROPERTIES (
    'type'='hms',
    'hive.metastore.uris' = 'thrift://172.0.0.1:9083',
    'hadoop.username' = 'hive'
);

Run show tables:

switch hive_catalog; 
show databases;
use my_hive_db_name;
show tables;

This works fine; I can get the full table names of my Hive database.

Execute a query:

select * from hive_catalog.my_hive_db_name.my_table_name;

This errors:

java.net.UnknownHostException: xxxxx

I know this error is about host name, but I don't understand why I can get the full table names without error?

I just want to query my Hive table via Apache Doris catalog.

Chris · Accepted Answer · 2025-06-03 06:58:49Z

1

You can try add the fs.defaultFS property in the Catalog properties and write the HDFS namenode address, for example:

'fs.defaultFS' = 'hdfs://namenode:port'

answered Jun 3 at 6:58

Chris

262 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Young Jun 5 at 3:30

Thank you very much! I have added the fs.defaultFS in my create catalog statement. Now I can read data from hive via doris, it' really a good way to query hive.

agilgur5 Jun 5 at 14:29

if this answer solved your problem, you should "accept" it by clicking the checkmark to the left of its text

Collectives™ on Stack Overflow

Hive Catalog 'show tables' works fine but querying errors: "java.net.UnknownHostException: xxxxx"

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related