cshuo commented on issue #18974: URL: https://github.com/apache/hudi/issues/18974#issuecomment-4687023176
## 1. ANSI / ISO SQL Standard (2023) | Type | Standard | Typical meaning | |---|---|---| | `TINYINT` | No | Non-standard extension, usually an 8-bit signed integer | | `SMALLINT` | Yes | Standard exact numeric type, usually implemented as a 16-bit signed integer | ## 2. Big Data Engines and Apache Arrow | System | `TINYINT` | `SMALLINT` | Type mapping | |---|---|---|---| | Apache Hive | Yes | Yes | 8-bit / 16-bit signed integer | | Apache Spark SQL | Yes | Yes | `ByteType` / `ShortType` | | Apache Flink SQL | Yes | Yes | Java `Byte` / `Short` | | Trino / Presto | Yes | Yes | 8-bit / 16-bit signed integer | | Apache Impala | Yes | Yes | 1-byte / 2-byte signed integer | | Apache Doris | Yes | Yes | 8-bit / 16-bit signed integer | | StarRocks | Yes | Yes | 1-byte / 2-byte signed integer | | Apache Arrow | `Int8` | `Int16` | Uses explicit bit-width types instead of SQL type names | -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
