eric-wang-1990 opened a new pull request, #2766: URL: https://github.com/apache/arrow-adbc/pull/2766
Description: This PR adds a new metadata API GetColumnsExtended to the Apache Hive2 driver. This consolidated metadata query combines column information with primary key and foreign key relationships, allowing clients to retrieve complete column metadata in a single call. Changes: New Metadata Command: Added GetColumnsExtended to the list of supported metadata commands Consolidated Query Implementation: The new method retrieves and combines data from: GetColumns - Basic column metadata GetPrimaryKeys - Primary key information GetCrossReference - Foreign key relationships Schema Enhancement: Added prefixed fields to the schema: PK_COLUMN_NAME, PK_KEY_SEQ for primary key information FK_PKCOLUMN_NAME, FK_PKTABLE_CAT, FK_PKTABLE_SCHEM, FK_PKTABLE_NAME, FK_FKCOLUMN_NAME for foreign key information Relationship Mapping: Each column is matched with its corresponding PK/FK data (if any) Unified Result Set: All data is combined into a single Arrow RecordBatch Benefits: Reduced API calls: Clients can fetch complete column information with 1 call instead of 3 Simplified client code: No need to manually join metadata from multiple queries Complete column context: Get column type information along with its relationships Better performance: Reduces network round-trips for metadata operations Testing: Added tests in StatementTests.cs to verify that the extended fields are correctly populated Tested with tables containing primary and foreign keys to ensure correctness -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@arrow.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
