hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gagan Brahmi (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1314) Post-upgrade pxf_get_item_fields function break
Date Sun, 05 Feb 2017 16:57:42 GMT
Gagan Brahmi created HAWQ-1314:
----------------------------------

             Summary: 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: Ed Espino


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)

Mime
View raw message