Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Could not create Hive External table in ADLS GEN2 storage using abfs

Could not create Hive External table in ADLS GEN2 storage using abfs

Explorer

I'm trying to create a HIVE external table in ADLS Gen2 storage using abfs and getting the below time out error:

ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Status code: -1 error code: null error message: InvalidAbfsRestOperationExceptionjava.net.SocketTimeoutException: connect timed out

I have set ADLS authentication in core-site.xml and also can access the storage from hdfs.

 

CREATE EXTERNAL TABLE IF NOT EXISTS test1
(hospital_id varchar(15),
account_year smallint,
id smallint,
num smallint)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' stored as textfile
location 'abfs://test-1@testdev.dfs.core.windows.net/testdir/';

 

HDP version: 3.1.0

Don't have an account?
Coming from Hortonworks? Activate your account here