[HAWQ-393] HAWQ access of hcatalog metadata using \d

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Hcatalog, PXF
• Assignee: Oleksandr Diachenko
• Reporter: Goden Yao
• Created: 03/Feb/16 21:29
• Updated: 14/Jul/16 17:46
• Resolved: 09/May/16 21:58

Description

As a Hawq user, after enabling hcatalog integration feature,
I want to be able to display (\d) tables in hcatalog so that I know what tables are available and the contents of their schemas.

Acceptance Criteria
1. Ability to describe a single table.

\d hcatalog.databaseName.t1

,

\d+ hcatalog.databaseName.t1

2. Ability to describe the every table in a database of hcatalog:

\d hcatalog.databaseName.*

3. Ability to list tables that match patterns (only wildcard is supported)
e.g.

\d hcatalog.databaseName.prefix_*

4. Ability to list databases in hcatalog:

\d hcatalog.*

5. Tab autocomplete of items from hcatalog. (optional)

[1] based on current implementation, we cache the meta data from hcatalog within the same transaction.

Issue Links

• links to: Design document

Sub-Tasks

• Enhance Metadata Rest API to support table(s): Resolved
• Implement stored procedure to return fields metainfo from PXF: Resolved
• Client changes to handle \d for Hive tables: Resolved
• Fix coverity issues: Resolved
• PXF getMetadata endpoint fails if set of items described by passed pattern have unsupported by Hawq Hive objects: Closed