Questions tagged [trino]

Trino is an open source distributed SQL query engine for running analytic queries against data sources of all sizes ranging from gigabytes to petabytes. Trino is the community version of Presto, and emerged from the rename of the PrestoSQL codebase.

What is Trino?

Trino is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.

Trino, formerly Presto, was designed and written from the ground up for interactive analytics and approaches the speed of commercial data warehouses while scaling to the size of very large organizations.

What can it do?

Trino allows querying data where it lives, including HDFS/Hive, object storage systems like S3, Iceberg, Delta Lake, many relational databases, NoSQL/document databases, and even proprietary data stores. A single Trino query, written in standard SQL, can combine data from multiple sources, allowing for analytics across your entire organization.

Trino is targeted at analysts who expect response times ranging from sub-second to minutes. Trino breaks the false choice between having fast analytics using an expensive commercial solution or using a slow "free" solution that requires excessive hardware.

The massively parallel processing design of Trino allows very high performance, and horizontal scaling to adjust to your needs.

References

680 questions
0
votes
1 answer

Sqoop Presto using Tetadata Presto Driver - ParseError

I am trying to ingest data from Presto database using Hadoop Sqoop which is throwing this error in Presto : 18/07/12 10:34:05 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection. 18/07/12 10:34:06…
Sudheer Palyam
  • 2,499
  • 2
  • 23
  • 28
0
votes
1 answer

Presto SocketTimeoutException

am trying to execute presto queries from a presto-cli and I am getting the following error [hadoop@ip-172-16-125-74 ~]$ presto-cli --debug presto> show schemas from hive.default; Error running command: java.net.SocketTimeoutException:…
nnc
  • 790
  • 2
  • 14
  • 31
0
votes
1 answer

Presto integration with MSSQL

I'm looking for a tutorial or something that allow me to learn Presto step by step. The idea is to start integrating file's and MSSQL, which is my knowledge area. Unfortunately, since it is a relatively new area, I didn't find anything more than…
HernanG
  • 1
  • 2
-1
votes
0 answers

Regex - Group two matches into one array output

I have a trino table with a multilevel JSON like column, which is dynamic (hence why I don't just parse it). I am looking to match to values, and group them. Yet there are different values in between. For instance, the JSON might look like…
-1
votes
0 answers

Trino using k8’s

I had deployed Trino using helm on k8's cluster. After that I have added catalogs for MySQL and MongoDB. You can see catalogs for MongoDB AdditionalCatalogs: Mongodb |- Connector.name=mongodb …
-1
votes
2 answers

Presto SQL Exploding Array to rows (but randomly sampled 100 rows)

I have a huge table with an array column. I know the code to explode array to rows, however, I only want to explode the array to get 100 rows and stop - trying to save on compute cost of the query. Any suggestions? SELECT * FROM ( SELECT …
Pratibha UR
  • 116
  • 7
-1
votes
1 answer

Converting timezone sql

Using the following query to convert the timezone. My table was originally in PDT, and I need to convert it to Eastern time. SELECT DATE_FORMAT( CAST( CONCAT( CAST(year as VARCHAR) '-', CAST(month as VARCHAR) '-', …
koch
  • 107
  • 7
-1
votes
1 answer

Error Invalid maximum heap size: -Xmx8192m Error: Could not create the Java Virtual Machine. Error: A fatal exception has occurred. Program will exit

I am new to Trino, i did the clone of the code source of Trino from github : https://github.com/trinodb/trino and I get this error : Invalid maximum heap size: -Xmx8192m Error: Could not create the Java Virtual Machine. Error: A fatal exception has…
-1
votes
1 answer

SQL to get overall average by aggregation

I have a following table employerid userid 123 1321 121 1567 126 1321 I want to write an SQL where I want overall average number of employerid per user id For example userid 1321 - 2 employerids (123 and 126) userid…
Mikasa
  • 321
  • 7
  • 16
-1
votes
1 answer

In Trino (Presto) SQL, how do you convert an array of characters (char) into a varchar (string)?

I want to take an array of characters, for example, ['t','e','s','t',''] and turn it into a string; in this case 'test'.
Will Fitzgerald
  • 1,372
  • 10
  • 14
-1
votes
1 answer

In Trino (Presto) SQL, how do you convert a varchar (string) to an array of characters (char)?

I want to create a array of characters from a varchar field. For example, from 'test', I want to have ARRAY['t', 'e', 's', 't'].
Will Fitzgerald
  • 1,372
  • 10
  • 14
-1
votes
1 answer

How to add session properties of presto in spark

Is there any way to set session parameters of presto in spark, while building a Dataframe out of it. public Dataset readPrestoTbl(){ Dataset stgTblDF = sparksession .read() …
Kalpesh
  • 694
  • 2
  • 8
  • 28
-1
votes
1 answer

mismatched input 'OVERWRITE'. Expecting: 'INTO'

I have a hive table with schema CREATE TABLE `temp_table`( `gpid` string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION 'wasbs://test@test.blob.core.windows.net/warehouse/test_data'; I am using airflow2 to add data…
SHIVAM JINDAL
  • 2,844
  • 1
  • 17
  • 34
-1
votes
1 answer

How to take previous non-null value in sequence?

DB is Presto. Say I have a table {id dim1, dim2, seq, value}. seq is the sequence number for for value, and value contains NULLs. I have: select id, dim1, dim2, seq, value, "value_backfilled" -- Want to compute this from table group by id, dim1,…
drum
  • 5,416
  • 7
  • 57
  • 91
-1
votes
1 answer

Column populated with table string occurrences joined to original SQL table

I would like to query for a table that shows me my raw data as well as a column that counts the occurrences of a value ('ID') subject to a conditions ('Type' NOT LIKE…
big_soapy
  • 137
  • 7
1 2 3
45
46