module 'sqlalchemy.types' has no attribute 'DOUBLE'

[piby180]

Affected module
Does it impact the UI, backend or Ingestion Framework?
ingestion

Describe the bug
A clear and concise description of what the bug is.

sqlalchemy.type.DOUBLE works with sqlalchemy >= 2.0.0. But the sqlalchemy = 1.4.54 is installed in openmetadata/ingestion=1.12.5

This causes issue here

OpenMetadata/ingestion/src/metadata/ingestion/source/database/pinotdb/metadata.py

Line 33 in cfd71e8

"double": types.DOUBLE,

Also, pinotdb=5.7.0 is pretty old and it should be updated to the latest version (9.1.1)

> processor='yield_table' nullable=False must_return=False overwrite=True consumer=['database_service', 'database', 'database_schema'] context='table' store_all_in_context=False clear_context=False store_fqn=False cache_entities=False use_cache=True
[2026-04-14 09:30:05] DEBUG    {metadata.Ingestion:sql_column_handler:296} - Traceback (most recent call last):
  File "/home/airflow/.local/lib/python3.10/site-packages/metadata/ingestion/source/database/sql_column_handler.py", line 292, in get_columns_and_constraints
    columns = self._get_columns_internal(
  File "/home/airflow/.local/lib/python3.10/site-packages/metadata/ingestion/source/database/sql_column_handler.py", line 238, in _get_columns_internal
    return inspector.get_columns(
  File "/home/airflow/.local/lib/python3.10/site-packages/sqlalchemy/engine/reflection.py", line 497, in get_columns
    col_defs = self.dialect.get_columns(
  File "/home/airflow/.local/lib/python3.10/site-packages/pinotdb/sqlalchemy.py", line 280, in get_columns
    columns = [
  File "/home/airflow/.local/lib/python3.10/site-packages/pinotdb/sqlalchemy.py", line 283, in <listcomp>
    "type": get_type(spec["dataType"], spec.get("fieldSize")),
  File "/home/airflow/.local/lib/python3.10/site-packages/metadata/ingestion/source/database/pinotdb/metadata.py", line 33, in get_type_custom
    "double": types.DOUBLE,
AttributeError: module 'sqlalchemy.types' has no attribute 'DOUBLE'

To Reproduce

Screenshots or steps to reproduce

Use openmetadata/ingestion=1.12.5 and try to ingest pinot tables to OM

Expected behavior
A clear and concise description of what you expected to happen.

This bug should be resolved

Version:

• OS: [e.g. iOS] Docker
• Python version: 3.10.19
• OpenMetadata version: [e.g. 0.8] 1.12.5
• OpenMetadata Ingestion package version: [e.g. openmetadata-ingestion[docker]==XYZ] openmetadata-ingestion[docker]==1.12.5

Additional context
Add any other context about the problem here.
Slack Thread : https://openmetadata.slack.com/archives/C02B6955S4S/p1776160249872429

[piby180]

This relates to the following commit.
5eb553a

sqlalchemy >= 2.0.0 in order to use types.DOUBLE

[mohitjeswani01]

hey @piby180 @nikhilchennam may i work on this issue ?

[ulixius9]

closing by #27367