This is an automated email from the ASF dual-hosted git repository. beto pushed a commit to branch db-diagnostics in repository https://gitbox.apache.org/repos/asf/superset.git
The following commit(s) were added to refs/heads/db-diagnostics by this push:
new df06bb3bfb Add table
df06bb3bfb is described below
commit df06bb3bfb4fc316f44e0e5b2123df070d13a8cd
Author: Beto Dealmeida <[email protected]>
AuthorDate: Tue Jul 25 17:02:53 2023 -0700
Add table
---
superset/db_engine_specs/README.md | 61 ++++++++++++++++++++++++++++++++++++++
1 file changed, 61 insertions(+)
diff --git a/superset/db_engine_specs/README.md
b/superset/db_engine_specs/README.md
index 863404f4a4..e6aba4b6f7 100644
--- a/superset/db_engine_specs/README.md
+++ b/superset/db_engine_specs/README.md
@@ -31,5 +31,66 @@ Over time, more and more functionality was added to DB
engine specs, including v
Note that DB engine specs are completely optional. Superset can connect to any
database supported by SQLAlchemy (or 3rd party dialects) even if there's no DB
engine spec associated with it. But DB engine specs greatly improve the
experience of working with a database in Superset.
+Features
+--------
+
+| | Details
| Base | Amazon
Athena | Amazon DynamoDB | Amazon Redshift
| Apache Drill | Apache Druid
| Apache Hive | Apache Impala | Apache
Kylin | Apache Pinot | Apache Solr
| Apac [...]
+|----------------------------|----------------------------------------------------------------------------------------|-------------------------------|---------------------------------|-----------------------------------|-----------------------------------|--------------------------------|--------------------------------|-------------------------------|---------------------------------|--------------------------------|--------------------------------|-------------------------------|-----
[...]
+| Module |
| superset.db_engine_specs.base |
superset.db_engine_specs.athena | superset.db_engine_specs.dynamodb |
superset.db_engine_specs.redshift | superset.db_engine_specs.drill |
superset.db_engine_specs.druid | superset.db_engine_specs.hive |
superset.db_engine_specs.impala | superset.db_engine_specs.kylin |
superset.db_engine_specs.pinot | superset.db_engine_specs.solr | supe [...]
+| Limit method | In general, FORCE_LIMIT > WRAP_SQL > FETCH_MANY
| FETCH_MANY |
FORCE_LIMIT | FORCE_LIMIT |
FORCE_LIMIT | FORCE_LIMIT |
FORCE_LIMIT | FORCE_LIMIT | FORCE_LIMIT
| FORCE_LIMIT | FORCE_LIMIT
| FORCE_LIMIT | FORC [...]
+| Joins |
| TRUE |
TRUE | TRUE |
TRUE | TRUE | FALSE
| TRUE | TRUE |
TRUE | FALSE | FALSE
| [...]
+| Subqueries |
| TRUE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | FALSE | FALSE
| [...]
+| Alias in SELECT |
| TRUE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | FALSE | TRUE
| [...]
+| Alias in ORDER BY |
| TRUE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | FALSE | TRUE
| [...]
+| Secondary time columns |
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| Time GROUP BY inline |
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| Alias to source column |
| TRUE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| ORDER BY must be in SELECT |
| FALSE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| FALSE | TRUE |
TRUE | TRUE | TRUE
| [...]
+| Expression in ORDER BY |
| TRUE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| CTE in subquery |
| TRUE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | TRUE
| [...]
+| LIMIT clause |
| TRUE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | TRUE
| [...]
+| Maximum column name |
| |
| |
127 | |
| 767 | |
| |
| [...]
+| Comments |
| TRUE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | TRUE
| [...]
+| Escaped colons |
| TRUE |
FALSE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | TRUE
| [...]
+| Time grains | SECOND
| FALSE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | FALSE |
TRUE | TRUE | FALSE
| [...]
+| | FIVE_SECONDS
| FALSE |
FALSE | FALSE |
FALSE | FALSE | TRUE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| | THIRTY_SECONDS
| FALSE |
FALSE | FALSE |
FALSE | FALSE | TRUE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| | MINUTE
| FALSE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | FALSE
| [...]
+| | FIVE_MINUTES
| FALSE |
FALSE | FALSE |
FALSE | FALSE | TRUE
| FALSE | FALSE |
FALSE | TRUE | FALSE
| [...]
+| | TEN_MINUTES
| FALSE |
FALSE | FALSE |
FALSE | FALSE | TRUE
| FALSE | FALSE |
FALSE | TRUE | FALSE
| [...]
+| | FIFTEEN_MINUTES
| FALSE |
FALSE | FALSE |
FALSE | TRUE | TRUE
| FALSE | FALSE |
FALSE | TRUE | FALSE
| [...]
+| | THIRTY_MINUTES
| FALSE |
FALSE | FALSE |
FALSE | TRUE | TRUE
| FALSE | FALSE |
FALSE | TRUE | FALSE
| [...]
+| | HALF_HOUR
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| | HOUR
| FALSE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | FALSE
| [...]
+| | SIX_HOURS
| FALSE |
FALSE | FALSE |
FALSE | FALSE | TRUE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| | DAY
| FALSE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | FALSE
| [...]
+| | WEEK
| FALSE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | FALSE
| [...]
+| | WEEK_STARTING_SUNDAY
| FALSE |
TRUE | TRUE |
FALSE | FALSE | TRUE
| TRUE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| | WEEK_STARTING_MONDAY
| FALSE |
FALSE | TRUE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| | WEEK_ENDING_SATURDAY
| FALSE |
TRUE | TRUE |
FALSE | FALSE | TRUE
| TRUE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| | WEEK_ENDING_SUNDAY
| FALSE |
FALSE | TRUE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| | MONTH
| FALSE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | FALSE
| [...]
+| | QUARTER
| FALSE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | FALSE
| [...]
+| | QUARTER_YEAR
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| | YEAR
| FALSE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | FALSE
| [...]
+| Mask encrypted_extra |
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| Column type mapping |
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| TRUE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| Function names |
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| TRUE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| User impersonation |
| TRUE |
FALSE | FALSE |
FALSE | TRUE | FALSE
| TRUE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| File upload |
| TRUE |
TRUE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | TRUE
| [...]
+| Extra table metadata |
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| DB API exception mapping |
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| Custom errors |
| FALSE |
TRUE | FALSE |
TRUE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| Dynamic schema |
| FALSE |
FALSE | FALSE |
FALSE | TRUE | FALSE
| TRUE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| Catalog |
| FALSE |
FALSE | FALSE |
TRUE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| Dynamic catalog |
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| SSH tunneling |
| FALSE |
FALSE | TRUE |
TRUE | TRUE | TRUE
| TRUE | TRUE |
TRUE | TRUE | TRUE
| [...]
+| Query cancelation |
| FALSE |
FALSE | FALSE |
TRUE | FALSE | FALSE
| TRUE | TRUE |
FALSE | FALSE | FALSE
| [...]
+| Get metrics | Returns metrics when a dataset is first added.
Currently used only in 3rd party specs. | COUNT(*) |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| WHERE latest partition |
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| TRUE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| Expand complex data types | This could have a single implementation for all
specs, instead of being per-spec. | FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| Query cost estimation |
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+| SQL validation | Implemented outside the spec.
| FALSE |
FALSE | FALSE |
FALSE | FALSE | FALSE
| FALSE | FALSE |
FALSE | FALSE | FALSE
| [...]
+
