You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/04/01 00:32:25 UTC
[jira] [Commented] (HAWQ-546) Client changes to handle \d for Hive
tables
[ https://issues.apache.org/jira/browse/HAWQ-546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15220781#comment-15220781 ]
ASF GitHub Bot commented on HAWQ-546:
-------------------------------------
Github user shivzone commented on the pull request:
https://github.com/apache/incubator-hawq/pull/542#issuecomment-204157333
+1
> Client changes to handle \d for Hive tables
> -------------------------------------------
>
> Key: HAWQ-546
> URL: https://issues.apache.org/jira/browse/HAWQ-546
> Project: Apache HAWQ
> Issue Type: Sub-task
> Components: Hcatalog, PXF
> Reporter: Oleksandr Diachenko
> Assignee: Oleksandr Diachenko
> Fix For: 2.0.0
>
>
> Hawq psql should call pxf_get_item_fields if user passed pattern starring from "hcatalog" to \d command.
> Client should issue query:
> {code}
> SELECT * FROM pxf_get_item_fields('Hive', '*.*');
> path | itemname | fieldname | fieldtype
> ----------+---------------+----------------+-----------------
> default | table1 | s1 | text
> default | table1 | n1 | int4
> default | table1 | d1 | float8
> default | table1 | bg | int8
> default | table1 | b | bool
> default | table2 | a | int4
> default | table2 | b | int4
> default | table3 | a | int4
> default | table3 | b | int4
> userdb | table1 | id | int4
> userdb | table1 | name | text
> (15 rows)
> {code}
> Client output should look like:
> {code}
> \d hcatalog.*.*
> PXF Hive Table "default.table1"
> Column | Type
> --------+--------
> s1 | text
> n1 | int4
> d1 | float8
> bg | int8
> b | bool
> PXF Hive Table "default.table2"
> Column | Type
> --------+------
> a | int4
> b | int4
> PXF Hive Table "default.table3"
> Column | Type
> --------+------
> a | int4
> b | int4
> PXF Hive Table "userdb.table1"
> Column | Type
> --------+------
> id | int4
> name | text
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)