You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "Grant McKenzie (JIRA)" <ji...@apache.org> on 2019/03/02 04:07:00 UTC

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

Grant McKenzie created AIRFLOW-3994:
---------------------------------------

             Summary: 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


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)