Stack Overflow
Stack Overflow

Questions tagged [starburst]

Starburst offers a full-featured data lake analytics platform, built on open source Trino. Use this tag for questions specific to Starburst's platform and products, including but not limited to Starburst Galaxy and Starburst Enterprise. For questions about OSS Trino, use the #trino tag.

What is Starburst?

Starburst is a company offering a full-featured, SaaS, data lake analytics platform, built on open source Trino, as well as an enterprise offering.

References

18 questions
2
votes
0 answers

How to print the current running SQL statement when PrestoSQL/Trino CLI executes multiple statements from a file?

When I use trino or presto CLI with the --file option, I am only able to see the result of the queries on stdout. Is there any way to print the SQL statement before printing its result to stdout?
FRG96
  • 151
  • 1
  • 9
1
vote
0 answers

Trino Starburst ODBC SYNTAX_ERROR : USER_ERROR (1010)

Getting following error while testing connection in windows odbc 64 and 32 manager: [Starburst][Trino] (1010) Error occurred while trying to connect: SYNTAX_ERROR : USER_ERROR : line 1:1: mismatched input '{'. Expecting: 'ALTER', 'ANALYZE', 'CALL',…
Edgar
  • 11
  • 2
1
vote
1 answer

Cast JSON to varchar with Trino

I'm trying to cast JSON object from table column to varchar with Trino I tried with these docs here but every time throws an error. https://trino.io/docs/current/functions/json.html If someone can post an example how I can make that it will be…
Borislav Blagoev
  • 187
  • 5
  • 15
1
vote
0 answers

Prestosql/trino on EMR scaling down kills the queries

I have a presto cluster on EMR. We also have auto scaling policy in place based on AWS Clouldwatch metrics. We have a issue when cluster scale-down the nodes, it doesn't wait for queries running on those nodes to complete. It just kills all queries…
yahoo
  • 183
  • 3
  • 22
1
vote
0 answers

Apache Superset 1.3 Error Connecting to Presto over SASL

Trying to connect Apache Superset 1.3 with Trino/Presto using Kerberos. Able to successfully install the plugins using pip install pyhive['presto']==0.6.2, also tried other versions. When tried doing a connection test, I get the following…
Shyam
  • 81
  • 1
  • 6
1
vote
1 answer

Can Presto server connect to Snowflake directly or only via starburst?

I am trying to find a snowflake connector for Presto but unable to find any in Presto documentation.All searches are showing connection via starburst only.
Manisha Singh
  • 21
  • 3
1
vote
0 answers

Presto error 400 when connecting to s3 bucket

OVERVIEW I deploy a Presto cluster on Kubernetes and try to connect it to a S3 bucket through a compatible API. HOW TO REPRODUCE I use Presto Operator (by Starburst) and configure my Presto resource with the following properties : hive: …
Amojow
  • 141
  • 9
1
vote
1 answer

presto + Hive Security Configuration

we have presto cluster with Hadoop cluster when all presto workers servers are installed on data-nodes machines The following is example of a Hive Connector configuration file that is configured on the presto workers under catalog…
jessica
  • 2,426
  • 24
  • 66
1
vote
3 answers

How to distribute a file across presto cluster in kuebernetes

I'm new to Kubernetes. We have a presto (starburst) cluster deployed in Kubernetes and we are trying to implement SSL certificate for the presto cluster. Based on the below URL, I have created a keystore (in my local machine) and have to populate…
Kiran
  • 451
  • 1
  • 6
  • 23
1
vote
1 answer

While creating Azure HDInsight cluster for Starburst Presto, can I create Spark Cluster?

While creating infrastructure for big data, I wanted to use Azure HDInsight with Presto installation. Azure HDInsight comes with different flavors like hadoop, spark etc. In documentations it is recommended to use hadoop cluster but I want to use…
Bhanuday Birla
  • 969
  • 1
  • 10
  • 23
1
vote
1 answer

How to run presto queries in python using pyhive?

I am trying to run presto query in python using pyhive library but max retries error is coming. I am running it in jupyter notebook locally(laptop). I think its not able to connect to presto node. I am using Azure hdinsight cluster and installed…
Bhanuday Birla
  • 969
  • 1
  • 10
  • 23
0
votes
0 answers

Trino error while querying for DELETE and INSERT after inserting semicolon at end of query

I'm trying to connect to trino and querying to delete rows and inserting rows for my Alteryx workflow. getting error after adding semicolon at the end of query which is a blocking currently the workflow. The same query works after removing…
pooja
  • 1
0
votes
1 answer

How to fix format error defining Trino/Kafka Joda Date Format

I have build a Trino schema for a Kafka stream that needs to parse a date in the following format: 2022-09-19T00:00:00.000+02:00. (The date is Midnight UTC+2h 19th Sept 2022.) The Schema is here, with the section that it is rejecting highlighted:…
Bryon
  • 939
  • 13
  • 25
0
votes
0 answers

Prompt user for input in Starburst Presto SQL

Anyone familiar with Starburst Presto and know how to prompt the user for their input? Can't seem to find anything on it online.
SillyStraw1022
  • 9
  • 2
0
votes
0 answers

How to run cleanup code at the end of Presto/Trino custom UDF?

I have created a custom Scalar PrestoSQL/Trino UDF. I wanted to know if it is possible to detect and run a method at the end of UDF execution (end of execution of a task or after the last row/data of the split)? I want to run a cleanup/IPC resource…
FRG96
  • 151
  • 1
  • 9
1
2