SYSCS_UTIL.SYSCS_GET_SESSION_INFO

The SYSCS_UTIL.SYSCS_GET_SESSION_INFO system procedure displays the hostname and session ID for your current session. You can use this information to correlate your Splice Machine query with a Spark job: the same information is displayed in the Job Id (Job Group) in the Spark console.

Syntax

SYSCS_UTIL.SYSCS_GET_SESSION_INFO()

Results

The displayed results of calling SYSCS_UTIL.SYSCS_GET_SESSION include these values:

Value Description
HOSTNAME The identity of your Splice Machine connection.
SESSION The ID of your database connection session.

Example

splice> CALL SYSCS_UTIL.SYSCS_GET_SESSION_INFO();
HOSTNAME                       |SESSION  |
----------------------------------------------------------------------
localhost:1527                 |4

1 row selected

For this session, you could find your Spark job ID by correlating the displayed host and session IDs with the Job Group information displayed in the Spark console. For example:

Job Id
(Job Group)
Description Submitted Duration Stages:
Succeeded/Total
Tasks (for all stages):
Succeeded/Total
0 (SPLICE <localhost:1527,4,e5ff1a51-4ac1-4202-a74c-a2d54ab3525a,36096>) select * from sys.systables --splice-properties useSpark=true (kill) Produce Result Set 2017/08/25 14:03:07 8s 0/1 0/1