forked from prestodb/prestodb.github.io
-
Notifications
You must be signed in to change notification settings - Fork 0
/
resources.html
550 lines (487 loc) · 22 KB
/
resources.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Presto | Resources</title>
<link rel="stylesheet" href="static/presto.css" type="text/css"/>
<meta name="viewport" content="width=device-width">
<meta property="og:type" content="website">
<meta property="og:title" content="Presto | Resources">
<meta property="og:description" content="Distributed SQL Query Engine for Big Data">
<meta property="og:image" content="static/presto-og.png">
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-82811140-44"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'UA-82811140-44');
</script>
</head>
<body>
<header class="topbar clearfix">
<nav class="width">
<a href="."><h1>Presto</h1></a>
<ul class="nav">
<li><a href="overview.html">About</a></li>
<li><a href="https://prestodb.github.io/docs/current/">Docs</a></li>
<li><a href="blog/index.html">Blog</a></li>
<li><a href="faq.html">FAQ</a></li>
<li><a href="community.html">Community</a></li>
<li><a href="resources.html">Resources</a></li>
<li><a href="join.html">Foundation</a>
<li><a href="https://github.com/prestodb/presto"><img height=20 src="./img/github.svg" alt="GitHub Octocat"></a>
</ul>
</nav>
</header>
<header class="hero clearfix">c
<div class="width">
<h1>Resources</h1>
</div>
</header>
<div class="content homecontent width clearfix">
<div class="leftcol widecol faq">
<h2 id="tutorials">Tutorials</h2>
<div class="item">
<h4>PrestoDB Sandbox on AWS</h4>
<dl>
<dt>Website</dt>
<dd><a href="https://aws.amazon.com/marketplace/pp/B08C21CGF6?ref_=srh_res_product_title" target="_blank">PrestoDB Sandbox AMI</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://ahana.io/" target="_blank">Ahana</a></dd>
<dt>Description</dt>
<dd>
Learn free open source Presto. Sandbox comes bundled with catalogs to try, test, and prototype Presto. See the 5 min tutorial on how to get started at <a href="https://ahana.io/tutorials/aws-sandbox/" target="_blank">https://ahana.io/tutorials/aws-sandbox/</a>
</dd>
</dl>
</div>
<h2 id="tools">Presto Management Tools</h2>
<div class="item">
<h4>Presto-Admin</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/prestodb/presto-admin">Presto-Admin</a></dd>
<dt>Description</dt>
<dd>
Presto-Admin is a tool for installing and managing the Presto
query engine on a cluster. It provides easy-to-use commands:
<p/>
<ul>
<li>Install and uninstall Presto across your cluster</li>
<li>Configure your Presto cluster</li>
<li>Start and stop the Presto servers</li>
<li>Gather status and log information from your Presto cluster</li>
</ul>
</dd>
<dt>Examples</dt>
<pre>
presto-admin server start|stop|restart|status
presto-admin server install path-to-presto-rpm
presto-admin connector add connector-name
</pre>
</dl>
</div>
<h2 id="clients">Presto Clients and GUIs</h2>
<div class="item">
<h4>Airpal</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://airbnb.github.io/airpal/">Airpal</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/airbnb">Airbnb</a></dd>
<dt>Description</dt>
<dd>
Airpal is a web-based, query execution tool which
leverages Facebook's PrestoDB to make authoring queries
and retrieving results simple for users. Airpal provides
the ability to find tables, see metadata, browse sample
rows, write and edit queries, then submit queries all
in a web interface.
</dd>
</dl>
</div>
<div class="item">
<h4>Redash</h4>
<dl>
<dt>Project</dt>
<dd><a href="http://redash.io/">Redash</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/getredash/">Arik Fraimovich</a></dd>
<dt>Description</dt>
<dd>
Redash is a take on freeing the data within our
company in a way that will better fit our culture and
usage patterns. It has Presto support as well as other
backends, and offers a query editor with syntax
highlighting and completion, and creating
visualizations and dashboards from query results.
</dd>
</dl>
</div>
<div class="item">
<h4>Quix</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://wix.github.io/quix/docs/about">Quix</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/wix/quix/">Wix</a></dd>
<dt>Description</dt>
<dd>
Quix is a multi-user, easy-to-use notebook manager.
By utilizing Presto it provides unified access to
multiple data sources and effectively acts as a
shared space for your company's BI insights and know-how.
</dd>
</dl>
</div>
<div class="item">
<h4>Shib</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/tagomoris/shib">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/tagomoris">Tagomori Satoshi</a></dd>
<dt>Description</dt>
<dd>
Shib is a web-client written in Node.js designed to
query Presto and Hive. To run Shib install node.js,
alter your config.js, and follow the instructions on
the shib project page. Shib can also be used as an
proxy server for query engines.
</dd>
</dl>
</div>
<div class="item">
<h4>Superset</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://superset.incubator.apache.org/">Apache Superset</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/apache/incubator-superset">Apache Superset</a></dd>
<dt>Description</dt>
<dd>
Superset enables users to consume data in many different
ways: writing SQL queries, creating new tables, creating
a visualization (slice), adding that visualization to one
or many dashboards and downloading a CSV. SQL Lab is a
a part of Superset and provides rich SQL editor that
enables users to both query and visualize data.
You can explore and preview tables in Presto, effortlessly
compose SQL queries to access data. From there, you can
either export a CSV file or immediately visualize your
data in the Superset "Explore" view.
</dd>
</dl>
</div>
<div class="item">
<h4>yanagishima</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/wyukawa/yanagishima">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/wyukawa">wyukawa</a>, <a href="https://github.com/okazou">okazou</a></dd>
<dt>Description</dt>
<dd>
yanagishima is a web application for Presto.
yanagishima provides the ability to execute query,
show query, kill query, bookmark query, search table,
share query/query result, format query, download as CSV/TSV file,
insert chart, substitute query parameter, and so on.
</dd>
</dl>
</div>
<h2 id="odbc">Presto ODBC</h2>
<h3 id="prestogres">Prestogres</h3>
<div class="item">
<h4>Prestogres</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/treasure-data/prestogres">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/frsyuki">Furuhashi Sadayuki</a></dd>
<dt>Description</dt>
<dd>
Prestogres is a gateway server that allows clients
to use PostgreSQL protocol and thus the
PostgreSQL ODBC driver to run queries on Presto.
</dd>
</dl>
</div>
<h2 id="libraries">Presto Libraries</h2>
<p>
The following client libraries can be used to run queries from
several programming languages:
<a href="#language-c">C</a>,
<a href="#language-go">Go</a>,
<a href="#language-java">Java</a>,
<a href="#language-node">Node.js</a>,
<a href="#language-php">PHP</a>,
<a href="#language-python">Python</a>,
<a href="#language-r">R</a>,
<a href="#language-ruby">Ruby</a>.
</p>
<h3 id="language-c">Language: C</h3>
<div class="item">
<h4>PrestoClient C</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/easydatawarehousing/prestoclient/tree/master/C">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/easydatawarehousing">Ivo Herweijer</a></dd>
<dt>Description</dt>
<dd>C client for Presto.</dd>
</dl>
</div>
<h3 id="language-go">Language: Go</h3>
<div class="item">
<h4>presto-go-client</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/prestodb/presto-go-client">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/prestodb/presto-go-client">Presto Go Client Team</a></dd>
<dt>Description</dt>
<dd>Go client for Presto.</dd>
</dl>
</div>
<h3 id="language-java">Language: Java</h3>
<div class="item">
<h4>Presto JDBC Driver</h4>
<dl>
<dt>Project</dt>
<dd><a href="docs/current/installation/jdbc.html">Presto</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/prestodb/presto">Presto Team</a></dd>
<dt>Description</dt>
<dd>JDBC driver for Presto.</dd>
<dt>Example</dt>
<dd>
<pre>
String sql = "SELECT * FROM sys.node";
String url = "jdbc:presto://localhost:8080/catalog/schema";
try (Connection connection =
DriverManager.getConnection(url, "test", null)) {
try (Statement statement = connection.createStatement()) {
try (ResultSet rs = statement.executeQuery(sql)) {
while (rs.next()) {
System.out.println(rs.getString("node_id"));
}
}
}
}
</pre>
</dd>
</dl>
</div>
<h3 id="language-node">Language: Node.js</h3>
<div class="item">
<h4>presto-client-node</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/tagomoris/presto-client-node">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/tagomoris">Satoshi Tagomori</a></dd>
<dt>Description</dt>
<dd>Node.js client for Presto.</dd>
</dl>
</div>
<div class="item">
<h4>lento</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/vweevers/lento">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/vweevers">Vincent Weevers</a></dd>
<dt>Description</dt>
<dd>Streaming Node.js client for Presto.</dd>
</dl>
</div>
<h3 id="language-php">Language: PHP</h3>
<div class="item">
<h4>PhpPrestoClient</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/Xtendsys-labs/PhpPrestoClient">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/Xtendsys-labs">Xtendsys-labs</a></dd>
<dt>Description</dt>
<dd>PHP client for Presto.</dd>
</dl>
</div>
<h3 id="language-python">Language: Python</h3>
<div class="item">
<h4>presto-python-client</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/prestodb/presto-python-client">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/prestodb/presto-python-client">Presto Python Client Team</a></dd>
<dt>Description</dt>
<dd>Python client for Presto.</dd>
</dl>
</div>
<div class="item">
<h4>PyHive</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/dropbox/PyHive">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/dropbox">Dropbox</a></dd>
<dt>Description</dt>
<dd>PyHive is a collection of Python DB-API and SQLAlchemy interfaces for Presto and Hive.</dd>
</dl>
</div>
<div class="item">
<h4>PrestoClient Python</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/easydatawarehousing/prestoclient/tree/master/python">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/easydatawarehousing">Ivo Herweijer</a></dd>
<dt>Description</dt>
<dd>Python client for Presto.</dd>
</dl>
</div>
<h3 id="language-r">Language: R</h3>
<div class="item">
<h4>RPresto</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/prestodb/RPresto">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/prestodb/RPresto">RPresto Team</a></dd>
<dt>Description</dt>
<dd>DBI-based adapter for Presto for R.</dd>
</dl>
</div>
<h3 id="language-ruby">Language: Ruby</h3>
<div class="item">
<h4>presto-client-ruby</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/treasure-data/presto-client-ruby">GitHub</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/frsyuki">Furuhashi Sadayuki</a></dd>
<dt>Description</dt>
<dd>Ruby client for Presto.</dd>
</dl>
</div>
<h2 id="connectors">Presto Connectors / Plugins</h2>
<div class="item">
<h4>MySQL-Teradata</h4>
<dl>
<dt>Project</dt>
<dd><a href="https://github.com/HackShare/presto">MySQL-Teradata Plugin for Presto</a></dd>
<dt>Maintained by</dt>
<dd><a href="https://github.com/HackShare">HackShare</a></dd>
<dt>Description</dt>
<dd>
This project isn't an install-ready plugin for
MySQL-Teradata it is a fork of the entire Presto
project and it contains a working MySQL-Teradata
plugin. This integration was posted to the Google
Group by maintainer Dheeban Govindarajan.
</dd>
</dl>
</div>
<h2 id="cloud">Presto Cloud</h2>
<p>
Presto is also readily available in <a href="#aws">AWS</a>.
</p>
<h3 id="aws">AWS</h3>
<div class="item">
<h4>Presto Cloud</h4>
<dl>
<dt>Website</dt>
<dd><a href="https://ahana.io/" target="_blank">Ahana</a></dd>
<dt>Maintainer</dt>
<dd><a href="https://ahana.io/" target="_blank">Ahana</a></dd>
<dd>
<p>
Ahana Cloud for Presto is the first cloud-native managed service for Presto. This offering is designed to simplify the deployment, management and integration of Presto, with data catalogs, databases and data lakes on Amazon Web Services (AWS). <a href="https://ahana.io/ahana-cloud/" target="_blank">Ahana Cloud for Presto</a> is easy-to-use with no installation, no AMIs or CFTs, and no configuration needed. Via the Ahana console, Presto is deployed within the user’s AWS account, giving users complete control and visibility of clusters and their data. As a managed service, there is no infrastructure to manage, yet you can pay only for Ahana and the EC2 instances that you use.
<p/>
<p>
Ahana Cloud simplifies Presto. It comes out-of-the-box integrated with built-in catalogs, data sources, and dashboarding tools. Under the hood, Ahana leverages the latest version of Presto and runs with Amazon EKS for high scalability, availability, and manageability.
</p>
</dd>
</dl>
</div>
<div class="item">
<h4>Amazon Athena</h4>
<dl>
<dt>Website</dt>
<dd><a href="https://aws.amazon.com/athena/">Amazon Athena</a></dd>
<dt>Maintainer</dt>
<dd><a href="https://aws.amazon.com/">Amazon Web Services</a></dd>
<dd>
<p>
Amazon Athena is an interactive query service based on Presto that makes it easy to analyze data in Amazon S3
using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the
queries that you run.
<p/>
<p>
Amazon Athena uses Presto with full standard SQL support and works with a variety of standard data formats.
Athena is out-of-the-box integrated with AWS Glue Data Catalog, allowing you to create a unified metadata
repository across various services, crawl data sources to discover schemas and populate your Catalog with
new and modified table and partition definitions, and maintain schema versioning.
</p>
</dd>
</dl>
</div>
<div class="item">
<h4>Amazon EMR</h4>
<dl>
<dt>Website</dt>
<dd><a href="https://aws.amazon.com/emr/">Amazon EMR</a></dd>
<dt>Maintainer</dt>
<dd><a href="https://aws.amazon.com/">Amazon Web Services</a></dd>
<dd>
<p>
Amazon EMR provides a managed Hadoop framework that makes it easy, fast, and cost-effective
to process vast amounts of data across dynamically scalable Amazon EC2 instances. With EMR, you can launch a
large Presto cluster in minutes. You don't need to worry about node provisioning, cluster setup or tuning.
<p/>
<p>
Using Presto on EMR provides these benefits to customers:
<ul>
<li>Elasticity: With Amazon EMR, you can provision one, hundreds, or thousands of compute instances to
process data at any scale. You can easily increase or decrease the number of instances manually
or with Auto Scaling, and you only pay for what you use.</li>
<li>Simple and predictable pricing: You pay a per-second rate for every second used, with a one-minute
minimum charge.</li>
</ul>
</p>
</dd>
</dl>
</div>
</div>
<div class="rightcol">
<h3>Community Contributed Content</h3>
<ul>
<li><a href="#tutorials">Tutorials</a></li>
</ul>
<h3>Community Contributed Tools</h3>
<ul>
<li><a href="#tools">Presto Management Tools</a></li>
<li><a href="#clients">Presto Clients</a></li>
<li><a href="#odbc">Presto ODBC</a></li>
<li><a href="#libraries">Presto Libraries</a></li>
<li><a href="#connectors">Presto Connectors</a></li>
</ul>
<h3>Presto Support & Services</h3>
<ul>
<li><a href="#cloud">Presto Cloud</a></li>
</ul>
</div>
</div>
<div class="footer width">
<section className="copyright">
Copyright © The Presto Foundation.<br>
All rights reserved. Presto is a registered trademark of LF Projects, LLC. <br>Please see our <a
href="https://lfprojects.org/policies/trademark-policy/">Trademark Policy</a> for more
information.<br>
<a href="https://lfprojects.org/policies/privacy-policy/">Privacy Policy</a> |
<a href="https://lfprojects.org/policies/terms-of-use/">Terms of Use</a>.
</section>
</div>
</body>
</html>