Top "Presto" questions

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

Finding out the data type of a value in Presto

I'm getting values from nested maps and it's hard to figure out what data type each value is. Is there …

sql presto trino
Converting Unix epoch time to extended ISO8601

I have 3 tables I would like to work on using the date, however one of the tables includes the date …

datetime hadoop presto amazon-athena
hive and presto,Integer division truncation problem

Why does the splitting of the two bigint type data in hive does not occur for integer division truncation, but …

sql hive presto
Presto SQL pivoting (for lack of a better word) data

I am working with some course data in a Presto database. The data in the table looks like: student_id …

sql presto
Presto on Amazon S3

I'm trying to use Presto on Amazon S3 bucket, but haven't found much related information on the Internet. I've installed …

amazon-web-services amazon-s3 amazon-ec2 presto
AWS Glue issue with double quote and commas

I have this CSV file: reference,address V7T452F4H9,"12410 W 62TH ST, AA D" The following options are …

hadoop hive presto amazon-athena aws-glue
How do I find percentages of a column using Hive/Presto

Let's say I have a table that looks like: Reason | Duration Eating 40 Drinking 60 Everything Else 100 How do I get a …

hive presto
Cumulative distinct count

I am working on query to get cumulative distinct count of uids on daily basis. Example : Say there are 2 uids (100,200) …

sql presto
What is the equivalent of Presto UNNEST function in Hive

Presto has an UNNEST function to explode columns made of arrays. Is there a similar one for Hive? See docs …

arrays hive hiveql presto unnest
How do I run md5() on a bigint in Presto?

select md5(15) returns Query failed (#20160818_193909_00287_8zejd): line 1:8: Unexpected parameters (bigint) for function md5. Expected: md5(varbinary) How do I hash 15 …

sql md5 presto