Athena/Presto Escape Underscore Escaping Underscores in Athena Presto Queries A Guide When working with Athena or Presto you might encounter situations where you need to query data that includ 2 min read 05-10-2024 10
Presto fails to read hexadecimal string: Not a valid base-16 number Prestos Hexadecimal Headache Decoding the Not a Valid Base 16 Number Error Presto a distributed SQL query engine is known for its speed and efficiency However w 2 min read 05-10-2024 9
Can't set catalog to backblaze in Trino Cant Set Catalog to Backblaze in Trino Troubleshooting and Workarounds Problem You re trying to connect your Trino cluster to Backblaze B2 for data storage and 2 min read 04-10-2024 11
Add extra properties to iceberg table using Trino Adding Extra Properties to Iceberg Tables Using Trino In the world of big data managing and querying large datasets efficiently is paramount Iceberg an open tab 2 min read 26-09-2024 15
How should data be processed when returned from a Trino database? How to Efficiently Process Data Returned from a Trino Database Processing data returned from a Trino database can seem challenging especially if you are unfamil 2 min read 24-09-2024 22
PL/SQL to Superset/Trino - convert hexadecimal funcion Converting Hexadecimal Functions from PL SQL to Superset Trino Introduction If you are working with databases and data visualization tools its common to face ch 2 min read 19-09-2024 20
Trino | Hive | Minio - Unable to execute HTTP request: Unsupported or unrecognized SSL message Troubleshooting Trino Hive and Minio Resolving the Unable to Execute HTTP Request Unsupported or Unrecognized SSL Message Error In the world of data analytics i 2 min read 16-09-2024 20
How to enable "Use for Hive table metadata" in "AWS Glue Data Catalog settings" using Terraform? How to Enable Use for Hive Table Metadata in AWS Glue Data Catalog Settings Using Terraform When working with AWS Glue Data Catalog one of the important setting 3 min read 15-09-2024 23
Find the node name of the JSON key from nested JSON How to Find the Node Name of a JSON Key in Nested JSON Structures Navigating through nested JSON structures can often be a challenging task especially when you 2 min read 14-09-2024 25
Signoz metric_name encrypted Deciphering Encrypted Metric Names in Signoz A Comprehensive Guide Signoz is a powerful open source observability platform that allows you to monitor and analyz 2 min read 13-09-2024 26
How do you escape underscores and single quotes in Amazon Athena queries? Escaping Underscores and Single Quotes in Amazon Athena Queries Working with special characters in SQL queries can be tricky especially when querying data in Am 2 min read 04-09-2024 20
Use Trino in an Istio Service Mesh, nodes cannot reach each other over pod ip Running Trino in an Istio Service Mesh Overcoming the Pod IP Challenge When deploying Trino within an Istio service mesh you might encounter a common hurdle Tri 2 min read 03-09-2024 14
How to Preserve ORDER BY Logic with Multiple CTEs in Trino? Preserving ORDER BY Logic with Multiple CTEs in Trino When working with multiple Common Table Expressions CTEs in Trino maintaining the desired order of results 3 min read 01-09-2024 22
Athena extract value from nested json with dynamic key Extracting Values from Nested JSON with Dynamic Keys in Athena Working with nested JSON data in Athena can be tricky especially when dealing with dynamic keys T 2 min read 01-09-2024 32
Unable to register Log4j shutdown hook because JVM is shutting down. Using SimpleLogger Unable to register Log4j shutdown hook because JVM is shutting down Deciphering the Log4j Warning Have you encountered the Unable to register Log4j shutdown hoo 3 min read 30-08-2024 20
SQL Error [16777217]: Query failed (#20240710_084433_00075_u2prc): java.io.IOException: Start token not found where expected Decoding the Start token not found where expected Error in Trino with Minio and JSON Data This article explores a common error encountered while working with Tr 3 min read 30-08-2024 13
Athena try_cast is not returning null Why Athenas TRY CAST Isnt Returning Null Unmasking the Invalid Format Error When working with data in Amazon Athena the TRY CAST function is a valuable tool for 2 min read 30-08-2024 21
Trino create custom table Creating Custom Tables in Trino A Deep Dive Trino formerly known as Presto is a distributed SQL query engine renowned for its speed and scalability One of its k 3 min read 30-08-2024 14
Trino + Apache Phoenix: Unable to query Phoenix from Trino container, yet URL is reachable Troubleshooting Trino Apache Phoenix Connectivity Issues A Practical Guide Connecting Trino to an Apache Phoenix database can be a bit tricky and its not always 2 min read 30-08-2024 15
Trino - How do I filter on dates Mastering Date Filtering in Trino A Comprehensive Guide Trino a distributed SQL query engine offers powerful features for data analysis but sometimes even the m 2 min read 30-08-2024 38
Compute a new column to increment/decrement by 1 per row, in respect to a certain row set with a condition Calculating Relative Indices in SQL A Step by Step Guide This article will guide you through a common SQL challenge calculating a relative index for rows based 3 min read 29-08-2024 23
Trino: Exception is not logged (slf4j) in org.eclipse.jetty.io.AbstractConnection class Troubleshooting Trinos Missing Exception Logs in Jetty Trino a distributed SQL query engine leverages Jetty for handling HTTP connections When encountering erro 3 min read 28-08-2024 27
How to make a SQL Query to filter records based on priority conditions? Prioritizing Records in SQL Queries A Practical Guide When working with SQL databases you often need to filter records based on specific conditions Sometimes th 2 min read 28-08-2024 22
Invoking Trino's try_cast() using SQLAlchemy Invoking Trinos try cast using SQL Alchemy When working with Trino you might encounter the need to use its try cast function for safe data type conversions Whil 2 min read 28-08-2024 18
