- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2022 03:04 AM
Greetings,
In the documentation for Databricks SQL it states that it supports JDBC connections, however when connecting to AWS Redshift via the built in PostgreSQL driver ("CREATE TABLE sample USING JDBC" and "jdbc://postgresql:/..." URI) I'm getting a weird error as follows:
"
org.apache.spark.sql.AnalysisException:
The user-specified schema doesn't match the actual schema:
user-specified: `id` INT, (...other columns edited out), actual: `id` INT, (...other columns edited out). If you're using
DataFrameReader.schema API or creating a table, please do not specify the schema.
Or if you're scanning an existed table, please drop it and re-create it.
"
The list of columns were edited out but it is exactly the same list in "user-specified" and in "actual", seems like rather some internal detail is different rather than the printed DDL.
Does this mean that currently there is no way to query AWS Redshift as external data store from Databricks SQL?
Thanks,
Cristian
- Labels:
-
Databricks SQL
-
Int
-
SQL