Naveen Gangam created HIVE-26046:
------------------------------------
Summary: MySQL's bit datatype is default to void datatype in hive
Key: HIVE-26046
URL: https://issues.apache.org/jira/browse/HIVE-26046
Project: Hive
Issue Type: Sub-task
Components: Standalone Metastore
Affects Versions: 4.0.0
Reporter: Naveen Gangam
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.
{noformat}
+-------------------------------+---------------------------------------------------+----------------------------------------------------+
| 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
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)