inspector.get_columns() returns float for double data type #647
Description
For columns with type 'double', get_columns() returns 'float' instead of double. I have not checked if this error happens for other data types also.
Usage:
inspector = inspect(self.engine)
return inspector.get_columns(table_name, schema=schema)
Table DDL:
CREATE TABLE test (
test double
)
LOCATION 's3://.......'
TBLPROPERTIES (
'table_type'='iceberg',
'write_compression'='zstd'
);
Expected output:
[{'name': 'test',
'type': DOUBLE(),
'nullable': True,
'default': None,
'autoincrement': False,
'comment': None,
'dialect_options': {'awsathena_partition': None}}]
Acquired output:
[{'name': 'test',
'type': FLOAT(), # Unexpected
'nullable': True,
'default': None,
'autoincrement': False,
'comment': None,
'dialect_options': {'awsathena_partition': None}}]