Stack Overflow
Stack Overflow

Questions tagged [presto-jdbc]

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.

References

57 questions
1
vote
1 answer

Trino Client Rest api authentication

I am trying to call trino Client REST Api endpoint, my trino is ldap authenticated, is there any documentation for all rest api endpoints exposed by trino so that I can login and post queries to trino cluster ? is there any java/python snippet…
Rock_17
  • 61
  • 5
1
vote
1 answer

PrestoDB JDBC GraalVM native mode build fails and query throws exception only when run in native mode

if I want to build my Quarkus 2.7.3.Final application with GraalVM CE 22.0.0.2 in native mode, I get a build error caused by the PrestoDB JDBC driver. Also, I get the following exceptions when I make a SQL query on PrestoDB 0.270 and it only occurs…
ThoSap
  • 31
  • 8
1
vote
1 answer

Spark Trino Connection

Currently I am using Spark 3.2.0 with Trino 363. I am trying to connect to Trino but I am getting an error. Error message is as below. Exception in thread "main" java.sql.SQLException: Unrecognized connection property 'url' Please find below code…
RAJ PATEL
  • 554
  • 4
  • 12
1
vote
2 answers

Similar method like TRY_CAST in presto

In SQL server, there is TRY_CAST method available to check if cast is possible or not. If cast is not possible then it will set NULL as value. Is there any similar method available in presto? Or How to achieve similar behavior in presto?
Hardik
  • 31
  • 1
  • 4
1
vote
1 answer

Unable to fetch data from Presto SQL (Trino) using pySpark

I have a pyspark job that I run on AWS Glue. The code is running fine when I run it through my local Machine. But when I try to run the same code from AWS Glue I am not able to fetch data. Below is my code and error message. From the output you will…
roshaga
  • 257
  • 3
  • 11
1
vote
0 answers

Presto showing everything null

I configured Single node Presto cluster and able to create tables from the data in my custom s3 service. However when I try to query data like select * from test limit 10; the result I am getting here is like this - time | quality | …
a13e
  • 838
  • 2
  • 11
  • 27
1
vote
1 answer

Adding client tags to presto jdbc connection

I am using jdbc to connect to presto server. From the documentation, I am able to connect to the server and run queries. https://prestodb.io/docs/current/installation/jdbc.html I am facing issues while sending ClientTags (X-Presto-Client-Tags) in…
Palash Goel
  • 624
  • 6
  • 17
1
vote
1 answer

Connecting from EMR spark to EMR presto - Failed to connect

I'm having issues connecting from an AWS EMR cluster with spark running to another AWS EMR cluster running presto. The code - written in python - is: jdbcDF = spark.read \ .format("jdbc") \ .option("driver",…
Adam
  • 432
  • 5
  • 16
0
votes
0 answers

Why does timestamp value changes between different presto versions?

I am running queries using presto jdbc jars. There is a time difference noticed for the same query when run against presto-jdbc-0.238.jar and presto-jdbc-0.82.jar. The simple query which shows this inconsistency is: select now(); with…
RaviKumar
  • 1
  • 3
0
votes
0 answers

Generating nested ROW struct in Presto

I am trying to generate the following nested struct using ROW in Presto but am unable to get this work. I basically want something in the format…
Arvind Srinivasan
  • 1
0
votes
0 answers

Connect to Netapp StorageGrid using PrestoDB or Hive

No Code here. I want to connect to NetApp StorageGrid using PrestoDB, as presto does not provide any connector for StorageGrid what .jar and configurations i can use in my metastore config files to connect to StorageGrid and query data and what…
Jenson D
  • 1
  • 1
0
votes
0 answers

Is there any way to create dynamic connection to postgresql database and query using presto?

we have tenant based architecture and each tenant have their own database to connect, We are using presto for our query processing engine so we need to create the connection dynamically for each and every tenant by writing some third party plugin…
Ashok Budagala
  • 1
0
votes
0 answers

Is it possible to access my Presto DB from AppScript?

I'm trying to query my Presto Database in AppScript but I don't seem to find how to do it. Is the connection possible using var conn = Jdbc.getConnection('Presto','url','username','password'); thanks for your help
KingOtta
  • 51
  • 4
0
votes
0 answers

presto create table from another table with double quotes with comma separated

How to create table in presto from a select query that has comma-separated values inside the column itself. e.g select statement has values look like Column1 column2 column3 1 2 abc,xyz below is the create statement for table CREATE…
user2928137
  • 59
  • 7
0
votes
0 answers

How to resolve unable to find valid certification path to requested target, when trying to access prestodb table from pyspark?

trying to access the prestodb table from using pyspark with following code spark = SparkSession.builder.master("local[*]").appName("testing presto connection").config('spark.driver.extraClassPath',…
Saranraj K
  • 412
  • 1
  • 7
  • 19
1
2
3 4