Currently, my table has three different fields, id1, id2 and actions. action is of type string. For example, my table looks something like the table given below: id1 | id2 | actions --------------...

I have a date column called day such as 2019/07/22 if I want to create a custom field that translates that date to the actual day of week it is such as Sunday or Monday how is this possible? I cant...

My data is in VARCHAR format. I want to split both the elements of this array so that I can then extract a key value from the JSON. Data format [ { "skuId": "5bc87ae20d298a283c297c...

I'm trying to unnest some code I have a a couple of columns that have arrays, both columns using | as a deliminator The data would be stored looking like this, with extra values to the side which...

I have table in presto, one column named ("mappings") have key-value pair as string select mappings from hello; Ex: {"foo": "baar", "foo1": "bar1" } I want to cast "mappings" column into a MAP ...

I used pyhive to connect hive to use Presto. May I know the partitions of the hive tables before presto has executed the sql?

We are trying to implement Presto with Kubernetes. We have a kubernetes cluster running on cloud as a service. I tried to google on this but could not find a conclusive result as to what may be the...

I like to convert my timestamp columns to date and time format. How should I write the query from presto? my timestamp is UTC time. Thank you very much Timestamp format"1506929478589" After query ...

I want to convert a readable timestamp to UNIX time. For example: I want to convert 2018-08-24 18:42:16 to 1535136136000. Here is my syntax: TO_UNIXTIME('2018-08-24 06:42:16') new_year_ut M...

New to presto, any pointer how can I use LATERAL VIEW EXPLODE in presto for below table. I need to filter on names in my presto query CREATE EXTERNAL TABLE `id`( `id` string, `names` map<str...

I'm new to Presto and looking to get the same functionality as the group_concat function in MySQL. Are the following two equivalent? If not, any suggestions for how I can recreate the group_concat ...

I'm getting values from nested maps and it's hard to figure out what data type each value is. Is there a typeof function that can tell me the data type of each value?

I'm pretty sure the following query used to work for me on Presto: select segment, sum(count) from modeling_trends where segment='2557172' and date = '2016-06-23' and count_time between '2016-06-2...

I suspect the answer is "it depends", but is there any general guidance about what kind of hardware to plan to use for Presto? Since Presto uses a coordinator and a set of workers, and workers ru...