You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Oleksandr Diachenko (JIRA)" <ji...@apache.org> on 2017/02/09 22:56:41 UTC
[jira] [Updated] (HAWQ-1314) Post-upgrade pxf_get_item_fields
function break
[ https://issues.apache.org/jira/browse/HAWQ-1314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Oleksandr Diachenko updated HAWQ-1314:
--------------------------------------
Fix Version/s: 2.2.0.0-incubating
> 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)