New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG] Tools should be able to recognize dataType aliases #1492

Open

amahussein opened this issue Jan 9, 2025 · 0 comments

Labels

? - Needs Triage bug core_tools

Collaborator

amahussein commented Jan 9, 2025

Describe the bug

The SQL spark define aliases for some datatypes. The tools should be able to recognize the mapping in order to accurately get accurate estimation

Data Type	Aliases
Numeric Types
ByteType	`TINYINT`
ShortType	`SMALLINT`
IntegerType	`INT`, `INTEGER`
LongType	`BIGINT`
FloatType	`FLOAT`, `REAL`
DoubleType	`DOUBLE`
DecimalType	`DECIMAL`, `NUMERIC`
String and Binary
StringType	`STRING`, `VARCHAR`, `CHAR`
BinaryType	`BINARY`
Date and Time
DateType	`DATE`
TimestampType	`TIMESTAMP`
TimestampNTZType	`TIMESTAMP WITHOUT TIME ZONE`
Boolean
BooleanType	`BOOLEAN`
Complex Types
ArrayType	`ARRAY`
MapType	`MAP`
StructType	`STRUCT`
NullType	`NULL`
Other Types
BinaryType	`BLOB`
IntervalType	`INTERVAL`

The text was updated successfully, but these errors were encountered:

amahussein added ? - Needs Triage bug core_tools labels

amahussein mentioned this issue

Sync plugin support as of 2024-12-31 #1478

Draft

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment