You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Dmitriy Fingerman (Jira)" <ji...@apache.org> on 2025/11/07 14:53:00 UTC

[jira] [Updated] (HIVE-29296) Remove getPrimaryKeys codes from beeline module

     [ https://issues.apache.org/jira/browse/HIVE-29296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dmitriy Fingerman updated HIVE-29296:
-------------------------------------
    Fix Version/s: 4.2.0
       Resolution: Fixed
           Status: Resolved  (was: Patch Available)

> Remove getPrimaryKeys codes from beeline module
> -----------------------------------------------
>
>                 Key: HIVE-29296
>                 URL: https://issues.apache.org/jira/browse/HIVE-29296
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 4.1.0
>            Reporter: Butao Zhang
>            Assignee: Butao Zhang
>            Priority: Major
>              Labels: hive-4.2.0-must, pull-request-available
>             Fix For: 4.2.0
>
>
> If you send a select query from Beeline client with --color, you can see exception in HS2 logs:
> {code:java}
> ./apache-hive-beeline-4.2.0-SNAPSHOT/bin/beeline -u "jdbc:hive2://127.0.0.1:10000/default hive" --color{code}
> 2025-09-18T16:22:34,121 ERROR [HiveServer2-Handler-Pool: Thread-166] thrift.ThriftCLIService: Failed to get primary keys [request: TGetPrimaryKeysReq(sessionHandle:TSessionHandle(sessionId:THandleIdentifier(guid:56 22 37 10 00 2D 4B BB B6 FE 42 49 E2 25 75 1F, secret:C7 E6 BF 96 D1 82 4E F5 82 36 AC A7 A1 3E 7A A6)), catalogName:, tableName:test12)]
> org.apache.hive.service.cli.HiveSQLException: org.apache.thrift.protocol.TProtocolException: Required field 'db_name' is unset! Struct:PrimaryKeysRequest(db_name:null, tbl_name:test12, catName:hive)
>  
> As i said in HIVE-29213 https://issues.apache.org/jira/browse/HIVE-29213?focusedCommentId=18033761&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-18033761 
>  
> I believe retrieving the primary key of a table on the beeline side is meaningless (the original purpose was only for coloring the beeline output).
> {color:#172b4d}We do not need to investigate how to retrieve the correct db_name to ensure the method _HiveDatabaseMetaData::getPrimaryKeys(String catalog, String schema, String table)_ executes properly. {*}I believe removing this code logic would suffice{*}.{color}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)