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.