trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.49k stars 3.02k forks source link

unable to Connect Hudi from Trino in GCS #22349

Closed Pavan792reddy closed 5 months ago

Pavan792reddy commented 5 months ago

hi Team , iam trying to connect hudi from trino in GCP environment and i am getting the below after configuring the hudi property file .

Trino Version:- 376

2024-06-10T14:48:54.219Z ERROR main io.trino.server.Server No factory for connector 'hudi'. Available factories: [hive, memory, kudu, blackhole, kinesis, redis, accumulo, gsheets, raptor-legacy, elasticsearch, jmx, postgresql, redshift, sqlserver, localfile, tpch, iceberg, mysql, bigquery, prometheus, memsql, mongodb, example-http, pinot, tpcds, oracle, trino-thrift, delta-lake, phoenix, system, druid, cassandra, clickhouse, kafka, singlestore, atop, hive-hadoop2, phoenix5] java.lang.IllegalArgumentException: No factory for connector 'hudi'. Available factories: [hive, memory, kudu, blackhole, kinesis, redis, accumulo, gsheets, raptor-legacy, elasticsearch, jmx, postgresql, redshift, sqlserver, localfile, tpch, iceberg, mysql, bigquery, prometheus, memsql, mongodb, example-http, pinot, tpcds, oracle, trino-thrift, delta-lake, phoenix, system, druid, cassandra, clickhouse, kafka, singlestore, atop, hive-hadoop2, phoenix5] at com.google.common.base.Preconditions.checkArgument(Preconditions.java:435) at io.trino.connector.ConnectorManager.createCatalog(ConnectorManager.java:226) at io.trino.metadata.StaticCatalogStore.loadCatalog(StaticCatalogStore.java:88) at io.trino.metadata.StaticCatalogStore.loadCatalogs(StaticCatalogStore.java:68) at io.trino.server.Server.doStart(Server.java:128) at io.trino.server.Server.lambda$start$0(Server.java:80) at io.trino.$gen.Trino_376____20240610_144837_1.run(Unknown Source) at io.trino.server.Server.start(Server.java:80) at io.trino.server.TrinoServer.main(TrinoServer.java:38)

2024-06-10T14:48:54.220Z INFO Thread-76 io.airlift.bootstrap.LifeCycleManager JVM is shutting down, cleaning up root@trino-test-m:/var/log/trino#

nineinchnick commented 5 months ago

The Hudi connector was added in 398: https://trino.io/docs/current/release/release-398.html

Pavan792reddy commented 5 months ago

thanks @nineinchnick

Pavan792reddy commented 5 months ago

hi @nineinchnick we have installed [432] version of trino to read the data from hudi and able to connect the HUDI , currently we are facing slowness issues the query is in starting state for more than 30 mins .

Pavan792reddy commented 5 months ago

trino:default> select id from avroschema_20 ;

Query 20240621_095702_00003_b6fir, STARTING, 0 nodes, 0 splits

nineinchnick commented 5 months ago

This issue is closed and you're describing a different problem. Please start a thread on Slack. Open another issue if you can confirm this is a problem with Trino, and not your configuration.