[
https://issues.apache.org/jira/browse/AIRFLOW-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16824085#comment-16824085
]
Ash Berlin-Taylor commented on AIRFLOW-3994:
--------------------------------------------
Patches to support other backend are welcome.
In this case changing the type of the column from VARCHAR to LONGTEXT or
whatever the oracle equivalent in SQLAlchemy would probably be enough.
> Oracle varchar maxlength exceed
> -------------------------------
>
> Key: AIRFLOW-3994
> URL: https://issues.apache.org/jira/browse/AIRFLOW-3994
> Project: Apache Airflow
> Issue Type: Improvement
> Components: database
> Affects Versions: 1.10.1
> Reporter: Grant McKenzie
> Priority: Minor
>
> Hi
> Setting up airflow against an Oracle server. In Oracle varchar columns are
> limited to 4000 chars, airflow created columns with 5000 chars. Should we
> consider a config setting for max varchar length in the database? I'll
> attempt to manually create the table with 4000 chars.
>
> sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-00910: specified
> len
> gth too long for its datatype [SQL: '\nCREATE TABLE connection (\n\tid
> INTEGER N
> OT NULL, \n\tconn_id VARCHAR2(250 CHAR), \n\tconn_type VARCHAR2(500 CHAR),
> \n\th
> ost VARCHAR2(500 CHAR), \n\tschema VARCHAR2(500 CHAR), \n\tlogin VARCHAR2(500
> CH
> AR), \n\tpassword VARCHAR2(500 CHAR), \n\tport INTEGER, \n\textra
> VARCHAR2(5000
> CHAR), \n\tPRIMARY KEY (id)\n)\n\n']
>
> Thanks!
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
