[jira] [Comment Edited] (HAWQ-393) HAWQ access of hcatalog metadata using \d

["Michael Andre Pearce (IG) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HAWQ-393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15234475#comment-15234475 ] 

Michael Andre Pearce (IG) edited comment on HAWQ-393 at 4/11/16 4:20 AM:
-------------------------------------------------------------------------

Does this fix the issue where by tools like tableau using postgres or greenplum odbc clients try to connect to hawq and automatically issue \d as they populate a drop down in the ui for schema and table as part of the setting up a new data source flow ?

Has this been tested with such a tool?




was (Author: michael.andre.pearce):
Does this fix the issue where by tools like tableau using postgres or greenplum odbc clients try to connect to hawq and automatically issue \d  ?

Has this been tested with such a tool?



> 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)