presto | community managed version of Presto , the distributed SQL

by prestosql Java Version: Current License: Apache-2.0

X-Ray Key Features Code Snippets(4)Community Discussions(10)Vulnerabilities Install Support

kandi X-RAY | presto Summary

presto is a Java library typically used in Big Data, Spark, Hadoop applications. presto has build file available, it has a Permissive License and it has high support. However presto has 387 bugs and it has 11 vulnerabilities. You can download it from GitHub, Maven.

After building Presto for the first time, you can load the project into your IDE and run the server. We recommend using IntelliJ IDEA. Because Presto is a standard Maven project, you can import it into your IDE using the root pom.xml file. In IntelliJ, choose Open Project from the Quick Start box or choose Open from the File menu and select the root pom.xml file.

Support

Quality

Security

License

Reuse

Support

presto has a highly active ecosystem.

It has 1595 star(s) with 800 fork(s). There are 111 watchers for this library.

It had no major release in the last 6 months.

There are 900 open issues and 1007 have been closed. On average issues are closed in 39 days. There are 271 open pull requests and 0 closed requests.

It has a positive sentiment in the developer community.

The latest version of presto is current.

Quality

presto has 387 bugs (35 blocker, 20 critical, 174 major, 158 minor) and 13122 code smells.

Security

presto has 1 vulnerability issues reported (0 critical, 1 high, 0 medium, 0 low).

presto code analysis shows 10 unresolved vulnerabilities (2 blocker, 1 critical, 7 major, 0 minor).

There are 480 security hotspots that need review.

License

presto is licensed under the Apache-2.0 License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

presto releases are not available. You will need to build from source code and install.

Deployable package is available in Maven.

Build file is available. You can build the component from source.

Installation instructions, examples and code snippets are available.

presto saves you 2214098 person hours of effort in developing the same functionality from scratch.

It has 897053 lines of code, 65739 functions and 7222 files.

It has medium code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of presto

Get all kandi verified functions for this library.

presto Key Features

No Key Features are available at this moment for presto.

presto Examples and Code Snippets

How can I get Presto host:port configuration?

Lines of Code : 9

License : Strong Copyleft (CC BY-SA 4.0)

Copy

$ presto-cli --version
Presto CLI 334

$ presto-cli --help | grep -A2 -e --server
...
--
        --server 
            Presto server location (default: localhost:8080)

Exception while build presto

Java

Lines of Code : 4

License : Strong Copyleft (CC BY-SA 4.0)

Copy

pip2 install sphinx

make -C presto-docs clean html

Simple Batch Script for Presto query

Lines of Code : 2

License : Strong Copyleft (CC BY-SA 4.0)

Copy

presto-cli --server ... --file input.sql > output-file

How to fix not running presto plugin in AWS EMR

Lines of Code : 46

License : Strong Copyleft (CC BY-SA 4.0)

Copy

$s3uri="s3://my-s3-bucket"

# make symbolic link
sudo mkdir /usr/lib/presto/etc
sudo ln -s /usr/lib/presto/etc /mnt/var/lib/presto/data

# download presto plugins
aws s3 sync $s3uri/jar/ /usr/lib/presto/plugin/
aws s3 sync $s3uri/propertie

Community Discussions

Trending Discussions on presto

SQL - Is it possible to print all records or only one record taking into account count(*) in a table?

How to group into batches after assigning rank

Presto equivalent to StringTokenizerDelim (Vertica) / Explode(Python)

Calculating averages by quarters

AWS Athena (Presto) - multiple WITH statements

Presto SQL - Transforming array(BingTile) into geometry

htaccess - remove .php extension from url

Create the responsive next / previous button for my project

Hive Table Partition Metadata Issue

How to check if an array contains any elements of another array

QUESTION

SQL - Is it possible to print all records or only one record taking into account count(*) in a table?

Asked 2022-Apr-04 at 08:54

I am trying to find a way to print the result taking into account if exists records in a table or not. If yes I should print all the records in a table, otherwise I should print only one record.

Example:

I have the Table Example:

ColA Colb ColC

If select count(*) from Example > 0 THEN Return

ColA Colb ColC 1 VA1 NULL 2 VB1 NULL 3 NULL VA2

If select count(*) from Example <= 0 THEN Return

ColA Colb ColC Result NA NA

Is it possible to do something like that? I am doing the development using PRESTO.

Thanks you in advance

...

ANSWER

Answered 2022-Apr-04 at 08:49

We could introduce a dummy/default row via a union, and then retain it only in the event of the Example table being empty:

Source https://stackoverflow.com/questions/71734250

QUESTION

How to group into batches after assigning rank

Asked 2022-Feb-11 at 18:34

I have a table that I'm first trying to group based on unique column values (using dense_rank) and then further group those items into batches of 5. Below is my table:

video_id frame_id verb video_a frame_1 walk video_a frame_2 run video_a frame_3 sit video_a frame_4 walk video_a frame_5 walk video_a frame_6 walk video_b frame_7 stand video_b frame_8 stand video_b frame_9 run video_b frame_10 run video_b frame_11 sit video_b frame_12 run video_b frame_13 run

And below is what I'm trying to get:

video_id frame_id verb batch_of_five video_a frame_1 walk 1 video_a frame_2 run 1 video_a frame_3 sit 1 video_a frame_4 walk 1 video_a frame_5 walk 1 video_a frame_6 walk 2 video_b frame_7 stand 3 video_b frame_8 stand 3 video_b frame_9 run 3 video_b frame_10 run 3 video_b frame_11 sit 3 video_b frame_12 run 4 video_b frame_13 run 4

