[jira] [Resolved] (HAWQ-459) Enhance Metadata Rest API to support table(s)

["Shivram Mani (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shivram Mani resolved HAWQ-459.
-------------------------------
    Resolution: Fixed

> Enhance Metadata Rest API to support table(s)
> ---------------------------------------------
>
>                 Key: HAWQ-459
>                 URL: https://issues.apache.org/jira/browse/HAWQ-459
>             Project: Apache HAWQ
>          Issue Type: Sub-task
>          Components: Hcatalog, PXF
>            Reporter: Shivram Mani
>            Assignee: Shivram Mani
>             Fix For: 2.0.0
>
>
> Currently we have Metadata/getTableMetadata endpoint, which takes "table" as a path parameter and returns metadata for given table.
> Idea is to enhance this endpoint to support more advanced predicates, to specify expressions for schema, table and database.
> h1.Input parameters:
> |*name*|
> |tables|
> |schemas||
> |databases|
> Each parameter is comma-separated list of strings.
> Method should filter result set against all provided parameters, using AND operator. 
> h1. HTTP return codes:
> |*code*|*meaning*|
> |200|found some result set|
> |404|didn't found any results for given parameters, empty result set|
> |500|unable to access underlying metastore(hive, hbase, hdfs etc), some other exception|
> h1. Return data format for 200 code:
> {code}
> {  
>    "PXFMetadata":[  
>       {  
>          "table":{  
>             "dbName":"default",
>             "tableName":"t1"
>          },
>          "fields":[  
>             {  
>                "name":"a",
>                "type":"int"
>             },
>             {  
>                "name":"b",
>                "type":"float"
>             }
>          ]
>       },
>       {  
>          "table":{  
>             "dbName":"default",
>             "tableName":"t2"
>          },
>          "fields":[  
>             {  
>                "name":"a",
>                "type":"int"
>             },
>             {  
>                "name":"b",
>                "type":"float"
>             }
>          ]
>       },
>       {  
>          "table":{  
>             "dbName":"default",
>             "tableName":"t3"
>          },
>          "fields":[  
>             {  
>                "name":"a",
>                "type":"int"
>             },
>             {  
>                "name":"b",
>                "type":"float"
>             }
>          ]
>       }
>    ]
> }
> {code}
> h1. Return data format for 404 code:
> {code}
> {  
>    "PXFMetadata":[]
> }
> {code}
> h1. Return data format for 500 code:
> {code}
> {  
>    "PXFError":{"code" : "XXX1", "message" : "Unable to reach Hive metastore"}
> }
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)