jerqi opened a new issue, #4712:
URL: https://github.com/apache/gravitino/issues/4712
### Version
main branch
### Describe what's wrong
Spark create an Iceberg table but Trino can't query it.
### Error message and/or stacktrace
trino> select * from catalog_hive.sales.customers
-> union
-> select * from catalog_iceberg.sales.customers;
Query 20240827_141931_00040_4sj9m failed: Table sales.customers does not
exist in the internal connector
io.trino.event.QueryMonitor TIMELINE: Query 20240827_141931_00040_4sj9m
:: FAILED (GRAVITINO_TABLE_NOT_EXISTS) :: elapsed 149ms :: planning 149ms ::
waiting 0ms :: scheduling 0ms :: running 0ms :: finishing 0ms :: begin
2024-08-27T14:32:35.478Z :: end 2024-08-27T14:32:35.627Z
### How to reproduce
I use this pull request
https://github.com/apache/gravitino-playground/pull/68
When I execute the SQL
```shell
docker exec -it playground-spark bash
```
```shell
spark@container_id:/$ cd /opt/spark && /bin/bash bin/spark-sql
```
```SQL
use catalog_iceberg;
create database sales;
use sales;
create table customers (customer_id int, customer_name varchar(100),
customer_email varchar(100));
describe extended customers;
insert into customers (customer_id, customer_name, customer_email) values
(11,'Rory Brown','[email protected]');
insert into customers (customer_id, customer_name, customer_email) values
(12,'Jerry Washington','[email protected]');
```
2. Login Trino container and execute the steps.
You can get all the customers from both the Hive and Iceberg table.
```shell
docker exec -it playground-trino bash
```
```shell
trino@container_id:/$ trino
```
```SQL
select * from catalog_hive.sales.customers
union
select * from catalog_iceberg.sales.customers;
```
### Additional context
_No response_
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