Where each video_id has a unique rank and each batch of 10 within each ranked video_id has its own unique rank (and each batch of 10 overall has a unique id regardless of whether they belong to the same video_id or not).

I'm able to group based on the video_id column but am having trouble grouping those items further so that they are both in batches of 10 and unique across all video_ids. I thought about using a group by clause but I'm trying to keep the other columns intact as well (verb column).

Here is my presto query so far:

...

ANSWER

Answered 2022-Feb-08 at 16:08

Calculate frame rank (partition by video_id), divide by 6 (integer division) to get batch number in video_id partition. Then rank again to get absolute batch number:

Source https://stackoverflow.com/questions/71026132

QUESTION

Presto equivalent to StringTokenizerDelim (Vertica) / Explode(Python)

Asked 2022-Feb-09 at 10:52

I am migrating a query from Vertica to Presto(0.246). The query contains a Vertica function StringTokenizerDelim, which basically explodes and array (market column) into rows.

This is the mockup of the table:

...

ANSWER

Answered 2022-Feb-09 at 10:49

split with UNNEST should do the trick:

Source https://stackoverflow.com/questions/71047936

QUESTION

Calculating averages by quarters

Asked 2022-Jan-19 at 11:15

I have a table in presto with 2 columns: date and value.

I want to calculate the average of 2nd Quarter's values so the expected result should be: 15.

How can I do this in presto?

...

ANSWER

Answered 2022-Jan-19 at 11:09

You can divide month by 3 and group by the result:

Source https://stackoverflow.com/questions/70763611

QUESTION

AWS Athena (Presto) - multiple WITH statements

Asked 2022-Jan-16 at 00:11

Is there a way to use multiple WITH statements in Athena/Presto?

...

ANSWER

Answered 2022-Jan-15 at 23:30

have you tried with a as ( ) , b as () select * from a,b ?

Source https://stackoverflow.com/questions/70726222

QUESTION

Presto SQL - Transforming array(BingTile) into geometry

Asked 2022-Jan-12 at 10:50

I'm trying to calculate the City area size by using Geospatial Functions like the bing_tiles_around(), geometry_union(), and st_area() with the below sample data.

...

ANSWER

Answered 2022-Jan-12 at 10:50

bing_tiles_around returns array of BingTile while geometry_union expects array of Geometry so you need to transform one to another:

Source https://stackoverflow.com/questions/70679094

QUESTION

htaccess - remove .php extension from url

Asked 2021-Dec-19 at 20:15

I tried a lot of code to remove .php from url
for example - ht.abuena.net/presto.php -> ht.abuena.net/presto
and vice versa - internally

...

ANSWER

Answered 2021-Dec-19 at 19:34

With your shown samples, please try following htaccess rules file.

Please make sure to clear your browser cache before testing your URLs.

Source https://stackoverflow.com/questions/70414106

QUESTION

Create the responsive next / previous button for my project

Asked 2021-Dec-19 at 04:40

could you guys please help me creating a next and previous buttons ? I've been struggling because of my bad javascript . I saw some people use Jquery and almost all Javascript. I'm practicing Javascript so there are a lot of things I don't know. Thank you very much.

Wants: Next / Previous button to go to next page and go back page if users want to read again that page.

Link of my demo: https://jsfiddle. net/hioihia123/zgjswtay/3/

...

ANSWER

Answered 2021-Dec-19 at 04:40

Can you simply add the Previous and Next buttons at the footer or somewhere you'd prefer, and link to appropriate pages? Won't that be simple enough in your case?

Source https://stackoverflow.com/questions/70408731

QUESTION

Hive Table Partition Metadata Issue

Asked 2021-Dec-15 at 08:53

we have a Hive Internal partitioned table which is existing from long time. recently we discovered that we need to change a column's name and datatype. also, we need to remove 3 duplicate records from the table. so we performed this step.

...

ANSWER

Answered 2021-Dec-15 at 08:53

Overwrite all partitions using Hive, like you did when removed duplicates. Some partitions remain not overwritten and causing error in Presto because the type inside ORC file and in Hive metadata is different. So, just try to overwrite partitions which you did not previously overwritten or overwrite all of them:

Source https://stackoverflow.com/questions/70354963

QUESTION

How to check if an array contains any elements of another array

Asked 2021-Dec-03 at 14:53

Here I've an array ["chair","desk","charger"], I'd like to check if a different array contains any the elements in the first array.

Example:

...

ANSWER

Answered 2021-Dec-03 at 13:48

Check cardinality of array returned by array_intersect(x, y) function.

Demo:

Source https://stackoverflow.com/questions/70215008

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

CVE-2020-15087 HIGH

In Presto before version 337, authenticated users can bypass authorization checks by directly accessing internal APIs. This impacts Presto server installations with secure internal communication configured. This does not affect installations that have not configured secure internal communication, as these installations are inherently insecure. This only affects Presto server installations. This does NOT affect clients such as the CLI or JDBC driver. This vulnerability has been fixed in version 337. Additionally, this issue can be mitigated by blocking network access to internal APIs on the coordinator and workers.

https://prestosql.io/docs/current/release/release-337.html#security-changes

https://github.com/prestosql/presto/security/advisories/GHSA-f6pc-crhh-cp96

Install presto

Mac OS X or Linux
Java 11.0.7+, 64-bit
Docker

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: