You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Naveen Gangam (Jira)" <ji...@apache.org> on 2022/03/18 01:20:00 UTC
[jira] [Created] (HIVE-26046) MySQL's bit datatype is default to void datatype in hive
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)