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)