{"action":"created","comment":{"url":"https://api.github.com/repos/apache/incubator-carbondata/pulls/comments/77120500","id":77120500,"diff_hunk":"@@ -45,8 +47,16 @@\n    */\n   private long startTime;\n \n-  public QueryStatistic() {\n+  /**\n+   * number of count\n+   */\n+  private long count;\n+\n+  private String queryIdWthTask;\n+\n+  public QueryStatistic(String queryId) {","path":"core/src/main/java/org/apache/carbondata/core/carbon/querystatistics/QueryStatistic.java","position":null,"original_position":21,"commit_id":"7bb6c8b68b00d719d6464f92e4379966ea433227","original_commit_id":"a305df7d14227ed31817a5ad4c5f31b0e8e73c41","user":{"login":"foryou2030","id":13846940,"avatar_url":"https://avatars.githubusercontent.com/u/13846940?v=3","gravatar_id":"","url":"https://api.github.com/users/foryou2030","html_url":"https://github.com/foryou2030","followers_url":"https://api.github.com/users/foryou2030/followers","following_url":"https://api.github.com/users/foryou2030/following{/other_user}","gists_url":"https://api.github.com/users/foryou2030/gists{/gist_id}","starred_url":"https://api.github.com/users/foryou2030/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/foryou2030/subscriptions","organizations_url":"https://api.github.com/users/foryou2030/orgs","repos_url":"https://api.github.com/users/foryou2030/repos","events_url":"https://api.github.com/users/foryou2030/events{/privacy}","received_events_url":"https://api.github.com/users/foryou2030/received_events","type":"User","site_admin":false},"body":"handled","created_at":"2016-09-01T06:33:13Z","updated_at":"2016-09-01T06:33:13Z","html_url":"https://github.com/apache/incubator-carbondata/pull/91#discussion_r77120500","pull_request_url":"https://api.github.com/repos/apache/incubator-carbondata/pulls/91","_links":{"self":{"href":"https://api.github.com/repos/apache/incubator-carbondata/pulls/comments/77120500"},"html":{"href":"https://github.com/apache/incubator-carbondata/pull/91#discussion_r77120500"},"pull_request":{"href":"https://api.github.com/repos/apache/incubator-carbondata/pulls/91"}}},"pull_request":{"url":"https://api.github.com/repos/apache/incubator-carbondata/pulls/91","id":82521541,"html_url":"https://github.com/apache/incubator-carbondata/pull/91","diff_url":"https://github.com/apache/incubator-carbondata/pull/91.diff","patch_url":"https://github.com/apache/incubator-carbondata/pull/91.patch","issue_url":"https://api.github.com/repos/apache/incubator-carbondata/issues/91","number":91,"state":"open","locked":false,"title":"[WIP] Add performance statistics logs to record the query time taken by carbon","user":{"login":"foryou2030","id":13846940,"avatar_url":"https://avatars.githubusercontent.com/u/13846940?v=3","gravatar_id":"","url":"https://api.github.com/users/foryou2030","html_url":"https://github.com/foryou2030","followers_url":"https://api.github.com/users/foryou2030/followers","following_url":"https://api.github.com/users/foryou2030/following{/other_user}","gists_url":"https://api.github.com/users/foryou2030/gists{/gist_id}","starred_url":"https://api.github.com/users/foryou2030/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/foryou2030/subscriptions","organizations_url":"https://api.github.com/users/foryou2030/orgs","repos_url":"https://api.github.com/users/foryou2030/repos","events_url":"https://api.github.com/users/foryou2030/events{/privacy}","received_events_url":"https://api.github.com/users/foryou2030/received_events","type":"User","site_admin":false},"body":"# Why raise this pr?\r\nCheck query performance statistics More intuitive.\r\n# How to resolve?\r\nThe query statistics will be shown on logs as the following, we can get performance info from the table easily:\r\n```\r\n+--------+--------------------+---------------------+----------------------+\r\n|  Module|      Operation Step|                                  Query Cost|\r\n+--------+--------------------+---------------------+----------------------+\r\n|              JDBC connection|                     |                      |\r\n+--------+--------------------+---------------------+----------------------+\r\n|        |           SQL parse|                     |                1.104 |\r\n|        +--------------------+                     +----------------------+\r\n|        |Connect time to Hive|                     |                0.054 |\r\n|  Driver|    metastore carbon|                     |                      |\r\n|        +--------------------+                     +----------------------+\r\n|    Part|Block identification|                     |                0.003 |\r\n|        +--------------------+                     +----------------------+\r\n|        |    Schedule task to|                     |                      |\r\n|        |            executor|                     |                      |\r\n+--------+--------------------+---------------------+----------------------+\r\n|        |          Load index|                     |                0.046 |\r\n|        +--------------------+                     +----------------------+\r\n|Executor|   Scan(include read|                     |                0.019 |\r\n|    Part|     data from file&|                     |                      |\r\n|        |             process|                0.13 |                      |\r\n|        +--------------------+                     +----------------------+\r\n|        |     Dictionary load|                     |                0.001 |\r\n|        +--------------------+                     +----------------------+\r\n|        |Prepare query result|                     |                0.001 |\r\n|        |   and give to spark|                     |                      |\r\n+--------+--------------------+---------------------+----------------------+\r\n|      Print result at beeline|                     |                      |\r\n+--------+--------------------+---------------------+----------------------+\r\n|                        Total|                     |                      |\r\n+--------+--------------------+---------------------+----------------------+\r\n```\r\nMost of the statistics info can be recorded into the table, But some can't be display in the table directly, such as `JDBC connection, Schedule task, Print at beeline`. Because these statistics can't be caught in carbon code, so we need to analyzing the jdbc log and calculate.\r\n","created_at":"2016-08-24T10:56:56Z","updated_at":"2016-09-01T06:33:13Z","closed_at":null,"merged_at":null,"merge_commit_sha":"11a5eaaa0ca1644e70a884a36cce1dc0fa37bf56","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/apache/incubator-carbondata/pulls/91/commits","review_comments_url":"https://api.github.com/repos/apache/incubator-carbondata/pulls/91/comments","review_comment_url":"https://api.github.com/repos/apache/incubator-carbondata/pulls/comments{/number}","comments_url":"https://api.github.com/repos/apache/incubator-carbondata/issues/91/comments","statuses_url":"https://api.github.com/repos/apache/incubator-carbondata/statuses/7bb6c8b68b00d719d6464f92e4379966ea433227","head":{"label":"foryou2030:query_statistics","ref":"query_statistics","sha":"7bb6c8b68b00d719d6464f92e4379966ea433227","user":{"login":"foryou2030","id":13846940,"avatar_url":"https://avatars.githubusercontent.com/u/13846940?v=3","gravatar_id":"","url":"https://api.github.com/users/foryou2030","html_url":"https://github.com/foryou2030","followers_url":"https://api.github.com/users/foryou2030/followers","following_url":"https://api.github.com/users/foryou2030/following{/other_user}","gists_url":"https://api.github.com/users/foryou2030/gists{/gist_id}","starred_url":"https://api.github.com/users/foryou2030/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/foryou2030/subscriptions","organizations_url":"https://api.github.com/users/foryou2030/orgs","repos_url":"https://api.github.com/users/foryou2030/repos","events_url":"https://api.github.com/users/foryou2030/events{/privacy}","received_events_url":"https://api.github.com/users/foryou2030/received_events","type":"User","site_admin":false},"repo":{"id":62351495,"name":"incubator-carbondata","full_name":"foryou2030/incubator-carbondata","owner":{"login":"foryou2030","id":13846940,"avatar_url":"https://avatars.githubusercontent.com/u/13846940?v=3","gravatar_id":"","url":"https://api.github.com/users/foryou2030","html_url":"https://github.com/foryou2030","followers_url":"https://api.github.com/users/foryou2030/followers","following_url":"https://api.github.com/users/foryou2030/following{/other_user}","gists_url":"https://api.github.com/users/foryou2030/gists{/gist_id}","starred_url":"https://api.github.com/users/foryou2030/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/foryou2030/subscriptions","organizations_url":"https://api.github.com/users/foryou2030/orgs","repos_url":"https://api.github.com/users/foryou2030/repos","events_url":"https://api.github.com/users/foryou2030/events{/privacy}","received_events_url":"https://api.github.com/users/foryou2030/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/foryou2030/incubator-carbondata","description":"Mirror of Apache CarbonData (Incubating)","fork":true,"url":"https://api.github.com/repos/foryou2030/incubator-carbondata","forks_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/forks","keys_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/keys{/key_id}","collaborators_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/teams","hooks_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/hooks","issue_events_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/issues/events{/number}","events_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/events","assignees_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/assignees{/user}","branches_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/branches{/branch}","tags_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/tags","blobs_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/git/refs{/sha}","trees_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/git/trees{/sha}","statuses_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/statuses/{sha}","languages_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/languages","stargazers_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/stargazers","contributors_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/contributors","subscribers_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/subscribers","subscription_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/subscription","commits_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/commits{/sha}","git_commits_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/git/commits{/sha}","comments_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/comments{/number}","issue_comment_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/issues/comments{/number}","contents_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/contents/{+path}","compare_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/compare/{base}...{head}","merges_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/merges","archive_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/downloads","issues_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/issues{/number}","pulls_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/pulls{/number}","milestones_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/milestones{/number}","notifications_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/labels{/name}","releases_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/releases{/id}","deployments_url":"https://api.github.com/repos/foryou2030/incubator-carbondata/deployments","created_at":"2016-07-01T00:52:33Z","updated_at":"2016-07-01T00:52:38Z","pushed_at":"2016-09-01T05:17:23Z","git_url":"git://github.com/foryou2030/incubator-carbondata.git","ssh_url":"git@github.com:foryou2030/incubator-carbondata.git","clone_url":"https://github.com/foryou2030/incubator-carbondata.git","svn_url":"https://github.com/foryou2030/incubator-carbondata","homepage":null,"size":37486,"stargazers_count":0,"watchers_count":0,"language":"Java","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"apache:master","ref":"master","sha":"eb12b85173188bf985167f959474c5fb461ada34","user":{"login":"apache","id":47359,"avatar_url":"https://avatars.githubusercontent.com/u/47359?v=3","gravatar_id":"","url":"https://api.github.com/users/apache","html_url":"https://github.com/apache","followers_url":"https://api.github.com/users/apache/followers","following_url":"https://api.github.com/users/apache/following{/other_user}","gists_url":"https://api.github.com/users/apache/gists{/gist_id}","starred_url":"https://api.github.com/users/apache/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apache/subscriptions","organizations_url":"https://api.github.com/users/apache/orgs","repos_url":"https://api.github.com/users/apache/repos","events_url":"https://api.github.com/users/apache/events{/privacy}","received_events_url":"https://api.github.com/users/apache/received_events","type":"Organization","site_admin":false},"repo":{"id":62117818,"name":"incubator-carbondata","full_name":"apache/incubator-carbondata","owner":{"login":"apache","id":47359,"avatar_url":"https://avatars.githubusercontent.com/u/47359?v=3","gravatar_id":"","url":"https://api.github.com/users/apache","html_url":"https://github.com/apache","followers_url":"https://api.github.com/users/apache/followers","following_url":"https://api.github.com/users/apache/following{/other_user}","gists_url":"https://api.github.com/users/apache/gists{/gist_id}","starred_url":"https://api.github.com/users/apache/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apache/subscriptions","organizations_url":"https://api.github.com/users/apache/orgs","repos_url":"https://api.github.com/users/apache/repos","events_url":"https://api.github.com/users/apache/events{/privacy}","received_events_url":"https://api.github.com/users/apache/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/apache/incubator-carbondata","description":"Mirror of Apache CarbonData (Incubating)","fork":false,"url":"https://api.github.com/repos/apache/incubator-carbondata","forks_url":"https://api.github.com/repos/apache/incubator-carbondata/forks","keys_url":"https://api.github.com/repos/apache/incubator-carbondata/keys{/key_id}","collaborators_url":"https://api.github.com/repos/apache/incubator-carbondata/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/apache/incubator-carbondata/teams","hooks_url":"https://api.github.com/repos/apache/incubator-carbondata/hooks","issue_events_url":"https://api.github.com/repos/apache/incubator-carbondata/issues/events{/number}","events_url":"https://api.github.com/repos/apache/incubator-carbondata/events","assignees_url":"https://api.github.com/repos/apache/incubator-carbondata/assignees{/user}","branches_url":"https://api.github.com/repos/apache/incubator-carbondata/branches{/branch}","tags_url":"https://api.github.com/repos/apache/incubator-carbondata/tags","blobs_url":"https://api.github.com/repos/apache/incubator-carbondata/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/apache/incubator-carbondata/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/apache/incubator-carbondata/git/refs{/sha}","trees_url":"https://api.github.com/repos/apache/incubator-carbondata/git/trees{/sha}","statuses_url":"https://api.github.com/repos/apache/incubator-carbondata/statuses/{sha}","languages_url":"https://api.github.com/repos/apache/incubator-carbondata/languages","stargazers_url":"https://api.github.com/repos/apache/incubator-carbondata/stargazers","contributors_url":"https://api.github.com/repos/apache/incubator-carbondata/contributors","subscribers_url":"https://api.github.com/repos/apache/incubator-carbondata/subscribers","subscription_url":"https://api.github.com/repos/apache/incubator-carbondata/subscription","commits_url":"https://api.github.com/repos/apache/incubator-carbondata/commits{/sha}","git_commits_url":"https://api.github.com/repos/apache/incubator-carbondata/git/commits{/sha}","comments_url":"https://api.github.com/repos/apache/incubator-carbondata/comments{/number}","issue_comment_url":"https://api.github.com/repos/apache/incubator-carbondata/issues/comments{/number}","contents_url":"https://api.github.com/repos/apache/incubator-carbondata/contents/{+path}","compare_url":"https://api.github.com/repos/apache/incubator-carbondata/compare/{base}...{head}","merges_url":"https://api.github.com/repos/apache/incubator-carbondata/merges","archive_url":"https://api.github.com/repos/apache/incubator-carbondata/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/apache/incubator-carbondata/downloads","issues_url":"https://api.github.com/repos/apache/incubator-carbondata/issues{/number}","pulls_url":"https://api.github.com/repos/apache/incubator-carbondata/pulls{/number}","milestones_url":"https://api.github.com/repos/apache/incubator-carbondata/milestones{/number}","notifications_url":"https://api.github.com/repos/apache/incubator-carbondata/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/apache/incubator-carbondata/labels{/name}","releases_url":"https://api.github.com/repos/apache/incubator-carbondata/releases{/id}","deployments_url":"https://api.github.com/repos/apache/incubator-carbondata/deployments","created_at":"2016-06-28T07:00:06Z","updated_at":"2016-09-01T03:37:42Z","pushed_at":"2016-09-01T06:19:22Z","git_url":"git://github.com/apache/incubator-carbondata.git","ssh_url":"git@github.com:apache/incubator-carbondata.git","clone_url":"https://github.com/apache/incubator-carbondata.git","svn_url":"https://github.com/apache/incubator-carbondata","homepage":null,"size":38520,"stargazers_count":102,"watchers_count":102,"language":"Java","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":97,"mirror_url":"git://git.apache.org/incubator-carbondata.git","open_issues_count":18,"forks":97,"open_issues":18,"watchers":102,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/apache/incubator-carbondata/pulls/91"},"html":{"href":"https://github.com/apache/incubator-carbondata/pull/91"},"issue":{"href":"https://api.github.com/repos/apache/incubator-carbondata/issues/91"},"comments":{"href":"https://api.github.com/repos/apache/incubator-carbondata/issues/91/comments"},"review_comments":{"href":"https://api.github.com/repos/apache/incubator-carbondata/pulls/91/comments"},"review_comment":{"href":"https://api.github.com/repos/apache/incubator-carbondata/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/apache/incubator-carbondata/pulls/91/commits"},"statuses":{"href":"https://api.github.com/repos/apache/incubator-carbondata/statuses/7bb6c8b68b00d719d6464f92e4379966ea433227"}}}}
{"actor":{"display_login":"foryou2030"}}