[
https://issues.apache.org/jira/browse/HAWQ-465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15206984#comment-15206984
]
ASF GitHub Bot commented on HAWQ-465:
-------------------------------------
Github user hornn commented on a diff in the pull request:
https://github.com/apache/incubator-hawq/pull/479#discussion_r57043174
--- Diff: src/include/catalog/namespace.h ---
@@ -95,4 +95,6 @@ extern char *namespace_search_path;
extern List *fetch_search_path(bool includeImplicit);
+#define HiveProfileName "Hive"
--- End diff --
why is it defined here? shouldn't it be in a less general location, as it's
only used by pxf/hcatalog?
> 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)
