danhuawang opened a new issue, #10925:
URL: https://github.com/apache/gravitino/issues/10925
### Version
main branch
### Describe what's wrong
Create view failed when trino connect a remote IRC
```
trino> CREATE OR REPLACE VIEW remote_irc.test.sales_performance_view AS
-> SELECT
-> name,
-> salary,
-> salary * 0.1 AS expected_bonus,
-> hire_date
-> FROM remote_irc.test.employees
-> WHERE department = 'Sales';
->
Query 20260430_101133_00075_p5mkp failed: Failed to create view
'sales_performance_view'
io.trino.spi.TrinoException: Failed to create view 'sales_performance_view'
at
io.trino.plugin.iceberg.catalog.rest.TrinoRestCatalog.createView(TrinoRestCatalog.java:631)
at
io.trino.plugin.iceberg.IcebergMetadata.createView(IcebergMetadata.java:3211)
at
io.trino.plugin.base.classloader.ClassLoaderSafeConnectorMetadata.createView(ClassLoaderSafeConnectorMetadata.java:661)
at
io.trino.tracing.TracingConnectorMetadata.createView(TracingConnectorMetadata.java:790)
at
io.trino.metadata.MetadataManager.createView(MetadataManager.java:1622)
at io.trino.tracing.TracingMetadata.createView(TracingMetadata.java:957)
at io.trino.execution.CreateViewTask.execute(CreateViewTask.java:151)
at io.trino.execution.CreateViewTask.execute(CreateViewTask.java:53)
at
io.trino.execution.DataDefinitionExecution.start(DataDefinitionExecution.java:152)
at
io.trino.execution.SqlQueryManager.createQuery(SqlQueryManager.java:284)
at
io.trino.dispatcher.LocalDispatchQuery.startExecution(LocalDispatchQuery.java:150)
at
io.trino.dispatcher.LocalDispatchQuery.lambda$waitForMinimumWorkers$1(LocalDispatchQuery.java:134)
at
io.airlift.concurrent.MoreFutures.lambda$addSuccessCallback$0(MoreFutures.java:570)
at io.airlift.concurrent.MoreFutures$3.onSuccess(MoreFutures.java:545)
at
com.google.common.util.concurrent.Futures$CallbackListener.run(Futures.java:1132)
at io.trino.$gen.Trino_478____20260430_050040_2.run(Unknown Source)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1090)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614)
at java.base/java.lang.Thread.run(Thread.java:1474)
Caused by: org.apache.iceberg.exceptions.ServiceFailureException: Server
error: ServiceFailureException: Server error: NoSuchMetadataObjectException:
The metadata object of catalog_1.test.sales_performance_view isn't found
at
org.apache.iceberg.rest.ErrorHandlers$DefaultErrorHandler.accept(ErrorHandlers.java:243)
at
org.apache.iceberg.rest.ErrorHandlers$ViewErrorHandler.accept(ErrorHandlers.java:168)
at
org.apache.iceberg.rest.ErrorHandlers$ViewErrorHandler.accept(ErrorHandlers.java:152)
at org.apache.iceberg.rest.HTTPClient.throwFailure(HTTPClient.java:240)
at org.apache.iceberg.rest.HTTPClient.execute(HTTPClient.java:336)
at org.apache.iceberg.rest.HTTPClient.execute(HTTPClient.java:297)
at org.apache.iceberg.rest.BaseHTTPClient.post(BaseHTTPClient.java:100)
at
org.apache.iceberg.rest.RESTSessionCatalog$RESTViewBuilder.create(RESTSessionCatalog.java:1319)
at
org.apache.iceberg.rest.RESTSessionCatalog$RESTViewBuilder.createOrReplace(RESTSessionCatalog.java:1344)
at
io.trino.plugin.iceberg.catalog.rest.TrinoRestCatalog.createView(TrinoRestCatalog.java:624)
... 18 more
```
When I switch connecting to a local IRC catalog, create view successfully.
```
wangdanhua@wangdanhuadeMBP env1-cross-metalake % trino --server
http://35.190.166.193:8080 --debug
trino> CREATE OR REPLACE VIEW gravitino_irc.test.sales_performance_view AS
-> SELECT
-> name,
-> salary,
-> salary * 0.1 AS expected_bonus,
-> hire_date
-> FROM gravitino_irc.test.employees
-> WHERE department = 'Sales';
->
CREATE VIEW
trino> exit;
```
### Error message and/or stacktrace
gravitino-server.log
```
2026-04-30 10:11:34.767 INFO [iceberg-rest-36]
[org.apache.gravitino.iceberg.service.rest.IcebergViewOperations.createView(IcebergViewOperations.java:139)]
- Create Iceberg view, catalog: catalog_1, namespace: test, createViewRequest:
CreateViewRequest{name=sales_performance_view,
location=s3://irc-e2e-env1-metalake-b-warehouse/env1/metalake_b/catalog_1/test/sales_performance_view-5b65c074589345cabcf8f3eb1f8ac600,
schema=table {
1: name: required string
2: salary: required double
3: expected_bonus: required double
4: hire_date: required date
}, viewVersion=BaseViewVersion{versionId=1, timestampMillis=1777543894648,
summary={iceberg-version=Apache Iceberg 1.10.1 (commit
ccb8bc435062171e64bc8b7e5f56e6aed9c5b934)},
representations=[SQLViewRepresentation{sql=SELECT
name
, salary
, (salary * DECIMAL '0.1') expected_bonus
, hire_date
FROM
remote_irc.test.employees
WHERE (department = 'Sales')
, dialect=trino}], schemaId=0, defaultNamespace=test, defaultCatalog=null},
properties={trino.run-as-owner=wangdanhua}}
2026-04-30 10:11:34.948 INFO [iceberg-rest-36]
[org.apache.iceberg.view.BaseMetastoreViewCatalog$BaseViewBuilder.viewDefaultProperties(BaseMetastoreViewCatalog.java:99)]
- View properties set at catalog level through catalog properties: {}
2026-04-30 10:11:34.952 INFO [iceberg-rest-36]
[org.apache.iceberg.view.BaseMetastoreViewCatalog$BaseViewBuilder.viewOverrideProperties(BaseMetastoreViewCatalog.java:113)]
- View properties enforced at catalog level through catalog properties: {}
2026-04-30 10:11:35.047 INFO [iceberg-rest-36]
[org.apache.iceberg.view.BaseViewOperations.commit(BaseViewOperations.java:129)]
- Successfully committed to view test.sales_performance_view in 79 ms
2026-04-30 10:11:35.052 INFO [iceberg-rest-36]
[org.apache.iceberg.view.BaseViewOperations.refreshFromMetadataLocation(BaseViewOperations.java:196)]
- Refreshing view metadata from new version:
s3://irc-e2e-env1-metalake-b-warehouse/env1/metalake_b/catalog_1/test/sales_performance_view-5b65c074589345cabcf8f3eb1f8ac600/metadata/00000-1f00726e-c966-425e-949e-2947262598d4.gz.metadata.json
2026-04-30 10:11:35.111 INFO [iceberg-rest-36]
[org.apache.gravitino.catalog.ViewOperationDispatcher.loadView(ViewOperationDispatcher.java:72)]
- Loading view: metalake_b.catalog_1.test.sales_performance_view
2026-04-30 10:11:35.116 INFO [iceberg-rest-36]
[org.apache.iceberg.view.BaseViewOperations.refreshFromMetadataLocation(BaseViewOperations.java:196)]
- Refreshing view metadata from new version:
s3://irc-e2e-env1-metalake-b-warehouse/env1/metalake_b/catalog_1/test/sales_performance_view-5b65c074589345cabcf8f3eb1f8ac600/metadata/00000-1f00726e-c966-425e-949e-2947262598d4.gz.metadata.json
2026-04-30 10:11:35.183 INFO [iceberg-rest-36]
[org.apache.iceberg.view.BaseViewOperations.refreshFromMetadataLocation(BaseViewOperations.java:196)]
- Refreshing view metadata from new version:
s3://irc-e2e-env1-metalake-b-warehouse/env1/metalake_b/catalog_1/test/sales_performance_view-5b65c074589345cabcf8f3eb1f8ac600/metadata/00000-1f00726e-c966-425e-949e-2947262598d4.gz.metadata.json
2026-04-30 10:11:35.263 INFO [iceberg-rest-36]
[org.apache.gravitino.catalog.lakehouse.iceberg.IcebergCatalogOperations.loadSchema(IcebergCatalogOperations.java:246)]
- Loaded Iceberg schema (database) test from Iceberg
2026-04-30 10:11:35.263 WARN [iceberg-rest-36]
[org.apache.gravitino.catalog.OperationDispatcher.getStringIdFromProperties(OperationDispatcher.java:191)]
- String identifier is not set in schema properties, this is because the
schema is not created by Gravitino, or the schema is created by Gravitino but
the string identifier is removed by the user.
2026-04-30 10:11:35.265 INFO [iceberg-rest-36]
[org.apache.iceberg.view.BaseViewOperations.refreshFromMetadataLocation(BaseViewOperations.java:196)]
- Refreshing view metadata from new version:
s3://irc-e2e-env1-metalake-b-warehouse/env1/metalake_b/catalog_1/test/sales_performance_view-5b65c074589345cabcf8f3eb1f8ac600/metadata/00000-1f00726e-c966-425e-949e-2947262598d4.gz.metadata.json
2026-04-30 10:11:35.350 INFO [iceberg-rest-36]
[org.apache.iceberg.view.BaseViewOperations.refreshFromMetadataLocation(BaseViewOperations.java:196)]
- Refreshing view metadata from new version:
s3://irc-e2e-env1-metalake-b-warehouse/env1/metalake_b/catalog_1/test/sales_performance_view-5b65c074589345cabcf8f3eb1f8ac600/metadata/00000-1f00726e-c966-425e-949e-2947262598d4.gz.metadata.json
2026-04-30 10:11:35.451 INFO [iceberg-rest-36]
[org.apache.gravitino.catalog.ViewOperationDispatcher.importView(ViewOperationDispatcher.java:136)]
- Auto-importing view metalake_b.catalog_1.test.sales_performance_view into
Gravitino entity store
2026-04-30 10:11:35.471 WARN [iceberg-rest-36]
[org.apache.gravitino.catalog.ViewOperationDispatcher.importView(ViewOperationDispatcher.java:152)]
- Failed to import view metalake_b.catalog_1.test.sales_performance_view into
entity store: org.postgresql.util.PSQLException: ERROR: null value in column
"audit_info" of relation "view_meta" violates not-null constraint
Detail: Failing row contains (2708615288177740842, sales_performance_view,
1365525684669152879, 1836798795800232444, 3168026819770298132, 1, 1, 0, null).
2026-04-30 10:11:35.472 INFO [iceberg-rest-36]
[org.apache.gravitino.iceberg.service.dispatcher.IcebergViewHookDispatcher.importView(IcebergViewHookDispatcher.java:206)]
- Successfully imported view into Gravitino:
metalake_b.catalog_1.test.sales_performance_view
2026-04-30 10:11:35.556 WARN [iceberg-rest-36]
[org.apache.gravitino.iceberg.service.IcebergExceptionMapper.toRESTResponse(IcebergExceptionMapper.java:134)]
- Iceberg REST server unexpected exception:
org.apache.gravitino.exceptions.NoSuchMetadataObjectException: The metadata
object of catalog_1.test.sales_performance_view isn't found
at
org.apache.gravitino.authorization.OwnerManager.getOwner(OwnerManager.java:220)
~[gravitino-core-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.authorization.OwnerManager.setOwner(OwnerManager.java:69)
~[gravitino-core-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.authorization.OwnerEventManager.setOwner(OwnerEventManager.java:62)
~[gravitino-core-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.iceberg.service.dispatcher.IcebergOwnershipUtils.setViewOwner(IcebergOwnershipUtils.java:110)
~[gravitino-iceberg-rest-server-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.iceberg.service.dispatcher.IcebergViewHookDispatcher.createView(IcebergViewHookDispatcher.java:72)
~[gravitino-iceberg-rest-server-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.iceberg.service.dispatcher.IcebergViewEventDispatcher.createView(IcebergViewEventDispatcher.java:92)
~[gravitino-iceberg-rest-server-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.iceberg.service.rest.IcebergViewOperations.lambda$createView$1(IcebergViewOperations.java:151)
~[gravitino-iceberg-rest-server-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:712)
~[?:?]
at java.base/javax.security.auth.Subject.doAs(Subject.java:439) ~[?:?]
at
org.apache.gravitino.utils.PrincipalUtils.doAs(PrincipalUtils.java:53)
~[gravitino-core-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at org.apache.gravitino.server.web.Utils.doAs(Utils.java:202)
~[gravitino-server-common-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.iceberg.service.rest.IcebergViewOperations.createView(IcebergViewOperations.java:145)
~[gravitino-iceberg-rest-server-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.iceberg.service.rest.IcebergViewOperations_$$_jvst20e_2._d2createView(IcebergViewOperations_$$_jvst20e_2.java)
~[gravitino-iceberg-rest-server-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[?:?]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?]
at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
at
org.glassfish.hk2.utilities.reflection.ReflectionHelper.invoke(ReflectionHelper.java:1268)
~[hk2-utils-2.6.1.jar:?]
at
org.jvnet.hk2.internal.MethodInterceptorHandler$MethodInvocationImpl.proceed(MethodInterceptorHandler.java:164)
~[hk2-locator-2.6.1.jar:?]
at
org.apache.gravitino.server.web.filter.BaseMetadataAuthorizationMethodInterceptor.invoke(BaseMetadataAuthorizationMethodInterceptor.java:212)
~[gravitino-iceberg-rest-server-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.jvnet.hk2.internal.MethodInterceptorHandler.invoke(MethodInterceptorHandler.java:97)
~[hk2-locator-2.6.1.jar:?]
at
org.apache.gravitino.iceberg.service.rest.IcebergViewOperations_$$_jvst20e_2.createView(IcebergViewOperations_$$_jvst20e_2.java)
~[gravitino-iceberg-rest-server-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[?:?]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?]
at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
at
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
~[jersey-server-2.41.jar:?]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:146)
~[jersey-server-2.41.jar:?]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:189)
~[jersey-server-2.41.jar:?]
at
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176)
~[jersey-server-2.41.jar:?]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:93)
~[jersey-server-2.41.jar:?]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:478)
~[jersey-server-2.41.jar:?]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:400)
~[jersey-server-2.41.jar:?]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)
~[jersey-server-2.41.jar:?]
at
org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:256)
~[jersey-server-2.41.jar:?]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
~[jersey-common-2.41.jar:?]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
~[jersey-common-2.41.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
~[jersey-common-2.41.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
~[jersey-common-2.41.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
~[jersey-common-2.41.jar:?]
at
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
~[jersey-common-2.41.jar:?]
at
org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:235)
~[jersey-server-2.41.jar:?]
at
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684)
~[jersey-server-2.41.jar:?]
at
org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)
~[jersey-container-servlet-core-2.41.jar:?]
at
org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)
~[jersey-container-servlet-core-2.41.jar:?]
at
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:358)
~[jersey-container-servlet-core-2.41.jar:?]
at
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:311)
~[jersey-container-servlet-core-2.41.jar:?]
at
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
~[jersey-container-servlet-core-2.41.jar:?]
at
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1656)
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.apache.gravitino.server.authentication.AuthenticationFilter.lambda$doFilter$0(AuthenticationFilter.java:96)
~[gravitino-server-common-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:712)
~[?:?]
at java.base/javax.security.auth.Subject.doAs(Subject.java:439) ~[?:?]
at
org.apache.gravitino.utils.PrincipalUtils.doAs(PrincipalUtils.java:53)
~[gravitino-core-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.server.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:93)
~[gravitino-server-common-1.3.0-SNAPSHOT-1.0.0-SNAPSHOT.jar:?]
at
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:552)
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440)
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:505)
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355)
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at org.eclipse.jetty.server.Server.handle(Server.java:516)
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)
[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479)
[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
at
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
at java.base/java.lang.Thread.run(Thread.java:840) [?:?]
```
### How to reproduce
1. Trino using the remote IRC catalog, run the sqls as following:
```
CREATE SCHEMA remote_irc.test;
CREATE TABLE remote_irc.test.employees (
emp_id INTEGER,
name VARCHAR,
department VARCHAR,
salary DOUBLE,
hire_date DATE
);
INSERT INTO remote_irc.test.employees (emp_id, name, department, salary,
hire_date)
VALUES
(1, 'Alice', 'Sales', 55000.0, DATE '2022-01-15'),
(2, 'Bob', 'Engineering', 75000.0, DATE '2021-06-10'),
(3, 'Charlie', 'Sales', 62000.0, DATE '2023-03-20'),
(4, 'David', 'Marketing', 48000.0, DATE '2022-11-05');
CREATE OR REPLACE VIEW remote_irc.test.sales_performance_view AS
SELECT
name,
salary,
salary * 0.1 AS expected_bonus,
hire_date
FROM remote_irc.test.employees
WHERE department = 'Sales';
```
### 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]
