Questions tagged [presto]

Presto is an open source distributed SQL query engine for running analytic queries against data sources of all sizes ranging from gigabytes to petabytes. The community version of Presto is now called Trino. Amazon serverless query service called Athena is using Presto under the hood.

What is Presto?

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

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 organizations like Facebook.

What can it do?

Presto allows querying data where it lives, including Hive, HBase, relational databases or even proprietary data stores. A single Presto query can combine data from multiple sources, allowing for analytics across your entire organization.

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

References

3114 questions
1
vote
1 answer

Does prestodb's MysqlConnector use mysql execution engine?

From the documentation I understand that Presto does not use Hive execution environment. Is this the case for other connectors as well like Mysql? What happens when I do a "select sum(col) from mysql_table" through prestodb? Does prestodb loads…
amrk7
  • 1,194
  • 5
  • 13
  • 33
1
vote
1 answer

Maven: missing artifact presto

I want add a new dependency into pom.xml. The eclipse shows the error: "Missing artifact presto:presto-jdbc:jar: 0.93" I have tried to force update of snapshot. No fix. mysql
Hao Wu
  • 143
  • 1
  • 11
1
vote
1 answer

Presto - Query ... No worker nodes available

Using Amazon EMR, Hive .13, Hadoop 2.x, and Presto Server 0.89. Trying to set up Presto to query data that is usually queried through Hive. Hive metadata is stored in MySQL. Presto Server is installed set up on all nodes. For the most part…
DJElbow
  • 3,345
  • 11
  • 41
  • 52
1
vote
1 answer

presto No factory for connector mysql

I clone presto from github and build the project. But when I tried to run PrestoServer, an exception was thrown as java.lang.IllegalArgumentException: No factory for connector mysql. The detailed output as follow: 2014-12-10T16:48:31.617+0800 …
1
vote
1 answer

Makefile Error on line 14: expecting target : dependencies

I'm unable to run a Makefile of a project I downloaded (Presto's ODBC Driver). When I run the make command I get the following error: Daniel@Daniel-Laptop /cygdrive/c/TEMP/presto-odbc-master $ make clean install Error on line 14: expecting target :…
Daniel Haviv
  • 1,036
  • 8
  • 16
1
vote
1 answer

Unable to connect to Cassandra in Presto

I have setup Cassandra, and I've created a keyspace('mykeyspace') and a table in it. I started Cassandra as a service, added the cassandra.properties file like this, in the presto installation…
Nishanth Reddy
  • 589
  • 2
  • 14
  • 27
1
vote
1 answer

which Hadoop component can handle all the oracle queries.?

Which hadoop component can handle all the oracle functions & which has low latency.. Am thinking to use the components like Presto, Drill and Shark.. Can anyone tell which of the above technology can handle all the functions in oracle with low…
Pavan Chakravarthy
  • 573
  • 4
  • 7
  • 16
1
vote
1 answer

connecting both hive & cassandra to presto at same time

Is there any possible way to connect both hive & cassandra at same time if I have the same database name.? I need to access the tables that are in hive databse & cassandra keyspace in the same time.. Thanks & regards Pavan Chakravarthy
Pavan Chakravarthy
  • 573
  • 4
  • 7
  • 16
1
vote
1 answer

Can PrestoDB connect to the relational databases like Oracle?

If presto is able to connect Oracle or Mysql please tell me how to connect. hadoop 2.1.1 hive 0.12.0 presto 0.65 java jdk 7 oracle 10g
Tirthankar
  • 75
  • 1
  • 9
1
vote
1 answer

How do I compute row-wise minimum (least) in prestodb?

I am trying to get the minimum of a couple of fields within a row with presto. In other SQL implementations like MySql this function is called LEAST. What is the equivalent function in Presto?
unique2
  • 2,162
  • 2
  • 18
  • 23
1
vote
1 answer

Presto group by distinct values in hive array

In hive you can group on distinct values in an Hive array like this: SELECT i, count(distinct cookieID) as unique_visitor, count(*) as impressions FROM table LATERAL VIEW explode(interests) interestTable AS i GROUP BY i; How can you achieve the…
darkownage
  • 938
  • 16
  • 38
1
vote
1 answer

Questions about Hadoop And Hive And Presto

I am looking into using Hive on our Hadoop cluster to then use Presto to do some analytics on the data stored in Hadoop but I am still confused about some things: Files are stored in Hadoop (some kind of file manager) Hive needs tables to store…
darkownage
  • 938
  • 16
  • 38
1
vote
3 answers

running presto-cli warnning:SerDe org.apache.hadoop.hive.contrib.serde2.RegexSerDe does not exist

Deploy the presto on single node . when running Presto-cli ,i got following errors: presto:default> select * from test1; Query 20131116_233859_00005_5a2yh failed: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe…
user2986668
  • 33
  • 1
  • 6
1
vote
1 answer

Does Presto support RC file with snappy compression?

Trying to read snappy compressed table using Presto on CDH4 cluster. Hive can read the table, but Presto complains about missing native library. Adding java.library.path from CDH doesn't seem to help. (added to…
Igor Semenko
  • 459
  • 1
  • 7
  • 18
1
vote
1 answer

Issue when issuing a SELECT query to a Hive table in Prestodb

I am able to connect to my Hive metastore, and doing a DESCRIBE: DESCRIBE sample_07; Query 20131113_025614_00005_af2fx, RUNNING, 1 node, 2 splits Column | Type | Null | Partition Key -------------+---------+------+--------------- code …
matthieu lieber
  • 662
  • 1
  • 17
  • 30
1 2 3
99
100