[HIVE-26046] MySQL's bit datatype is default to void datatype in hive

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.0.0
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Assignee: Butao Zhang
• Reporter: Naveen Gangam
• Created: 18/Mar/22 01:19
• Updated: 08/Sep/22 00:24

Description

describe on a table that contains a "bit" datatype gets mapped to void. We need a explicit conversion logic in the MySQL ConnectorProvider to map it to a suitable datatype in hive.

+-------------------------------+---------------------------------------------------+----------------------------------------------------+
|           col_name            |                     data_type                     |                      comment                       |
+-------------------------------+---------------------------------------------------+----------------------------------------------------+
| tbl_id                        | bigint                                            | from deserializer                                  |
| create_time                   | int                                               | from deserializer                                  |
| db_id                         | bigint                                            | from deserializer                                  |
| last_access_time              | int                                               | from deserializer                                  |
| owner                         | varchar(767)                                      | from deserializer                                  |
| owner_type                    | varchar(10)                                       | from deserializer                                  |
| retention                     | int                                               | from deserializer                                  |
| sd_id                         | bigint                                            | from deserializer                                  |
| tbl_name                      | varchar(256)                                      | from deserializer                                  |
| tbl_type                      | varchar(128)                                      | from deserializer                                  |
| view_expanded_text            | string                                            | from deserializer                                  |
| view_original_text            | string                                            | from deserializer                                  |
| is_rewrite_enabled            | void                                              | from deserializer                                  |
| write_id                      | bigint                                            | from deserializer  

Issue Links

• is blocked by: HIVE-26503 Hive JDBC Storage Handler: Failed to create jdbc table with hive.sql.query
• links to: GitHub Pull Request #3276