This PR updates a couple of aspects of the select-star logic including: - Adding an optional schema to the `/select_star` route. - Making the `/select_star` route return a JSON response as opposed to HTML. - Ensured that the `/select_star` route includes a partition (if appropriate). - Ensured that the `/table` route includes a partition (if appropriate)†. - Added a `where_latest_partition` for Presto. - Changed the default Hive `where_latest_partition` behavior to return the first partition if the table is multi-partitioned. Previous it would return `False` is the table was partitioned but contained more than one partition key.
† Note this improves the performance of the SQL Lab preview by including a partition predicate even though there is additional overhead of finding the latest partition. This also helps to ensure that the data preview is associated with the partition (guaranteed for the single partitioned case) shown in the UI. <img width="404" alt="screen shot 2018-10-05 at 10 25 13 pm" src="https://user-images.githubusercontent.com/4567245/46567771-06ffd000-c8ee-11e8-9b91-2abbe0be80d3.png";> to: @graceguo-supercat @kristw @michellethomas @mistercrunch @timifasubaa [ Full content available at: https://github.com/apache/incubator-superset/pull/6051 ] This message was relayed via gitbox.apache.org for [email protected]
![https://user-images.githubusercontent.com/4567245/46567771-06ffd000-c8ee-11e8-9b91-2abbe0be80d3.png"](https://user-images.githubusercontent.com/4567245/46567771-06ffd000-c8ee-11e8-9b91-2abbe0be80d3.png"){kind=link}