[
https://issues.apache.org/jira/browse/HAWQ-393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15287043#comment-15287043
]
Goden Yao edited comment on HAWQ-393 at 5/17/16 5:22 PM:
---------------------------------------------------------
1. latest build - do you mean the one you download from network.pivotal.io or
you build from asf repo?
2. when you say you could connect to database "hcatalog" before, what was the
build you used? we never allowed connecting to this "hcatalog" database
3. the current implementation on HAWQ client is to invoke a store proc
"pxf_get_fields"... so when you "\d" on hawq client, it shows hcatalog metadata
seemlessly as other databases. for other compatible client , they need to call
the same store proc to get the info.
was (Author: godenyao):
1. latest build - do you mean the one you download from PivNet or you build
from asf repo?
2. when you say you could connect to database "hcatalog" before, what was the
build you used? we never allowed connecting to this "hcatalog" database
3. the current implementation on HAWQ client is to invoke a store proc
"pxf_get_fields"... so when you "\d" on hawq client, it shows hcatalog metadata
seemlessly as other databases. for other compatible client , they need to call
the same store proc to get the info.
> 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)
