You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2022/09/08 00:25:00 UTC

[jira] [Work logged] (HIVE-26046) MySQL's bit datatype is default to void datatype in hive

     [ https://issues.apache.org/jira/browse/HIVE-26046?focusedWorklogId=806861&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-806861 ]

ASF GitHub Bot logged work on HIVE-26046:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 08/Sep/22 00:24
            Start Date: 08/Sep/22 00:24
    Worklog Time Spent: 10m 
      Work Description: github-actions[bot] closed pull request #3276: HIVE-26046: MySQL's bit datatype is default to void datatype in hive
URL: https://github.com/apache/hive/pull/3276




Issue Time Tracking
-------------------

    Worklog Id:     (was: 806861)
    Time Spent: 5h  (was: 4h 50m)

> 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
>            Assignee: zhangbutao
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 5h
>  Remaining Estimate: 0h
>
> 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.10#820010)