https://linen.dev logo
s

Sunny J

10/15/2021, 5:02 PM
Is it possible to manually overwrite the schema creation?
u

user

10/16/2021, 9:22 AM
The schema is auto detected based on
JDBCType
. It looks like there may be an edge case here. Relevant code here: https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/s[…]ava/io/airbyte/integrations/source/jdbc/AbstractJdbcSource.java
s

Sunny J

10/16/2021, 9:23 AM
If the type cannot be resolved, it defaults to
varchar
.
u

user

10/16/2021, 9:23 AM
Do you see anything like this in the log?
Could not convert column: %s from table: %s.%s with type: %s. Casting to VARCHAR.
u

user

10/16/2021, 9:24 AM
The exact log line will help us find out what the parsed type is.
u

user

10/17/2021, 8:00 AM
Hi Liren, Thanks for your reply, I have sent the logs and schema screenshot in personal chat.
u

user

10/17/2021, 8:12 AM
btw, I don’t see that error in log
s

Sunny J

10/17/2021, 8:12 AM
I just see,
Copy code
Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
u

user

10/19/2021, 6:21 PM
@Liren Tu did you got a chance to look at what might be causing such behaviour? Please can you guide me
u

user

10/19/2021, 7:28 PM
This “Unknown keyword order” is not relevant. It’s strange that the “Could not convert column” warning does not exist in the log.
u

user

10/19/2021, 7:28 PM
Would you mind telling us what’s the Postgres version you are running?
u

user

10/19/2021, 8:28 PM
I created an issue here for tracking: https://github.com/airbytehq/airbyte/issues/7187
u

user

10/20/2021, 11:07 AM
Thanks Liren
u

user

10/20/2021, 11:07 AM
Postgres version 13.3 AWS RDS
Copy code
SELECT version();
"PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-12), 64-bit"
4 Views