[
https://issues.apache.org/jira/browse/HAWQ-465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15207577#comment-15207577
]
ASF GitHub Bot commented on HAWQ-465:
-------------------------------------
Github user sansanichfb commented on the pull request:
https://github.com/apache/incubator-hawq/pull/479#issuecomment-200087621
@hornn we are not caching metadata in this stored procedure, we just use
the same code path as for select from Hive tables, also we made it more
generic. Please refer to JIRA https://issues.apache.org/jira/browse/HAWQ-393
and to design doc
https://docs.google.com/document/d/1-P9eEfcS9SZGDMDRNc3xt8cluDL-BghICRhYz9F-MLU/edit.
> 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)
