All Questions
6 questions
2
votes
1
answer
794
views
How do you write a presto query to split a string into its own column
Trying to splint a string into multiple columns in qubole using presto query.
{"field0":[{"startdate":"2022-07-13","lastnightdate":"2022-07-16","...
- 23
0
votes
1
answer
834
views
Presto Pivoting Data
I am really new to Presto and having trouble pivoting data in it.
The method I am using is the following:
select
distinct location_id,
case when role_group = 'IT' then employee_number end as ...
- 79
0
votes
1
answer
424
views
Qubole Presto datatype "Map" using the Like Operator
So I am trying to apply a simple like function for a Qubole query on Presto. For a string datatype I can simply do like '%United States of America%'.
However for the column I am trying to apply ...
- 35
0
votes
0
answers
61
views
Convert column in presto from epoch to date [duplicate]
I tried this but that didn't work.
cast(from_unixtime('1532568232662880')) as date
Any other ideas?
- 4,233
0
votes
1
answer
441
views
unable to connect ms sql server from Presto in Qubole
I am using Qubole Data Service on Microsoft Azure. I have created Presto Cluster in Qubole. I want to connect to MS SQL Server from Presto to read data from MS SQL Server. I have created sqlserver ...
- 57
-2
votes
1
answer
157
views
Error running presto query on kinesis
I am getting following error while running presto query on kinesis.
Query 20151031_142753_00003_xxxxx failed: Rate exceeded for stream xxxxx under account xxxxxx. (Service: AmazonKinesis; Status ...
- 27