Special characters in AWS Athena show up as question marks Why Special Characters in AWS Athena Show Up as Question Marks A Troubleshooting Guide Have you ever encountered a frustrating scenario where special characters 2 min read 06-10-2024 11
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
Athena Query - "NOT IN" slow performance Unleashing the Power of Athena Optimizing NOT IN Queries for Speed Athena Amazons serverless query engine for analyzing data stored in S3 offers a powerful way 2 min read 05-10-2024 10
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
Failed to check the authorization for topic: The credential information is empty Understanding the Issue Failed to Check the Authorization for Topic The Credential Information is Empty When developing applications that communicate over messa 2 min read 25-09-2024 17
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
Amazon athena, presto sql :INVALID_FUNCTION_ARGUMENT: Cannot unnest type: varchar Understanding the Invalid Function Argument Error in Amazon Athena and Presto SQL When working with Amazon Athena or Presto SQL users often encounter various ty 2 min read 14-09-2024 45
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
Presto query Array of Rows Querying Array of Rows in Presto A Comprehensive Guide When working with big data frameworks tools like Presto and Hive provide powerful capabilities to query s 3 min read 06-09-2024 17
date_trunc in hive is working incorrectly Understanding the date trunc Function in Hive Resolving Common Issues In Hive the date trunc function is commonly used to truncate a date to a specified unit su 2 min read 05-09-2024 20
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
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
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 - 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
