[
https://issues.apache.org/jira/browse/HAWQ-465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15205509#comment-15205509
]
ASF GitHub Bot commented on HAWQ-465:
-------------------------------------
GitHub user sansanichfb opened a pull request:
https://github.com/apache/incubator-hawq/pull/479
HAWQ-465. Implement stored procedure to return fields metainfo from PXF.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sansanichfb/incubator-hawq HAWQ-465
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/479.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #479
----
commit 4d4cd047d4d89aaa434fe187bc504d066b512ec6
Author: Oleksandr Diachenko <odiache...@pivotal.io>
Date: 2016-03-08T01:00:00Z
HAWQ-465. Implement stored procedure to return fields metainfo from PXF.
----
> Implement stored procedure to return fields metainfo from PXF
> -------------------------------------------------------------
>
> Key: HAWQ-465
> URL: https://issues.apache.org/jira/browse/HAWQ-465
> Project: Apache HAWQ
> Issue Type: Sub-task
> Components: Hcatalog, PXF
> Reporter: Oleksandr Diachenko
> Assignee: Oleksandr Diachenko
> Fix For: 2.0.0
>
>
> User should be able to call built-in function:
> {code}
> select pxf_get_object_fields('source_name', 'container_name', 'object_name');
> pxf_get_object_fields
> {code}
> to retrieve all metadata for given source, container, object.
> Input parameters:
> ||Name||Type||Mode||
> |profile|text|IN|
> |pattern|text|IN|
> |path|text|OUT|
> |objectname|text|OUT|
> |fieldname|text|OUT|
> |fieldtype|text|OUT|
> |fieldmodifiers|text|OUT|
> Example:
> {noformat}
> # select * from pxf_get_object_fields('Hive', 'default/tab*');
> path | objectname | fieldname | fieldtype | fieldmodifiers |
> ---------+-----------------+------------------
> +----------------+-------------------+
> default | table1 | col1 | int4 | not
> null |
> default | table1 | col2 | text |
> |
> default | table2 | col1 | int4 | not
> null |
> default | table2 | col2 | text |
> |
> (4 rows)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
