[jira] [Commented] (DRILL-6185) Error is displaying while accessing query profiles via the Web-UI
[ https://issues.apache.org/jira/browse/DRILL-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16384798#comment-16384798 ] ASF GitHub Bot commented on DRILL-6185: --- Github user asfgit closed the pull request at: https://github.com/apache/drill/pull/1137 > Error is displaying while accessing query profiles via the Web-UI > - > > Key: DRILL-6185 > URL: https://issues.apache.org/jira/browse/DRILL-6185 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.13.0 >Reporter: Anton Gozhiy >Assignee: Kunal Khatua >Priority: Blocker > Labels: ready-to-commit > Fix For: 1.13.0 > > > *Steps:* > # Execute the following query: > {code:sql} > show schemas; > {code} > # On the Web-UI, go to the Profiles tab > # Open the profile for the query you executed > *Expected result:* You can access to the profile entry > *Actual result:* Error is displayed: > {code:json} > { > "errorMessage" : "1" > } > {code} > *Note:* This error doesn't happen with every query. For example, "select * > from system.version" can be accessed without error, while "show tables", "use > dfs", "alter sessions" etc end with this error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (DRILL-6185) Error is displaying while accessing query profiles via the Web-UI
[ https://issues.apache.org/jira/browse/DRILL-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16381794#comment-16381794 ] ASF GitHub Bot commented on DRILL-6185: --- Github user arina-ielchiieva commented on the issue: https://github.com/apache/drill/pull/1137 I meant that we parse text plan, obviously it was generated from the some object. For the future we may consider to create special plan object from initial one which will have structure suitable for Web UI and we won't need to parse plan string... > Error is displaying while accessing query profiles via the Web-UI > - > > Key: DRILL-6185 > URL: https://issues.apache.org/jira/browse/DRILL-6185 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.13.0 >Reporter: Anton Gozhiy >Assignee: Kunal Khatua >Priority: Blocker > Labels: ready-to-commit > Fix For: 1.13.0 > > > *Steps:* > # Execute the following query: > {code:sql} > show schemas; > {code} > # On the Web-UI, go to the Profiles tab > # Open the profile for the query you executed > *Expected result:* You can access to the profile entry > *Actual result:* Error is displayed: > {code:json} > { > "errorMessage" : "1" > } > {code} > *Note:* This error doesn't happen with every query. For example, "select * > from system.version" can be accessed without error, while "show tables", "use > dfs", "alter sessions" etc end with this error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (DRILL-6185) Error is displaying while accessing query profiles via the Web-UI
[ https://issues.apache.org/jira/browse/DRILL-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16380828#comment-16380828 ] ASF GitHub Bot commented on DRILL-6185: --- Github user kkhatua commented on the issue: https://github.com/apache/drill/pull/1137 the purpose of parsing the plan as a String is primarily to extract the alternative operator names for the UI. The rest of the items are irrelevant for that usecase. Were you looking to figure out a way to deserialize the plan text, so that other scenarios could leverage off that? > Error is displaying while accessing query profiles via the Web-UI > - > > Key: DRILL-6185 > URL: https://issues.apache.org/jira/browse/DRILL-6185 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.13.0 >Reporter: Anton Gozhiy >Assignee: Kunal Khatua >Priority: Blocker > Labels: ready-to-commit > Fix For: 1.13.0 > > > *Steps:* > # Execute the following query: > {code:sql} > show schemas; > {code} > # On the Web-UI, go to the Profiles tab > # Open the profile for the query you executed > *Expected result:* You can access to the profile entry > *Actual result:* Error is displayed: > {code:json} > { > "errorMessage" : "1" > } > {code} > *Note:* This error doesn't happen with every query. For example, "select * > from system.version" can be accessed without error, while "show tables", "use > dfs", "alter sessions" etc end with this error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (DRILL-6185) Error is displaying while accessing query profiles via the Web-UI
[ https://issues.apache.org/jira/browse/DRILL-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16379954#comment-16379954 ] ASF GitHub Bot commented on DRILL-6185: --- Github user arina-ielchiieva commented on the issue: https://github.com/apache/drill/pull/1137 +1, LGTM. > Error is displaying while accessing query profiles via the Web-UI > - > > Key: DRILL-6185 > URL: https://issues.apache.org/jira/browse/DRILL-6185 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.13.0 >Reporter: Anton Gozhiy >Assignee: Kunal Khatua >Priority: Blocker > Fix For: 1.13.0 > > > *Steps:* > # Execute the following query: > {code:sql} > show schemas; > {code} > # On the Web-UI, go to the Profiles tab > # Open the profile for the query you executed > *Expected result:* You can access to the profile entry > *Actual result:* Error is displayed: > {code:json} > { > "errorMessage" : "1" > } > {code} > *Note:* This error doesn't happen with every query. For example, "select * > from system.version" can be accessed without error, while "show tables", "use > dfs", "alter sessions" etc end with this error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (DRILL-6185) Error is displaying while accessing query profiles via the Web-UI
[ https://issues.apache.org/jira/browse/DRILL-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16379350#comment-16379350 ] ASF GitHub Bot commented on DRILL-6185: --- Github user arina-ielchiieva commented on a diff in the pull request: https://github.com/apache/drill/pull/1137#discussion_r171071136 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/server/rest/profile/ProfileWrapper.java --- @@ -330,10 +332,16 @@ public boolean isOnlyImpersonationEnabled() { //Generates operator names inferred from physical plan private void generateOpMap(String plan) { this.physicalOperatorMap = new HashMap(); --- End diff -- Please replace with diamonds -> `new HashMap<>();` > Error is displaying while accessing query profiles via the Web-UI > - > > Key: DRILL-6185 > URL: https://issues.apache.org/jira/browse/DRILL-6185 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.13.0 >Reporter: Anton Gozhiy >Assignee: Kunal Khatua >Priority: Blocker > Fix For: 1.13.0 > > > *Steps:* > # Execute the following query: > {code:sql} > show schemas; > {code} > # On the Web-UI, go to the Profiles tab > # Open the profile for the query you executed > *Expected result:* You can access to the profile entry > *Actual result:* Error is displayed: > {code:json} > { > "errorMessage" : "1" > } > {code} > *Note:* This error doesn't happen with every query. For example, "select * > from system.version" can be accessed without error, while "show tables", "use > dfs", "alter sessions" etc end with this error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (DRILL-6185) Error is displaying while accessing query profiles via the Web-UI
[ https://issues.apache.org/jira/browse/DRILL-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16379278#comment-16379278 ] Kunal Khatua commented on DRILL-6185: - [~arina] / [~amansinha100] (cc: [~parthc]) Can you please review this? > Error is displaying while accessing query profiles via the Web-UI > - > > Key: DRILL-6185 > URL: https://issues.apache.org/jira/browse/DRILL-6185 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.13.0 >Reporter: Anton Gozhiy >Assignee: Kunal Khatua >Priority: Blocker > Fix For: 1.13.0 > > > *Steps:* > # Execute the following query: > {code:sql} > show schemas; > {code} > # On the Web-UI, go to the Profiles tab > # Open the profile for the query you executed > *Expected result:* You can access to the profile entry > *Actual result:* Error is displayed: > {code:json} > { > "errorMessage" : "1" > } > {code} > *Note:* This error doesn't happen with every query. For example, "select * > from system.version" can be accessed without error, while "show tables", "use > dfs", "alter sessions" etc end with this error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (DRILL-6185) Error is displaying while accessing query profiles via the Web-UI
[ https://issues.apache.org/jira/browse/DRILL-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16379276#comment-16379276 ] ASF GitHub Bot commented on DRILL-6185: --- GitHub user kkhatua opened a pull request: https://github.com/apache/drill/pull/1137 DRILL-6185: Fixed error while displaying system profiles via the Web-UI The bug lies in the absence of a text plan for profiles related to system queries: e.g. ``` use dfs.tmp; show tables; alter session reset all; ``` This addresses that by ensuring an empty string is substituted and the tokenization is done correctly. You can merge this pull request into a Git repository by running: $ git pull https://github.com/kkhatua/drill DRILL-6185 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/drill/pull/1137.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1137 commit aea75f86a945ea901165458707019edebc0dd91a Author: Kunal KhatuaDate: 2018-02-27T20:10:06Z DRILL-6185: Fixed error while displaying system profiles via the Web-UI The bug lies in the absence of a text plan for profiles related to system queries: e.g. {code:sql} use dfs.tmp; show tables; alter session reset all; {code} This addresses that by ensuring an empty string is substituted and the tokenization is done correctly. > Error is displaying while accessing query profiles via the Web-UI > - > > Key: DRILL-6185 > URL: https://issues.apache.org/jira/browse/DRILL-6185 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.13.0 >Reporter: Anton Gozhiy >Assignee: Kunal Khatua >Priority: Blocker > Fix For: 1.13.0 > > > *Steps:* > # Execute the following query: > {code:sql} > show schemas; > {code} > # On the Web-UI, go to the Profiles tab > # Open the profile for the query you executed > *Expected result:* You can access to the profile entry > *Actual result:* Error is displayed: > {code:json} > { > "errorMessage" : "1" > } > {code} > *Note:* This error doesn't happen with every query. For example, "select * > from system.version" can be accessed without error, while "show tables", "use > dfs", "alter sessions" etc end with this error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (DRILL-6185) Error is displaying while accessing query profiles via the Web-UI
[ https://issues.apache.org/jira/browse/DRILL-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16379108#comment-16379108 ] Kunal Khatua commented on DRILL-6185: - Already working on it. > Error is displaying while accessing query profiles via the Web-UI > - > > Key: DRILL-6185 > URL: https://issues.apache.org/jira/browse/DRILL-6185 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.13.0 >Reporter: Anton Gozhiy >Assignee: Kunal Khatua >Priority: Blocker > Fix For: 1.13.0 > > > *Steps:* > # Execute the following query: > {code:sql} > show schemas; > {code} > # On the Web-UI, go to the Profiles tab > # Open the profile for the query you executed > *Expected result:* You can access to the profile entry > *Actual result:* Error is displayed: > {code:json} > { > "errorMessage" : "1" > } > {code} > *Note:* This error doesn't happen with every query. For example, "select * > from system.version" can be accessed without error, while "show tables", "use > dfs", "alter sessions" etc end with this error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (DRILL-6185) Error is displaying while accessing query profiles via the Web-UI
[ https://issues.apache.org/jira/browse/DRILL-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16378137#comment-16378137 ] Parth Chandra commented on DRILL-6185: -- [~kkhatua] are you looking into this? > Error is displaying while accessing query profiles via the Web-UI > - > > Key: DRILL-6185 > URL: https://issues.apache.org/jira/browse/DRILL-6185 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.13.0 >Reporter: Anton Gozhiy >Assignee: Kunal Khatua >Priority: Blocker > Fix For: 1.13.0 > > > *Steps:* > # Execute the following query: > {code:sql} > show schemas; > {code} > # On the Web-UI, go to the Profiles tab > # Open the profile for the query you executed > *Expected result:* You can access to the profile entry > *Actual result:* Error is displayed: > {code:json} > { > "errorMessage" : "1" > } > {code} > *Note:* This error doesn't happen with every query. For example, "select * > from system.version" can be accessed without error, while "show tables", "use > dfs", "alter sessions" etc end with this error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (DRILL-6185) Error is displaying while accessing query profiles via the Web-UI
[ https://issues.apache.org/jira/browse/DRILL-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16376845#comment-16376845 ] Arina Ielchiieva commented on DRILL-6185: - This is a regression after DRILL-6140. Change in which assume that query plan always exists but this is not true for special operators (show, alter, create etc) or queries with invalid syntax. > Error is displaying while accessing query profiles via the Web-UI > - > > Key: DRILL-6185 > URL: https://issues.apache.org/jira/browse/DRILL-6185 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.13.0 >Reporter: Anton Gozhiy >Assignee: Kunal Khatua >Priority: Blocker > Fix For: 1.13.0 > > > *Steps:* > # Execute the following query: > {code:sql} > show schemas; > {code} > # On the Web-UI, go to the Profiles tab > # Open the profile for the query you executed > *Expected result:* You can access to the profile entry > *Actual result:* Error is displayed: > {code:json} > { > "errorMessage" : "1" > } > {code} > *Note:* This error doesn't happen with every query. For example, "select * > from system.version" can be accessed without error, while "show tables", "use > dfs", "alter sessions" etc end with this error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)