My Oracle Support Banner

Big Data SQL 3.2 Queries Fail With "Invalid host name: local host is: (unknown);" (Doc ID 2424658.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Big Data Appliance Integrated Software - Version 4.10.0 and later
Oracle Big Data SQL - Version 3.2.0 to 3.2.0 [Release 3.2]
Linux x86-64

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner. 

After installing BDS 3.2 successfully queries fail with:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400 data cartridge error
KUP-11504: error from external driver: oracle.hadoop.sql.xcat.common.XCatException : 1001 : Error getting splits document. Cause : java.net.UnknownHostException: Invalid host name: local host is: (unknown); destination host is: "bdanode01.example.com":8020; java.net.UnknownHostException; For more details see: http://wiki.apache.org/hadoop/UnknownHost

2. The /etc/hosts file, used for name resolution, is configured like:

<PRIVATE_IP_HOST1> bdanode01.example.com bdanode01
<PRIVATE_IP_HOST2> bdanode02.example.com bdanode02
<PRIVATE_IP_HOST3> bdanode03.example.com bdanode03
<PRIVATE_IP_HOST4> bdanode04.example.com bdanode04
<PRIVATE_IP_HOST5> bdanode05.example.com bdanode05
<PRIVATE_IP_HOST6> bdanode06.example.com bdanode06

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.