[jira] [Commented] (AIRFLOW-3994) Oracle varchar maxlength exceed

["jack (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AIRFLOW-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16824047#comment-16824047 ] 

jack commented on AIRFLOW-3994:
-------------------------------

Oracle is not supported as backend. Use MySQL or PostgreSQL.



Xcom for example can be longer than 4000 chars (for example in GCS download operator).

> 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)