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
0
votes
0 answers

Looking for JDBC SQL to fetch default column names from table which has list of columns

Looking for JDBC SQL code to fetch default column names from table which has list of columns. is there any SQL command or query to fetch default column names from table.
Automation tester
  • 1
0
votes
0 answers

Using PrestoDB as RDBMS

I'm currently working on a project connecting prestoDB to our DBtool to extract and load different types of data from different sources(json index from elasticsearch, json record from kafka etc). it works on a DBeaver with a jdbc, however, our…
doubleJ
  • 9
  • 2
0
votes
0 answers

Locking Row for Access in Presto SQL, udw in Teradata

Hi I'm trying to access teradata tables using Presto SQL and I get a Locking error. I can't use Locking Row for access in Presto SQL because it doesn't support it. So why is there a locking error in first place?
linthum
  • 333
  • 1
  • 8
  • 22
0
votes
1 answer

split(regexp_replace ) Like Function In Presto : 331

Is there any way to split values based on consecutive 0's in presto.Minimum 6 digits should be there in first split, if digit count is less than 6 than need to consider some 0's as digit then split if digit count is >= 6 then just need to split in…
Sonu
  • 77
  • 11
0
votes
0 answers

Presto datatype Mismatch Issue In Hive ORC Table

I am trying to query my hive orc table by presto ,In Hive its working Fine.In prestro I am able to access all the column except lowrange It's showing Below Erroe error : Query 20220322_135856_00076_a33ec failed: Error opening Hive split…
Sonu
  • 77
  • 11
0
votes
1 answer

How to connect to Presto JDBC in python?

I am trying to connect to Presto server in python using JDBC, but cannot find any guidance on how to do that. There are ways just to connect to Presto in python (e.g., standard approach in SQLAlchemy) or to connects to Presto JDBC in Java or R, but…
sk3404
  • 1
0
votes
1 answer

org.apache.hadoop.security.AccessControlException: SIMPLE authentication is not enabled. Available:[TOKEN, KERBEROS]

I am trying to execute the hive table query in presto using Kerberos authentication, But it failed Caused by: com.facebook.presto.spi.PrestoException: Error opening Hive split…
Jack
  • 1
  • 4
0
votes
1 answer

SQL - Guarantee at least n unique users with 2 appearances each in query

I'm working with AWS Personalize and one of the service Quotas is to have "At least 1000 records containing a min of 25 unique users with at least 2 records each", I know my raw data has those numbers but I'm trying to find a way to guarantee that…
DiegoTrigueros
  • 23
  • 4
0
votes
0 answers

At what stage does JDBC actually execute the query

I have very limited knowledge of database in general. I am flummoxed by how exactly JDBC(Presto) works - so in my program, I have something like ResultSet rs = statement.execute(sqlcommand); while (rs.next()) {...} the execute part takes a few…
camus
  • 57
  • 1
  • 8
0
votes
1 answer

How can I insert data from prestoDB to Kafka topic?

I can get data from kafka topic from presto like below properties: /etc/kafka/mytable.json { "tableName": "mytable", "schemaName": "mykafka", "topicName": "mykafka.mytable", "message": { "dataFormat": "json", …
CompEng
  • 7,161
  • 16
  • 68
  • 122
0
votes
0 answers

Problem connecting remote PrestoDB from local machine using pyspark

I'm trying to connecct to a presto DB installed in a remote server from my mac local machine using pyspark, below is my code. I have downloaded the presto driver and placed it under /user/name//Hadoop/spark-2.3.1-bin-hadoop2.7/jars ( I guess this is…
user7343922
  • 316
  • 4
  • 17
0
votes
1 answer

RDBMS Resource Usage when Using PrestoDB

When we querying mysql database using presto, is it means that we still using mysql’s resource like cpu or ram or not?. Thank you
daun-gatal
  • 3
  • 1
0
votes
1 answer

Unable to query Presto database using Dbvisuallizer- Error Executing Query

We are trying to connect to presto using Dbvisualizer . and execute some queries . Catlog we are using is mysql . Presto is installed in the linux server . presto cli is working fine in the linux . Started presto in linux . Mysql is also installed…
Tarun teja
  • 59
  • 3
  • 7
0
votes
0 answers

Presto Jdbc Connection gives Error executing query

We are trying to execute presto jdbc connection . We have followed the simple example in https://www.tutorialspoint.com/apache_presto/apache_presto_jdbc_interface.htm Added the jar , run as java application in eclipse . note : Presto is installed…
Tarun teja
  • 59
  • 3
  • 7
0
votes
0 answers

Big number of values IN Query with ItemReader

The following ItemReader gets a list of thousands accounts (acc). The database that the ItemReader will connected to in order to retrieve the data is HIVE. I don’t have permission to create any table, only read option. @Bean @StepScope public…
angus
  • 3,210
  • 10
  • 41
  • 71
1 2
3
4