[KYLIN-3009] Rest API to get Cube join SQL

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: v2.3.0
• Component/s: REST Service
• Assignee: Shao Feng Shi
• Reporter: Shao Feng Shi
• Created: 05/Nov/17 10:44
• Updated: 02/Apr/18 13:42
• Resolved: 22/Nov/17 06:20

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.