What is Presto JDBC?
Presto JDBC is a JDBC driver for Presto, an open source distributed SQL query engine for running analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
Questions tagged [presto-jdbc]
57 questions
0
votes
1 answer
ItemReader unable to read rows via PrestoDriver
The following ItemReader bean read rows via PrestDriver. When executing the batch I am getting the this error message:
org.springframework.batch.core.step.skip.NonSkippableReadException: Non-skippable exception during read
at…
angus
- 3,210
- 10
- 41
- 71
0
votes
1 answer
Error when using Presto's date functions: '>=' cannot be applied to varchar, date
I am facing an issue while using presto date functions to get the current day and the previous day’s data.
“An error occurred while communicating with Presto.
Bad Connection: Tableau could not connect to the data source.
Error Code:…
Johnpaul
- 11
- 1
- 1
0
votes
1 answer
Presto JDBC Call statements
Is it possible to execute CALL system.sync_partition_metadata('dummy','dummy','FULL') using JDBC as Presto JDBC driver does not support CallableStatements?
mhlaskar1991
- 61
- 9
0
votes
0 answers
Unable to connect Sql server and hive from presto
My presto is up and running having following issue on connectors.
i have installed presto in root, my hive is in "hadoop" user and my "sql" is in another user
And i am getting
Java.net.connectexception: Failed to connect /127.0.0.1:8090 for sql
And…
HNM
- 1
- 3
0
votes
1 answer
How to pushdpown order by clause in presto elasticsearch
I am running a SQL query in starburst-presto. It's connected to elasticsearch using the relevant connector.
The SQL has an "order by" clause. This clause is not pushing down to elasticsearch. Basically, I want to sort the data in elasticsearch based…
RoyalTiger
- 511
- 2
- 8
- 27
0
votes
1 answer
Presto odbc failing to read timestamp fileds in HIVE
I am using presto ODBC to fetch data from Hive into one of the BI tools, however, the query fails with the below error. Could you please help me to understand what might be the issue.
ODBC version: Simba Presto ODBC Driver 1.02.09.1009
used sql :…
Priyaranjan Swain
- 361
- 4
- 17
0
votes
0 answers
Why don't columns with citext datatype is processed by presto?
I'm running pgsql queries on the sql console provided by presto-client connected to presto-server running on top of postgres. The resultset of the queries contain only the columns that aren't of citext type.
DataDetails Table Description:
…
Manikandan Balasubramanian
- 1,079
- 4
- 14
- 27
0
votes
1 answer
Creating catalog/schema/table in prestosql/presto container
I would like to use prestosql/presto container for automated tests. For this purpose I want to receive the ability to programmatically to create catalog/schema/table. Unfortunately, I didn't find the option via docker environment variables. If I…
barambuk
- 113
- 2
- 9
0
votes
1 answer
Presto JDBC Large Query Extremely Slow
Problem
Iterating over a large ResultSet from a Presto query in using JDBC Driver is extremely time consuming. Each batch call seems to take almost exactly 60s, which is suspicious (caused by some timeout maybe?).
For some reason, the initial…
Fabian
- 3,310
- 3
- 26
- 35
-1
votes
1 answer
Python: Cursor.execute() takes from 2 to 3 positional arguments but 4 were given
I'm trying to use Select statement and passing 3 elements from a Presto DB but I get this error message: Cursor.execute() takes from 2 to 3 positional arguments but 4 were given even though when the same syntax is used, but for a SQL server, there…
BOB
- 700
- 2
- 16
- 35
-1
votes
1 answer
How to add session properties of presto in spark
Is there any way to set session parameters of presto in spark, while building a Dataframe out of it.
public Dataset readPrestoTbl(){
Dataset stgTblDF = sparksession
.read()
…
Kalpesh
- 694
- 2
- 8
- 28
-1
votes
1 answer
Passing parameter and value in Presto JDBC Connection Url
Passing parameter and value in Presto JDBC Connection Url. For example i would like to pass a custom parameter "abc" with value "1234567890".
Would the below jdbc connection url works with the above requirement?…
