You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ning Zhang (JIRA)" <ji...@apache.org> on 2011/02/22 20:45:39 UTC

[jira] Created: (HIVE-2000) adding comments to Hive Stats JDBC queries

adding comments to Hive Stats JDBC queries 
-------------------------------------------

                 Key: HIVE-2000
                 URL: https://issues.apache.org/jira/browse/HIVE-2000
             Project: Hive
          Issue Type: Improvement
            Reporter: Ning Zhang
            Assignee: Ning Zhang
            Priority: Trivial


Stats gathering could issue a large number of JDBC queries to stats publisher and aggregator. In a shared DB environment, it's hard to tell which SQL statements are contributed by Hive stats gathering tasks. It would be easier to identify these workload by adding SQL comments that identifies the source of the query. 

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (HIVE-2000) adding comments to Hive Stats JDBC queries

Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carl Steinbach updated HIVE-2000:
---------------------------------

    Fix Version/s: 0.8.0

> adding comments to Hive Stats JDBC queries 
> -------------------------------------------
>
>                 Key: HIVE-2000
>                 URL: https://issues.apache.org/jira/browse/HIVE-2000
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>            Priority: Trivial
>             Fix For: 0.8.0
>
>         Attachments: HIVE-2000.patch
>
>
> Stats gathering could issue a large number of JDBC queries to stats publisher and aggregator. In a shared DB environment, it's hard to tell which SQL statements are contributed by Hive stats gathering tasks. It would be easier to identify these workload by adding SQL comments that identifies the source of the query. 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Updated: (HIVE-2000) adding comments to Hive Stats JDBC queries

Posted by "Ning Zhang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ning Zhang updated HIVE-2000:
-----------------------------

    Status: Patch Available  (was: Open)

> adding comments to Hive Stats JDBC queries 
> -------------------------------------------
>
>                 Key: HIVE-2000
>                 URL: https://issues.apache.org/jira/browse/HIVE-2000
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>            Priority: Trivial
>         Attachments: HIVE-2000.patch
>
>
> Stats gathering could issue a large number of JDBC queries to stats publisher and aggregator. In a shared DB environment, it's hard to tell which SQL statements are contributed by Hive stats gathering tasks. It would be easier to identify these workload by adding SQL comments that identifies the source of the query. 

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (HIVE-2000) adding comments to Hive Stats JDBC queries

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-2000:
-----------------------------

      Resolution: Fixed
    Hadoop Flags: [Reviewed]
          Status: Resolved  (was: Patch Available)

Committed. Thanks Ning

> adding comments to Hive Stats JDBC queries 
> -------------------------------------------
>
>                 Key: HIVE-2000
>                 URL: https://issues.apache.org/jira/browse/HIVE-2000
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>            Priority: Trivial
>         Attachments: HIVE-2000.patch
>
>
> Stats gathering could issue a large number of JDBC queries to stats publisher and aggregator. In a shared DB environment, it's hard to tell which SQL statements are contributed by Hive stats gathering tasks. It would be easier to identify these workload by adding SQL comments that identifies the source of the query. 

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (HIVE-2000) adding comments to Hive Stats JDBC queries

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12998009#comment-12998009 ] 

Namit Jain commented on HIVE-2000:
----------------------------------

+1

> adding comments to Hive Stats JDBC queries 
> -------------------------------------------
>
>                 Key: HIVE-2000
>                 URL: https://issues.apache.org/jira/browse/HIVE-2000
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>            Priority: Trivial
>         Attachments: HIVE-2000.patch
>
>
> Stats gathering could issue a large number of JDBC queries to stats publisher and aggregator. In a shared DB environment, it's hard to tell which SQL statements are contributed by Hive stats gathering tasks. It would be easier to identify these workload by adding SQL comments that identifies the source of the query. 

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (HIVE-2000) adding comments to Hive Stats JDBC queries

Posted by "Ning Zhang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ning Zhang updated HIVE-2000:
-----------------------------

    Attachment: HIVE-2000.patch

> adding comments to Hive Stats JDBC queries 
> -------------------------------------------
>
>                 Key: HIVE-2000
>                 URL: https://issues.apache.org/jira/browse/HIVE-2000
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>            Priority: Trivial
>         Attachments: HIVE-2000.patch
>
>
> Stats gathering could issue a large number of JDBC queries to stats publisher and aggregator. In a shared DB environment, it's hard to tell which SQL statements are contributed by Hive stats gathering tasks. It would be easier to identify these workload by adding SQL comments that identifies the source of the query. 

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira