[HAWQ-546] Client changes to handle \d for Hive tables

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Hcatalog, PXF
• Assignee: Oleksandr Diachenko
• Reporter: Oleksandr Diachenko
• Created: 15/Mar/16 21:02
• Updated: 14/Jul/16 17:46
• Resolved: 31/Mar/16 00:52

Description

Hawq psql should call pxf_get_item_fields if user passed pattern starring from "hcatalog" to \d command.

Client should issue query:

SELECT * FROM pxf_get_item_fields('Hive', '*.*');
  path   |  itemname  |  fieldname   | fieldtype 
----------+---------------+----------------+-----------------
 default | table1        | s1                | text
 default | table1        | n1                | int4
 default | table1        | d1                | float8
 default | table1        | bg                | int8
 default | table1        | b                  | bool
 default | table2        | a                  | int4
 default | table2        | b                  | int4
 default | table3        | a                  | int4
 default | table3        | b                  | int4
 userdb | table1        | id                 | int4
 userdb | table1        | name           | text
(15 rows)

Client output should look like:

\d hcatalog.*.*
PXF Hive Table "default.table1"
 Column |  Type  
--------+--------
 s1     | text
 n1     | int4
 d1     | float8
 bg     | int8
 b      | bool

PXF Hive Table "default.table2"
 Column | Type 
--------+------
 a      | int4
 b      | int4

PXF Hive Table "default.table3"
 Column | Type 
--------+------
 a      | int4
 b      | int4

PXF Hive Table "userdb.table1"
 Column | Type 
--------+------
 id     | int4
 name   | text