[
https://issues.apache.org/jira/browse/HAWQ-1314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Diachenko resolved HAWQ-1314.
---------------------------------------
Resolution: Fixed
> Post-upgrade pxf_get_item_fields function break
> -----------------------------------------------
>
> Key: HAWQ-1314
> URL: https://issues.apache.org/jira/browse/HAWQ-1314
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Catalog, Hcatalog, PXF
> Reporter: Gagan Brahmi
> Assignee: Oleksandr Diachenko
> Fix For: 2.2.0.0-incubating
>
>
> After upgrading from HDB 2.0.0.0 to 2.0.1.0 the pxf_get_item_fields function
> stopped working. The following is the message reported:
> {code}
> postgres=# SELECT * FROM pxf_get_item_fields('Hive','default.hive_table');
> ERROR: function return row and query-specified return row do not match
> DETAIL: Returned row contains 5 attributes, but query expects 4.
> {code}
> The describe table function which uses this function reports the same thing.
> {code}\d hcatalog.default.hive_table{code}
> The reason being the change in the number of out columns from this function.
> Previously the following were the columns reported:
> {code}
> postgres=# \df pxf_get_item_fields
>
> List of functions
> Schema | Name | Result data type |
> Argument data types
> | Type
> ------------+---------------------+------------------+------------------------------------------------------------------------------------------------------+--------
> pg_catalog | pxf_get_item_fields | SETOF record | profile text, pattern
> text, OUT path text, OUT itemname text, OUT fieldname text, OUT fieldtype
> text | normal
> (1 row)
> {code}
> With the newer version we have an extra column
> {code}
> postgres=# \df pxf_get_item_fields
>
> List of functions
> Schema | Name | Result data type |
> Argument data types
> | Type
> ------------+---------------------+------------------+--------------------------------------------------------------------------------------------------------------------------------+--------
> pg_catalog | pxf_get_item_fields | SETOF record | profile text, pattern
> text, OUT path text, OUT itemname text, OUT fieldname text, OUT fieldtype
> text, OUT sourcefieldtype text | normal
> (1 row)
> {code}
> The solution to make the describe table and pxf_get_item_fields function
> working is to update the pg_proc table under pg_catalog schema.
> This issue is a request to either an update in the documentation which
> mentions this requirement or improving the upgrade process which will take
> care of catalog update to reflect new behavior of the function.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
