Advance Analytical Functions | Snowflake | AWS Redshift | Google Bigquery | Databricks | Oracle | Exasol |
---|---|---|---|---|---|---|
MATCH_RECOGNIZE | ✅ | ❌ | ❌ | ❌ | ✅ | ❌ |
QUALIFY | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
SKYLINE | ❌ | ❌ | ❌ | ❌ | ❌ | ✅ |
GRAPH_TABLE | ❌ | ❌ | ❌ | ❌ | ✅ | ❌ |
MIN_BY / MAX_BY | ✅ | ❌ | ✅ | ✅ | ❌ | ❌ |
GROUP BY CUBE | ✅ | ❌ | ✅ | ✅ | ✅ | ✅ |
GROUP BY ROLLUP | ✅ | ❌ | ✅ | ✅ | ✅ | ✅ |
GROUP BY GROUPING SETS | ✅ | ❌ | ✅ | ✅ | ✅ | ✅ |
CONDITIONAL_TRUE_EVENT | ✅ | ❌ | ❌ | ❌ | ❌ | ❌ |
CONDITIONAL_CHANGE_EVENT | ✅ | ❌ | ❌ | ❌ | ❌ | ❌ |
IS DISTINCT FROM / IS NOT DISTINCT FROM | ✅ | ❌ | ✅ | ✅ | ❌ | ❌ |