5. CREATE DATABASE Fails when using S3 Storage Location - Teradata Vantage

Apache Iceberg and Delta Lake Open Table Format on VantageCloud Lake Getting Started

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-03
dita:mapPath
bsr1702324250454.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
bsr1702324250454

The following error may occur when creating databases and tables that use S3 storage location.

CREATE DATABASE TPG_DATALAKE_MIXED_ABENCH.MIXED_ABENCH;
 *** Error 7825 in UDF/XSP/UDM TD_OTFDB.ICEBERG_EXPORT: SQLSTATE 38001: [T
 D-Iceberg-Write]: Contract: [TD-Iceberg-Write]: Execution: [AllCols-Outer]Fai
 led to create namespace MIXED_ABENCH in Hive Metastore
                  Statement# 1, Info =0
 *** Total elapsed time was 1 second.

To resolve this, ensure the S3 bucket naming conventions are followed: Bucket naming rules - Amazon Simple Storage Service. For example, the following bucket names are not valid:

  • example_bucket (contains underscores)
  • ExampleBucket (contains uppercase letters)
  • s3-demo-bucket- (ends with a hyphen)

In general, users must adhered to the naming convention for S3 Buckets.