[
https://issues.apache.org/jira/browse/HAWQ-465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Diachenko updated HAWQ-465:
-------------------------------------
Description:
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:
# 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)
was:
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:
# 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)
> 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:
> # 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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
