durango

Go Cheat Sheet

Index

1. Basic Syntax
2. Operators

• Arithmetic
• Comparison
• Logical
• Other

3. Declarations

durango

Go Cheat Sheet

Index

1. Basic Syntax
2. Operators

• Arithmetic
• Comparison
• Logical
• Other

3. Declarations

durango

Presto Specific

• Don’t SELECT *, Specify explicit column names (columnar store)
• Avoid large JOINs (filter each table first)
  • In PRESTO tables are joined in the order they are listed!!
  • Join small tables earlier in the plan and leave larger fact tables to the end
  • Avoid cross joins or 1 to many joins as these can degrade performance
• Order by and group by take time
  • only use order by in subqueries if it is really necessary
• When using GROUP BY, order the columns by the highest cardinality (that is, most number of unique values) to the lowest.

durango

Mozilla Public License, version 2.0

1. Definitions

1.1. "Contributor"

     means each individual or legal entity that creates, contributes to the
     creation of, or owns Covered Software.

1.2. "Contributor Version"