I did LEFT OUTER JOIN on this and and it seems to work but i have another issue. The time of the job fetched by the zeppelin smart sense query and that of the same job on RM UI is different by two hours, how do i change that?
i did the following->
1) Go to HBASE -> Configs -> Custom hbase-site. Add the property
2) using the "timeZone" option in the Phoenix Thin Driver's
but it doesn't seem to work. Is there anything else i can do?
@Jay SenSharma Please can you help with how can i access these tables. some of my Tez jobs and all of my Spark jobs are not entering activity.job table. hence it is not giving many jobs in the output. I did left outer join so that i get all jobs but why is it happening?