CREATE LOCATION 'hdfs: ' error, due to Vertica calling curl without the server name

guy_einav

Hi,
Vertica 9.
Unable to create location on HDFS.

Leading hint : Vertica is calling "curl" without the server name
http: "http://50070/webhdfs/v1"

Any leads will be great.
thank you,
Guy.

• my command and full error.
  dbaadmin=> CREATE LOCATION 'hdfs:///dbadmin' SHARED USAGE 'data' LABEL 'coldstorage';
  ERROR 5796: Could not create directory [hdfs:///dbadmin/v_vmart_node0001/]: [http://50070/webhdfs/v1/dbadmin/v_vmart_node0001/?user.name=dbaadmin&op=GETFILESTATUS]: Curl Error: Couldn't connect to server
  Error Details:
  HINT: Please make sure that the directories in the path have sufficient permissions for the vertica process and if the directory denoted by the path exists make sure it is an empty directory

Jim_Knicely

I think this may be a permission error:

ERROR 5796: Could not create directory

See "Requirements for HDFS Storage Locations" doc:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/HadoopIntegrationGuide/StorageLocations/StorageLocationForHDFSRequirements.htm

In particular:

If your HDFS cluster is unsecured, you have a Hadoop user whose username matches the name of the Vertica database administrator (usually named dbadmin). This Hadoop user must have read and write access to the HDFS directory where you want Vertica to store its data.