coverting time

[lmit]

Hi All,

Am using tstatscatcher component, it has a column duration i want to calculate the end time from duration column how can i do it?

I searched in forum and tried with new java.util.Date(ColumnName) , but its not giving the correct date 

for example if i have 4000 as input its giving output as "05:30:04.000" -- its adding IST how can i handle it.

Thanks in advance,

Lmit

[vboppudi]

Hi Lmit,

What is the expected output for 4000.

i am assuming expected output should be 4000 = 01:06:40, please conform.

Regards,

[lmit]

Thanks for your reply Veeranjaneyulu,

Yes your assumption is correct

to be more clear , i want to add moment and duration which will come from tstatscatcher component so that i can generate end time of a job.please find the attachment for the columns.my end time should be data and timestamp

Thanks,

lmit

endtime.jpg

[hami1]

Hi,

If you have some knowledge on Java , you can try tJava Component and try to convert the seconds into the HH:mm:ss format. For your reference am providing you a sample code which will convert the seconds into HH:MM:ss  time format.

        int seconds = 4000;
        int p1 = seconds % 60;
        int p2 = seconds / 60;
        int p3 = p2 % 60;
try{
        System.out.print("Input seconds:");
        p2 = p2 / 60;
        System.out.print( p2 + ":" + p3 + ":" + p1);
    }    
finally
{
}

Thanks,

Hameed

[vboppudi]

Hi Lmit,

If you want to derive start and end time of job, you need derive it based two records from tstatscatcher. 

+-------------------+-------------------------+
| key | value |
+-------------------+-------------------------+
| moment | 2018-03-15 09:12:55 |
| pid | c8EvWV |
| father_pid | c8EvWV |
| root_pid | c8EvWV |
| system_pid | 14512 |
| project | PRICTICE |
| job | job_CMS_PROCESS |
| job_repository_id | _O6fewAbYEei8pvE2fGbI1g |
| job_version | 0.1 |
| context | Default |
| origin | null |
| message_type | begin |
| message | null |
| duration | null |
+-------------------+-------------------------+

+-------------------+-------------------------+
| key | value |
+-------------------+-------------------------+
| moment | 2018-03-15 09:13:11 |
| pid | c8EvWV |
| father_pid | c8EvWV |
| root_pid | c8EvWV |
| system_pid | 14512 |
| project | PRICTICE |
| job | job_CMS_PROCESS |
| job_repository_id | _O6fewAbYEei8pvE2fGbI1g |
| job_version | 0.1 |
| context | Default |
| origin | null |
| message_type | end |
| message | success |
| duration | 16087 |
+-------------------+-------------------------+

If message_type begin means job start and message_type='end' means job end time.

The duration is not in seconds, its in milliseconds. If you want to caluclate start and end time using one record, you need to use message_type='end' record and substract duration from moment, so you will get start time of that process.

Regards,

[lmit]

Thanks for your replies,

when i was clearing observing the tstatcatcher records i noticed that the begin and end records have different timestamp, the time(moment column) in the end record can be consider as end time?

If you see in the attachment , for both records of same flow has a timestamp difference of one sec. so can i consider it as a end time of the job?

Thanks,

lmit

stat_endtime.jpg

[hami1]

Yes lmit, you can consider this as the Job Execution duration as 1 Sec(Time taken to finish the Job).

Thanks,

skh