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)

Reply via email to