What information we need from you for help with SQL query issues

[alberttwong]

As a policy, we do not provide community support for SQL and SQL performance related issues.

We assume that your have knowledge of OLAP databases

• the different types of tables and their pros/cons
• OLTP and OLAP differences on how data is inserted onto disk and read from disk
• how different data types affect performance,
• how picking good distribution and partition key affect query performance,
• how rewriting SQL queries can lead to better performance,
• how different type of JOINs affect performance,
• how picking the k8s operator or linux binary deployments affect performance,
• how picking different vm types affect performance,
• the amount of nodes and amount of replicas affect performance
• understanding the different characters of various open table formats like Apache Iceberg, Apache Hudi, Apache Hive and Delta Lake
• etc etc.

Generally speaking, we don't have enough information to help you. You have to tell us the architecture, what is your schema, what type of workload patterns and queries you are running and what you're trying to solve.

Note

Here are some general best practices #22765