Query id: 7044f600-7658-4471-9fe4-41da8f0fe8d8
┌─name─────────────────────────────────────────────┐
1. │ INFORMATION_SCHEMA │
2. │ datalake_db_c18d36b8_7487_11f1_bda4_de7b9eea3491 │
3. │ default │
4. │ information_schema │
5. │ system │
└──────────────────────────────────────────────────┘
5 rows in set. Elapsed: 0.001 sec.
SHOW TABLES FROM datalake_db_c18d36b8_7487_11f1_bda4_de7b9eea3491
Query id: 1da03316-1a59-4b2c-a221-988e99559c05
Ok.
0 rows in set. Elapsed: 0.009 sec.
CREATE TABLE datalake_db_c18d36b8_7487_11f1_bda4_de7b9eea3491.`namespace1.iceberg1`
(
`int32_col` Int32,
`float64_col` Float64,
`string_col` String
)
ENGINE = IcebergS3('http://minio:9000/warehouse/data/namespace1/iceberg1/', 'admin', 'password')
PARTITION BY int32_col
ORDER BY int32_col
SETTINGS write_full_path_in_iceberg_metadata = 1Query id: aea7604e-081f-4bb3-be29-6cddec46ab8d
Ok.
0 rows in set. Elapsed: 0.014 sec.
SHOW TABLES FROM datalake_db_c18d36b8_7487_11f1_bda4_de7b9eea3491
Query id: c580bdff-c62b-4960-82b2-44a4bf78102b
Ok.
0 rows in set. Elapsed: 0.008 sec.
Select works (table exists):
SELECT *
FROM datalake_db_c18d36b8_7487_11f1_bda4_de7b9eea3491.`namespace1.iceberg1`
Query id: 43489ef9-9265-428a-bee7-e45377b064fc
Ok.
0 rows in set. Elapsed: 0.007 sec.
SET show_data_lake_catalogs_in_system_tables = 1
Query id: 8dc7003b-abe0-4af3-95c3-1ff6962c11f7
Ok.
0 rows in set. Elapsed: 0.002 sec.
SHOW TABLES FROM datalake_db_c18d36b8_7487_11f1_bda4_de7b9eea3491
Query id: a58f3e58-02d6-47be-a2aa-efe897a8ad35
Ok.
0 rows in set. Elapsed: 0.015 sec.
SHOW TABLES FROM datalake_db_c18d36b8_7487_11f1_bda4_de7b9eea3491SHOW TABLES FROM datalake_db_c18d36b8_7487_11f1_bda4_de7b9eea3491Select works (table exists):
SHOW TABLES FROM datalake_db_c18d36b8_7487_11f1_bda4_de7b9eea3491