Arvind Kandpal created AMBARI-26665:
---------------------------------------

             Summary: Oracle DDL script uses unsupported BIGINT data type
                 Key: AMBARI-26665
                 URL: https://issues.apache.org/jira/browse/AMBARI-26665
             Project: Ambari
          Issue Type: Bug
            Reporter: Arvind Kandpal


Ambari-DDL-Oracle-CREATE.sql uses BIGINT for three columns:
  - registries.id
  - mpacks.id
  - mpacks.registry_id

  Oracle does not support the BIGINT data type, so the registries and
  mpacks tables are not created when the script runs. The tables that
  depend on them are not created either, and Ambari Server fails to start
  on Oracle.

  The rest of the Oracle DDL uses NUMBER(19) for these kinds of columns.

  Steps to reproduce:
  1. Run Ambari-DDL-Oracle-CREATE.sql with sqlplus on Oracle.
  2. Creating the registries and mpacks tables fails with an invalid
     datatype error.




--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to