trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From selvaganesang <...@git.apache.org>
Subject [GitHub] incubator-trafodion pull request: [TRAFODION-1454] Unable to detec...
Date Fri, 14 Aug 2015 22:17:15 GMT
GitHub user selvaganesang opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/59

    [TRAFODION-1454] Unable to detect the query id via RMS while running …

    …the tools like ODB
    
    Active query concept is now introduced to list queries which either have finished executing
within the given number of seconds or still being executed. The negative number in LAST_ACTIVITY_SECS
means that the query has completed that many seconds ago.
    
    cd $MY_SQROOT/export/limited-support-tools/LSO
    ./offender -s active
    
    CURRENT_TIMESTAMP           LAST_ACTIVITY_SECS    QUERY_ID                           
                            EXEC_STATE                SOURCE_TEXT
    --------------------------  --------------------  -------------------------------------------------------------
  ------------------------  ---------------------------------------------------------------------------
    2015-08-14 01:25:46.040274                   -18  MXID11000008455212306275447582585000000000206U3333300_175_S1
   CLOSE                     "upsert into t12 values (1,1,1) ;
    
    Also fixed a bug where TDBID_DETAIL stats(instance level stats) is not being displayed
for HBase access and HDFS scan operators when the query is not yet finished.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/selvaganesang/incubator-trafodion trafodion-1454

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/59.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 #59
    
----
commit 4b4034e7d7646d63cb2b40f52b9588bbd2932791
Author: selvaganesang <selva.govindarajan@esgyn.com>
Date:   2015-08-14T17:16:15Z

    [TRAFODION-1454] Unable to detect the query id via RMS while running the tools like ODB
    
    Active query concept is now introduced to lists queries which either
    have finished executing within the given number of seconds or still being executed.
    The negative number in LAST_ACTIVITY_SECS means that the query has completed
    that many seconds ago.
    
    cd $MY_SQROOT/export/limited-support-tools/LSO
    ./offender -s active
    
    CURRENT_TIMESTAMP           LAST_ACTIVITY_SECS    QUERY_ID                           
                            EXEC_STATE                SOURCE_TEXT
    --------------------------  --------------------  -------------------------------------------------------------
  ------------------------  ---------------------------------------------------------------------------
    2015-08-14 01:25:46.040274                   -18  MXID11000008455212306275447582585000000000206U3333300_175_S1
   CLOSE                     "upsert into t12 values (1,1,1) ;
    
    Also fixed a bug where TDBID_DETAIL stats(instance level stats) is not
    being displayed for HBase access and HDFS scan operators when the query is
    not yet finished.

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message