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
3
votes
1 answer

Google Dataproc Presto: how to run queries using Python

I have set up a Google Dataproc cluster running Presto by going through the steps in this link. It works fine and I am able to run queries through gcloud command-line tool as shown on the link like this. gcloud dataproc jobs submit hive \ …
3
votes
1 answer

Presto: cast an integer array to string?

I have the following table: my_id, my_array 1 , [5, 6, 3] 2 , [1, 5] 3. , [6, 7, 5] Would it be possible to do a cast such that the output table would be something like: my_id, my_str 1 , "5,6,3" 2 , "1,5" 3. , "6,7,5" Or if there…
Edamame
  • 23,718
  • 73
  • 186
  • 320
3
votes
0 answers

SQL query for DAU/WAU/MAU using Presto SQL in AWS Athena

I'm trying to create a query in AWS Athena to get the DAU, WAU and MAU (Daily, Weekly, and Monthly Active Users) values. I was able to create the dau query select date(from_unixtime(time / 1000)) as date, count(distinct id) as dau from…
eduardoftdo
  • 382
  • 3
  • 13
3
votes
2 answers

Superset picking Timestamp type of Trino tables as UNKNOWN

Trino (formerly known as Presto SQL) Version - 341 SuperSet Version - 0.37.2 I have a table in Trino that has 1250 columns. 118 of these columns are timestamp type. When I add this table under Sources -> Tables -> Add a new record, all these…
Cheater
  • 435
  • 1
  • 4
  • 16
3
votes
1 answer

Connecting Presto and Apache SuperSet

I have presto and apache superset hosted at GCP Cloud. Presto server hosted at http://14.22.122.12:8088/ui/ But when i try to connect Presto to Superset it's giving me this error Could not load database driver: presto Already installed the presto…
Bad Coder
  • 866
  • 1
  • 12
  • 27
3
votes
1 answer

Presto Rest API [ in Presto version 333]

In the older version of Presto it was easy to access http://localhost:8080/v1/query/ URL either get or post. In Presto version 333 when same URL try to access it will give error as MESSAGE: Method Not Allowed [STATUS:405] even if we try to send POST…
3
votes
1 answer

How to specify SERDEPROPERTIES and TBLPROPERTIES when creating Hive table via prestosql

I'm trying to follow the examples of Hive connector to create hive table. I can write HQL to create a table via beeline. But wonder how to make it via prestosql. Given table CREATE TABLE hive.web.request_logs ( request_time varchar, url…
shawnzhu
  • 7,233
  • 4
  • 35
  • 51
3
votes
2 answers

How to count occurrences of a character in a string in Presto?

I am trying to find the number of frequency of a character in a string in Presto. like 129.11.20.0 and I wan to find number of dot . in this string. just wondering if any function available
Zaynul Abadin Tuhin
  • 31,407
  • 5
  • 33
  • 63
3
votes
2 answers

32- or 64-bits float division with PrestoSQL

In Presto SQL, SELECT 1 / 3 returns 0, because / performs integer division. But SELECT 1.0 / 3 returns 0.3... How can I get 0.3333333333? (i.e., more specifically, 32- or 64-bits precision instead of first decimal truncation?)
Roméo Després
  • 1,777
  • 2
  • 15
  • 30
3
votes
2 answers

Presto DB + what we can do in case of some presto workers are down + auto start

Dear friends and college we installed presto cluster as the follwing 1 presto coordinator 320 presto workers we are satisfied with the Presto performance , and the presto User interface is impressive how ever we notice that presto coordinator…
Judy
  • 1,595
  • 6
  • 19
  • 41
3
votes
1 answer

Presto-Glue-EMR integration: presto-cli giving NullPointerException

I am trying to connect my Glue catalog to Presto and Hive in EMR. While running the queries in presto-cli, I am getting NullPointerException whereas the same query succeeds in hive-cli. Started the cli like below presto-cli --catalog hive Exception…
ishan3243
  • 1,870
  • 4
  • 30
  • 49
3
votes
1 answer

Exception while build presto

I am geeting following exception while build presto, [ERROR] Failed to execute goal io.airlift.maven.plugins:sphinx-maven-plugin:2.0:generate (default) on project presto-docs: Failed to run the report: Sphinx report generation failed -> [Help…
3
votes
1 answer

Parameterized SQL in Presto on Presto CLI

Is there any option to provide parameters on Presto CLI. I am trying to change my impala-shell command to Presto where my HQL file gets parameter from command line of impala like below. impala-shell -f ot_full.hql --var=date_next=${date_next_para}…
Shawn
  • 537
  • 3
  • 7
  • 16
3
votes
2 answers

Reference to a field of a row object

I'm having trouble accessing the fields of row objects which I have created in Presto. The Presto documentation claims "fields... are accessed with field reference operator." However that doesn't seem to work. This code reproduces the…
Wilbur
  • 457
  • 1
  • 5
  • 14
3
votes
2 answers

Run Presto on JDK 6

I tried to run the launcher but encountered this error: Exception in thread "main" java.lang.UnsupportedClassVersionError: sun/misc/FloatingDecimal : Unsupported major.minor version 51.0 at java.lang.Double.toString(Double.java:196) at…
Ngoc Tran
  • 1,361
  • 3
  • 11
  • 8