Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | DB - BigQuery |
| Version | 19.0 |
Product: Aqua Data Studio
Version: 17.0.0-ga-26
Build #: 48204
Build Date: 2016-Jan-13 06:24:24 PM
Google BigQuery New Feature : 'Query Plan Explanation'/'Execution plan'
BigQuery provides diagnostic information about a completed query's execution plan.
If we use the Web UI, we can see the query plan for a completed query by clicking the Explanation button that's adjacent to the Results button.
The query plan describes a query as a series of stages, with each stage comprising a number of steps that read from data sources, perform a series of transformations on the input, and emit an output to a future stage (or the final result)
Please refer attached screenshot "Query Plan Explanation.png".
It is a useful feature. Can we provide this feature in ADS?
Reference : https://cloud.google.com/bigquery/query-plan-explanation
|
|
159 KB
Query Plan was introduced in Dec 15 2015 and this should be logged against a future release of ADS and not ADS v17.
See release notes
As commented by Tariq in above comment Query Plan is a feature introduced in December 15 2015. I have studied some API's related to it and also performed demo implementation for the same.
As per my observations following point need to be considered :-
latest BigQuery jar(google-api-services-bigquery-v2-rev277-java-1.21.0) contains the classes(ExplainQueryStage, ExplainQueryStep) which are not present in current jar(google-api-services-bigquery-v2) which we are using.
In latest jar there are methods to separate out the contains of Query Plan. If we intend to use current jar(which we are currently using) we need to separate out the object from JSON object returned by queryPlan.
As it was targeted for V18 do we intend to give this feature?
As commented by Tariq in above comment Query Plan is a feature introduced in December 15 2015. I have studied some API's related to it and also performed demo implementation for the same.
As per my observations following point need to be considered :-
latest BigQuery jar(google-api-services-bigquery-v2-rev277-java-1.21.0) contains the classes(ExplainQueryStage, ExplainQueryStep) which are not present in current jar(google-api-services-bigquery-v2) which we are using.
In latest jar there are methods to separate out the contains of Query Plan. If we intend to use current jar(which we are currently using) we need to separate out the object from JSON object returned by queryPlan.
As it was targeted for V18 do we intend to give this feature?
Issue #14194 |
| Closed |
| Duplicate |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
1 issue link |
duplicates #15225
Issue #15225BigQuery: Add Explain Plan Support |
Query Plan was introduced in Dec 15 2015 and this should be logged against a future release of ADS and not ADS v17.
See release notes