Top "Presto" questions

AWS Athena SQL Query Error with timestamp

I have a table in AWS Athena having column named 'servertime' with the data type of timestamp. I run a …

sql timestamp amazon-athena presto

Generate interval from variable in Presto

In Presto SQL, unlike regular SQL, intervals must be created with inverted commas: INTERVAL '1' DAY rather than INTERVAL 1 …

sql date time presto

Time diff in Amazon Athena / Presto (seconds and minutes )

I have a list of creation time stamps and ending time stamps , i would like to get the amount of …

presto amazon-athena

Why Presto is faster than Spark SQL

Why is Presto faster than Spark SQL? Besides what is the difference between Presto and Spark SQL in computing architectures …

apache-spark-sql presto

Select Top # in Presto SQL?

Does Presto SQL really lack TOP X functionality in SELECT statements? If so, is there a workaround in the meantime? …

sql presto

How to get input file name as column in AWS Athena external tables

I have external tables created in AWS Athena to query S3 data, however, the location path has 1000+ files. So I …

sql amazon-web-services amazon-s3 presto amazon-athena

How to get month name from date in Presto

I use Presto and I do not know the function to get MONTH's name from a date column. I can …

function date monthcalendar presto

Converting bigint to timestamp in presto

I have a column in my dataset that has a datatype of bigint: Col1 Col2 1 1519778444938790 2 1520563808877450 3 1519880608427160 4 1520319586578960 5 1519999133096120 How do I convert Col2 …

date time timestamp bigint presto

Does Presto have the equivalent of Hive's SET command

It's very convenient to be able to set script variables. For example, SET start_date = 20151201; SELECT * FROM some_table where …

presto

How do I escape a single quote in Presto?

How can I escape a ' (single quote) in Presto? This is where I am trying to use it select …

sql presto