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 <[email protected]>
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 [email protected] or file a JIRA ticket
with INFRA.
---
