[
https://issues.apache.org/jira/browse/HAWQ-393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15287085#comment-15287085
]
Michael Andre Pearce (IG) edited comment on HAWQ-393 at 5/17/16 5:39 PM:
-------------------------------------------------------------------------
Hi Goden,
1 - network.pivotal.io HDB 2.0 GA
2 - network.pivotal.io 2.0 Beta 1 - we were able to make odbc connection to
hawq and connect to database hcatalog.
3 - as such this is indeed my original question was this done within the client
or server side, e.g. as such odbc and other clients invoking hawq via standard
clients e.g. tableau would be able to resolve the tables.
was (Author: michael.andre.pearce):
Hi Gode,
1 - network.pivotal.io HDB 2.0 GA
2 - network.pivotal.io 2.0 Beta 1 - we were able to make odbc connection to
hawq and connect to database hcatalog.
3 - as such this is indeed my original question was this done within the client
or server side, e.g. as such odbc and other clients invoking hawq via standard
clients e.g. tableau would be able to resolve the tables.
> HAWQ access of hcatalog metadata using \d
> -----------------------------------------
>
> Key: HAWQ-393
> URL: https://issues.apache.org/jira/browse/HAWQ-393
> Project: Apache HAWQ
> Issue Type: New Feature
> Components: Hcatalog, PXF
> Reporter: Goden Yao
> Assignee: Oleksandr Diachenko
> Fix For: 2.0.0
>
>
> 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.
> {code}
> \d hcatalog.databaseName.t1
> {code},
> {code}
> \d+ hcatalog.databaseName.t1
> {code}
> 2. Ability to describe the every table in a database of hcatalog:
> {code}
> \d hcatalog.databaseName.*
> {code}
> 3. Ability to list tables that match patterns (only wildcard is supported)
> e.g.
> {code}
> \d hcatalog.databaseName.prefix_*
> {code}
> 4. Ability to list databases in hcatalog:
> {code}
> \d hcatalog.*
> {code}
> 5. Tab autocomplete of items from hcatalog. (optional)
> [1] based on current implementation, we cache the meta data from hcatalog
> within the same transaction.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
