[I] Namespace names with dot(.) not supported in Iceberg REST API [iceberg]

[via GitHub]

mingnuj opened a new issue, #11990:
URL: https://github.com/apache/iceberg/issues/11990

   ### Query engine
   
   REST API (JAVA)
   
   ### Question
   
   I am using the Iceberg REST 
API([tabulario/iceberg-rest](https://hub.docker.com/r/tabulario/iceberg-rest)) 
with PostgreSQL JDBC as the backend catalog. However, I have encountered an 
issue where namespace names containing `.` are not supported.
   
   I have verified that namespaces with `.` are correctly stored and retrieved 
in the PostgreSQL database. From my observation, the REST API seems to 
interpret `.` in namespace names as levels by default.
   
   I could not find any mention in the specification that namespace names with 
`.` are disallowed. Moreover, when using double quotes (`"`) in the database, 
it is possible to use `.` in namespace names. I think it would be better to 
allow this in the REST API as well.
   
   PostgreSQL Configuration:
   ```bash
   docker run --name rest-postgres-test \
   -p 5534:5432 \
   -e POSTGRES_PASSWORD=postgres \
   -e TZ=Asia/Seoul \
   -v ./pgdata:/var/lib/postgresql/data \
   -d postgres:latest
   ```
   
   REST API Configuration:
   ```bash
   docker run \
       -e CATALOG_WAREHOUSE=file://warehouse \
       -e CATALOG_IO__IMPL=org.apache.iceberg.hadoop.HadoopFileIO \
       -e CATALOG_CATALOG__IMPL=org.apache.iceberg.jdbc.JdbcCatalog \
       -e CATALOG_URI=jdbc:postgresql://{LOCAL_IP}:5534/postgres \
       -e CATALOG_JDBC_USER=postgres \
       -e CATALOG_JDBC_PASSWORD=postgres \
       -e REST_PORT=8183 \
       -v ./warehouse:/warehouse \
       -p 8183:8183 \
       tabulario/iceberg-rest:latest
   ```
   
   Created `t...@email.com` namespace and `test` table in that.
   Namespace Display in PostgreSQL:
   
   
![Image](https://github.com/user-attachments/assets/c07e5fca-d907-4f7c-9dce-dd49fe5cf566)
   
![Image](https://github.com/user-attachments/assets/8543dfe5-46fa-4ebb-aec4-8d2c73965de7)
   
   Could you confirm whether this is the intended behavior or a bug? If 
possible, I would like to request support for namespace names containing `.`.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org
For additional commands, e-mail: issues-h...@iceberg.apache.org