kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shaofeng SHI (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (KYLIN-3009) Rest API to get Cube join SQL
Date Wed, 22 Nov 2017 06:20:00 GMT

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

Shaofeng SHI updated KYLIN-3009:
--------------------------------
    Description: 
Kylin's REST API "GET /kylin/api/\{cubeName\}/segs/\{segmentName\}/sql" can return a sample
join SQL for the cube. While this API need a 'segmentName', this is unfriendly for a cube
which doesn't have a segment.

Proposal to:

1. Add a simplified API without segmentName: 'GET /kylin/api/\{cubeName\}/sql', return the
Cube's SQL
2. Make the original API to return segment specific SQL, it may have the partition info in
the where condition.


  was:
Kylin's REST API "GET /kylin/api/\{cubeName\}/segs/{segmentName}/sql" can return a sample
join SQL for the cube. While this API need a 'segmentName', this is unfriendly for a cube
which doesn't have a segment.

Proposal to:

1. Add a simplified API without segmentName: 'GET /kylin/api/\{cubeName\}/sql', return the
Cube's SQL
2. Make the original API to return segment specific SQL, it may have the partition info in
the where condition.



> Rest API to get Cube join SQL
> -----------------------------
>
>                 Key: KYLIN-3009
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3009
>             Project: Kylin
>          Issue Type: Improvement
>          Components: REST Service
>            Reporter: Shaofeng SHI
>            Assignee: Shaofeng SHI
>            Priority: Minor
>             Fix For: v2.3.0
>
>         Attachments: KYLIN-3009.master.001.patch
>
>
> Kylin's REST API "GET /kylin/api/\{cubeName\}/segs/\{segmentName\}/sql" can return a
sample join SQL for the cube. While this API need a 'segmentName', this is unfriendly for
a cube which doesn't have a segment.
> Proposal to:
> 1. Add a simplified API without segmentName: 'GET /kylin/api/\{cubeName\}/sql', return
the Cube's SQL
> 2. Make the original API to return segment specific SQL, it may have the partition info
in the where condition.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message