# Trino **URL:** https://www.starburst.io/community/forum/c/trino/7.md?page=1 [Latest](https://www.starburst.io/community/forum/latest.md) · [Categories](https://www.starburst.io/community/forum/categories.md) · [Tags](https://www.starburst.io/community/forum/tags.md) **Page:** 2 --- ## [Are there any parallelism and throughput advantages to running multiple workers on the same docker host?](https://www.starburst.io/community/forum/t/are-there-any-parallelism-and-throughput-advantages-to-running-multiple-workers-on-the-same-docker-host/414)
**Author:** [@TrinoSlackHighlights](https://www.starburst.io/community/forum/u/TrinoSlackHighlights)\ **Replies:** 1\ **Last updated:** [August 16, 2023, 5:06pm UTC](https://www.starburst.io/community/forum/t/are-there-any-parallelism-and-throughput-advantages-to-running-multiple-workers-on-the-same-docker-host/414 "2023-08-16T17:06:39Z")
Or is there a way to increase the threads a single worker uses? --- ## [Read External Location Using Trino + Iceberg + Postgress](https://www.starburst.io/community/forum/t/read-external-location-using-trino-iceberg-postgress/413)
**Author:** [@sunin312](https://www.starburst.io/community/forum/u/sunin312)\ **Replies:** 1\ **Last updated:** [August 15, 2023, 5:18pm UTC](https://www.starburst.io/community/forum/t/read-external-location-using-trino-iceberg-postgress/413 "2023-08-15T17:18:24Z")
Hi; I am trying to read data from AZ-ADLS-GEN2, using TRINO; DATA stored via SPARK + ICEBERG using ICEBERG-JDBC-CATALOG. Can any one guide; is there any way we can configure the AZ-STORAGE access while using ICEBERG-JDB… --- ## [Can Trino run on GPUs?](https://www.starburst.io/community/forum/t/can-trino-run-on-gpus/356)
**Author:** [@TrinoSlackHighlights](https://www.starburst.io/community/forum/u/TrinoSlackHighlights)\ **Replies:** 2\ **Last updated:** [August 10, 2023, 10:29pm UTC](https://www.starburst.io/community/forum/t/can-trino-run-on-gpus/356 "2023-08-10T22:29:16Z")
If I have servers with good, modern GPUs, is there a way to configure Trino to leverage that? --- ## [Is there a way for me to add secrets into a helm chart yaml?](https://www.starburst.io/community/forum/t/is-there-a-way-for-me-to-add-secrets-into-a-helm-chart-yaml/399)
**Author:** [@TrinoSlackHighlights](https://www.starburst.io/community/forum/u/TrinoSlackHighlights)\ **Replies:** 2\ **Last updated:** [August 10, 2023, 8:30pm UTC](https://www.starburst.io/community/forum/t/is-there-a-way-for-me-to-add-secrets-into-a-helm-chart-yaml/399 "2023-08-10T20:30:10Z")
I am trying to add a new catalog to my helm chart but I am having some issues. I am using the official helm chart to add a new Postgres catalog to Trino. The issue I am having that is the password and the user to postgre… --- ## [If I have two Trino worker servers with different amounts of memory, does the coordinator account for this and send more memory intense work to the larger server?](https://www.starburst.io/community/forum/t/if-i-have-two-trino-worker-servers-with-different-amounts-of-memory-does-the-coordinator-account-for-this-and-send-more-memory-intense-work-to-the-larger-server/401)
**Author:** [@TrinoSlackHighlights](https://www.starburst.io/community/forum/u/TrinoSlackHighlights)\ **Replies:** 1\ **Last updated:** [August 10, 2023, 3:22pm UTC](https://www.starburst.io/community/forum/t/if-i-have-two-trino-worker-servers-with-different-amounts-of-memory-does-the-coordinator-account-for-this-and-send-more-memory-intense-work-to-the-larger-server/401 "2023-08-10T15:22:27Z")
If, say, I have a worker with 16GB memory and one with 128GB memory, would the coordinator realize this and send most of the work to the 128GB worker? --- ## [Should I setup a single global Hive metastore or multiple ones (one for Hive, one for Iceberg, etc.)?](https://www.starburst.io/community/forum/t/should-i-setup-a-single-global-hive-metastore-or-multiple-ones-one-for-hive-one-for-iceberg-etc/400)
**Author:** [@TrinoSlackHighlights](https://www.starburst.io/community/forum/u/TrinoSlackHighlights)\ **Replies:** 1\ **Last updated:** [August 10, 2023, 3:20pm UTC](https://www.starburst.io/community/forum/t/should-i-setup-a-single-global-hive-metastore-or-multiple-ones-one-for-hive-one-for-iceberg-etc/400 "2023-08-10T15:20:04Z")
What is usually done? --- ## [Considering swapping to Trino from Dremio, some questions](https://www.starburst.io/community/forum/t/considering-swapping-to-trino-from-dremio-some-questions/394)
**Author:** [@TrinoSlackHighlights](https://www.starburst.io/community/forum/u/TrinoSlackHighlights)\ **Replies:** 1\ **Last updated:** [August 9, 2023, 2:17pm UTC](https://www.starburst.io/community/forum/t/considering-swapping-to-trino-from-dremio-some-questions/394 "2023-08-09T14:17:34Z")
We’re currently using Dremio to fulfill our data lake querying needs and use it to ingest data from CSVs and Parquets on S3. We’re running into some constraints and thinking about switching to a tool like Trino but had … --- ## [Change zstd compression level?](https://www.starburst.io/community/forum/t/change-zstd-compression-level/393)
**Author:** [@TrinoSlackHighlights](https://www.starburst.io/community/forum/u/TrinoSlackHighlights)\ **Replies:** 1\ **Last updated:** [August 9, 2023, 2:12pm UTC](https://www.starburst.io/community/forum/t/change-zstd-compression-level/393 "2023-08-09T14:12:59Z")
How I can change the default zstd compression level when I create Iceberg tables using Trino? --- ## [I want to save more queries in the UI, but I'm worried about memory](https://www.starburst.io/community/forum/t/i-want-to-save-more-queries-in-the-ui-but-im-worried-about-memory/392)
**Author:** [@TrinoSlackHighlights](https://www.starburst.io/community/forum/u/TrinoSlackHighlights)\ **Replies:** 1\ **Last updated:** [August 9, 2023, 2:09pm UTC](https://www.starburst.io/community/forum/t/i-want-to-save-more-queries-in-the-ui-but-im-worried-about-memory/392 "2023-08-09T14:09:33Z")
I am considering increasing parameters such as query.max-history to extend the duration that a query is displayed in the Trino web UI. However, due to the huge number of queries issued by users, the memory needed to keep… --- ## [What is the difference between a user and a role?](https://www.starburst.io/community/forum/t/what-is-the-difference-between-a-user-and-a-role/359)
**Author:** [@TrinoSlackHighlights](https://www.starburst.io/community/forum/u/TrinoSlackHighlights)\ **Replies:** 1\ **Last updated:** [July 26, 2023, 11:35pm UTC](https://www.starburst.io/community/forum/t/what-is-the-difference-between-a-user-and-a-role/359 "2023-07-26T23:35:11Z")
How can I create each one? I saw the syntax for CREATE ROLE but I didn’t find the syntax to create a user. --- ## [Is calling MySQL stored procedures via query passthrough currently supported?](https://www.starburst.io/community/forum/t/is-calling-mysql-stored-procedures-via-query-passthrough-currently-supported/357)
**Author:** [@TrinoSlackHighlights](https://www.starburst.io/community/forum/u/TrinoSlackHighlights)\ **Replies:** 1\ **Last updated:** [July 26, 2023, 11:29pm UTC](https://www.starburst.io/community/forum/t/is-calling-mysql-stored-procedures-via-query-passthrough-currently-supported/357 "2023-07-26T23:29:44Z")
We have a lot of legacy stored procedures in MySQL, but haven’t had any luck calling stored procedures using the mysql connector’s .system.query() table function. --- ## [Discover schema form mongodb to Trino](https://www.starburst.io/community/forum/t/discover-schema-form-mongodb-to-trino/245)
**Author:** [@IvanHernanaz](https://www.starburst.io/community/forum/u/IvanHernanaz)\ **Replies:** 1\ **Last updated:** [July 26, 2023, 11:12pm UTC](https://www.starburst.io/community/forum/t/discover-schema-form-mongodb-to-trino/245 "2023-07-26T23:12:00Z")
Hello, We have a database in mongodb whose collections have arrays of objects (JSON), arrays of ObjectIds and their fields of ObjecIid´s. When we connect Mongodb with Trino all those fields are not recognized. How cou… --- ## [Why does Trino require HTTPS for user/pass? (the answer may surprise you)](https://www.starburst.io/community/forum/t/why-does-trino-require-https-for-user-pass-the-answer-may-surprise-you/81)
**Author:** [@Minnesota\_Cold](https://www.starburst.io/community/forum/u/Minnesota_Cold)\ **Replies:** 0\ **Last updated:** [October 20, 2021, 4:54am UTC](https://www.starburst.io/community/forum/t/why-does-trino-require-https-for-user-pass-the-answer-may-surprise-you/81 "2021-10-20T04:54:43Z")
One of the questions that gets asked by people first starting out with Trino is “why does it require HTTPS for enabling username AND passwords?” This is debated quite a bit, but, if you think about how your username/pas… --- ## [Is there a way to dump plans for previously executed queries and view the last several days/week after execution?](https://www.starburst.io/community/forum/t/is-there-a-way-to-dump-plans-for-previously-executed-queries-and-view-the-last-several-days-week-after-execution/52)
**Author:** [@system](https://www.starburst.io/community/forum/u/system)\ **Replies:** 5\ **Last updated:** [July 24, 2023, 5:01pm UTC](https://www.starburst.io/community/forum/t/is-there-a-way-to-dump-plans-for-previously-executed-queries-and-view-the-last-several-days-week-after-execution/52 "2023-07-24T17:01:52Z")
This question was originally asked on the Trino Slack. Hi everyone, Is there any example code/blog/documentation regarding how we can dump plans for previously executed queries and view it from UI several days/week aft… --- ## [General recommendations for JDK Version on Trino Servers](https://www.starburst.io/community/forum/t/general-recommendations-for-jdk-version-on-trino-servers/34)
**Author:** [@system](https://www.starburst.io/community/forum/u/system)\ **Replies:** 2\ **Last updated:** [July 20, 2023, 9:38pm UTC](https://www.starburst.io/community/forum/t/general-recommendations-for-jdk-version-on-trino-servers/34 "2023-07-20T21:38:21Z")
A while back, we got this question in on the Trino Community Broadcast: Why is Java 11 needed in the newer version of Trino and how do I get the older version of Trino as I need the 328 latest on Java 8 as Java 11 isn’t… --- ## [Questions about information\_schema table](https://www.starburst.io/community/forum/t/questions-about-information-schema-table/162)
**Author:** [@Harold](https://www.starburst.io/community/forum/u/Harold)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 9:24pm UTC](https://www.starburst.io/community/forum/t/questions-about-information-schema-table/162 "2023-07-20T21:24:21Z")
We use Trino to connect to HDFS. I discovered that the data in the information schema, for example select \* from information\_schema.columns clz where clz.table\_catalog = ‘hive’ and clz.table\_schema = ‘\ **Author:** [@Vatz](https://www.starburst.io/community/forum/u/Vatz)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 9:20pm UTC](https://www.starburst.io/community/forum/t/streaming-of-partial-results-in-chunks-to-improve-ttfb/194 "2023-07-20T21:20:32Z") Hello, Does the Trino engine provide the ability to push the results of a query to the client side even though the execution has not been fully computed by the executors? Example: SELECT C1, C2, C3 from TABLE1 order b… --- ## [AggregatePushDown:SUM not working in MYSQL connctor](https://www.starburst.io/community/forum/t/aggregatepushdown-sum-not-working-in-mysql-connctor/197)
**Author:** [@masayyed](https://www.starburst.io/community/forum/u/masayyed)\ **Replies:** 3\ **Last updated:** [July 20, 2023, 9:17pm UTC](https://www.starburst.io/community/forum/t/aggregatepushdown-sum-not-working-in-mysql-connctor/197 "2023-07-20T21:17:57Z")
We are using trino version 377 We are trying to pushdown aggregates on mysql database. All aggregates working fine except sum. Could you please help us to fix this issue. Is there any specific config required to use SU… --- ## [Trino reactive JDBC driver](https://www.starburst.io/community/forum/t/trino-reactive-jdbc-driver/188)
**Author:** [@zoli](https://www.starburst.io/community/forum/u/zoli)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 9:13pm UTC](https://www.starburst.io/community/forum/t/trino-reactive-jdbc-driver/188 "2023-07-20T21:13:40Z")
I’m testing the Trino JDBC driver and I was wondering if it implements the reactive, non-blocking APIs. For reference, please check https://r2dbc.io. Are there any plans to implement a reactive, non-blocking driver for… --- ## [No Nodes available to run query](https://www.starburst.io/community/forum/t/no-nodes-available-to-run-query/275)
**Author:** [@FerVH26](https://www.starburst.io/community/forum/u/FerVH26)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 9:12pm UTC](https://www.starburst.io/community/forum/t/no-nodes-available-to-run-query/275 "2023-07-20T21:12:16Z")
I’m conducting a Trino test on an EMR cluster, in which I’ve used m6i.2xlarge instances for the master and 4 slaves. I’ve connected this Trino server to a Glue data catalog, and I can successfully view the data catalog f… --- ## [Column with date datatype and format specification in Elasticsearch get skipped](https://www.starburst.io/community/forum/t/column-with-date-datatype-and-format-specification-in-elasticsearch-get-skipped/204)
**Author:** [@Mangesh6.Patil](https://www.starburst.io/community/forum/u/Mangesh6.Patil)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 9:09pm UTC](https://www.starburst.io/community/forum/t/column-with-date-datatype-and-format-specification-in-elasticsearch-get-skipped/204 "2023-07-20T21:09:44Z")
Hello Team, We are trying to read few columns from ELK index and we are able to read columns with datatype int, bigint, long, varchar, date (default ELK format) properly, but while selecting column with datatype date an… --- ## [What is the class object in Trino API which stores the query result?](https://www.starburst.io/community/forum/t/what-is-the-class-object-in-trino-api-which-stores-the-query-result/220)
**Author:** [@FarhanShirgill](https://www.starburst.io/community/forum/u/FarhanShirgill)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 9:07pm UTC](https://www.starburst.io/community/forum/t/what-is-the-class-object-in-trino-api-which-stores-the-query-result/220 "2023-07-20T21:07:35Z")
In Trino, as per the oreilly-trino-guide, the coordinator talks to workers to assign work, update status, and fetch the top-level result set to return to the users. I want to know the class object which stores the query… --- ## [java.util.concurrent.ExecutionException: java.io.UncheckedIOException: javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake\_failure](https://www.starburst.io/community/forum/t/java-util-concurrent-executionexception-java-io-uncheckedioexception-javax-net-ssl-sslhandshakeexception-received-fatal-alert-handshake-failure/133)
**Author:** [@mzabrar](https://www.starburst.io/community/forum/u/mzabrar)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 8:59pm UTC](https://www.starburst.io/community/forum/t/java-util-concurrent-executionexception-java-io-uncheckedioexception-javax-net-ssl-sslhandshakeexception-received-fatal-alert-handshake-failure/133 "2023-07-20T20:59:20Z")
we are securing client access to the cluster by configuring self signed ssl for cordinator . follwing are the config.properties coordinator=true node-scheduler.include-coordinator=false http-server.http.port=8889 quer… --- ## [Trino encrypt and decrypt data](https://www.starburst.io/community/forum/t/trino-encrypt-and-decrypt-data/218)
**Author:** [@zeeshan](https://www.starburst.io/community/forum/u/zeeshan)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 8:52pm UTC](https://www.starburst.io/community/forum/t/trino-encrypt-and-decrypt-data/218 "2023-07-20T20:52:50Z")
We have a requirment in which we have to encrypt and decrypt data for underlining data sources using Trino . We want to use Microfocus voltage secure Data 6.9 for this encryption and decryption functioanlity . Does tr… --- ## [How to parse protobuf object in Kafka message by Trino](https://www.starburst.io/community/forum/t/how-to-parse-protobuf-object-in-kafka-message-by-trino/231)
**Author:** [@Giovarco](https://www.starburst.io/community/forum/u/Giovarco)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 8:52pm UTC](https://www.starburst.io/community/forum/t/how-to-parse-protobuf-object-in-kafka-message-by-trino/231 "2023-07-20T20:52:01Z")
Hello! I hope this is not the wrong section. If so, please move it :pray: I run Trino in a Docker container using this command and passing configuration files: sudo docker run -p 8080:8080 -v /mnt/c/trino-config-test… --- ## [Does Trino supports Microfocus voltage secure integration?](https://www.starburst.io/community/forum/t/does-trino-supports-microfocus-voltage-secure-integration/216)
**Author:** [@masayyed](https://www.starburst.io/community/forum/u/masayyed)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 8:49pm UTC](https://www.starburst.io/community/forum/t/does-trino-supports-microfocus-voltage-secure-integration/216 "2023-07-20T20:49:43Z")
Dears, We have implemented Microfocus voltage secure Data 6.9 for data encryption in our organization. We have all encrypted data at source side including HDFS, oracle, etc. Does Trino (hive and oracle) connector supp… --- ## [System.create\_empty\_partition](https://www.starburst.io/community/forum/t/system-create-empty-partition/248)
**Author:** [@shashideore](https://www.starburst.io/community/forum/u/shashideore)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 8:49pm UTC](https://www.starburst.io/community/forum/t/system-create-empty-partition/248 "2023-07-20T20:49:10Z")
We are creating a partitioned table with s3 as external\_location. table location has many partition folders already created. hive allows us to add selected partitions using ALTER TABLE my\_table ADD PARTITION (partkey… --- ## [Can trino read properties file at run-time instead of cache it into memory](https://www.starburst.io/community/forum/t/can-trino-read-properties-file-at-run-time-instead-of-cache-it-into-memory/258)
**Author:** [@heru](https://www.starburst.io/community/forum/u/heru)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 8:46pm UTC](https://www.starburst.io/community/forum/t/can-trino-read-properties-file-at-run-time-instead-of-cache-it-into-memory/258 "2023-07-20T20:46:49Z")
We will need to load the value dynamically from trino’s properties file, do you know where we can configure this way? --- ## [How can we keep DB session connected in trino?](https://www.starburst.io/community/forum/t/how-can-we-keep-db-session-connected-in-trino/195)
**Author:** [@masayyed](https://www.starburst.io/community/forum/u/masayyed)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 8:44pm UTC](https://www.starburst.io/community/forum/t/how-can-we-keep-db-session-connected-in-trino/195 "2023-07-20T20:44:03Z")
Hi, When I am running queries in trino, every time trino creates new connection session with database and closes it on query completion. While creating new session, it takes long time. Is there any way to to keep same… --- ## [CLI for loading resource groups configuration into a backing database](https://www.starburst.io/community/forum/t/cli-for-loading-resource-groups-configuration-into-a-backing-database/140)
**Author:** [@padraig](https://www.starburst.io/community/forum/u/padraig)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 8:24pm UTC](https://www.starburst.io/community/forum/t/cli-for-loading-resource-groups-configuration-into-a-backing-database/140 "2023-07-20T20:24:34Z")
We are testing out using the database-backed resource group manager but want to maintain resource groups configuration in a JSON file since we find it easier to work with and we can keep it in version control. Just want… [Previous page](https://www.starburst.io/community/forum/c/trino/7.md) [Next page](https://www.starburst.io/community/forum/c/trino/7.md?page=2)