About SK1

SK1 · ‎12-03-2018

@Sampath Kumar, I have got all the required details via running sql on oozie db in mysql. select id,app_name,user_name,frequency,time_unit,start_time from oozie.COORD_JOBS where id in (select DISTINCT id from oozie.COORD_JOBS where status='RUNNING') order by start_time asc ;

SK1 · ‎11-27-2018

Hello @Sampath Kumar, It does not help because it does not give me coordinator owner name and it is same as I have mentioned above(oozie jobs -jobtype coordinator -len 10000000 | grep-i RUNNING). So is there anyway to get this info from backend db (mysql) ?

SK1 · ‎11-26-2018

I ran following commands and its giving me enough info except owner details.So is there anyway to know who is owned those jobs. oozie jobs -jobtype coordinator -len 10000000 | grep-i RUNNING

SK1 · ‎11-26-2018

Hello, Is there anyway from oozie backend db or command to find out how many oozie jobs are scheduled and running in entire clusters.

SK1 · ‎09-17-2018

Thanks a lot @Jay Kumar SenSharma. It ran in debug mode.

SK1 · ‎09-17-2018

I am getting following error when I am running sql in scala ? But error is not clear so can some one please help me to solve this error. Also how to setup debug mode in spark-shelI. scala> val df = spark.sql("select * from table1 limit 10"); df: org.apache.spark.sql.DataFrame = [itm_nbr: int, overall_e_coefficient: decimal(15,3) ... 16 more fields] scala> df.show(10) java.lang.RuntimeException: serious problem

SK1 · ‎08-16-2018

Hello , is there any way to find our number of hive queries ran in one day ? Actually I am looking for this because if we can find out similar queries then we can enable LLAP for them to get fast performance ? is it good idea or any other way to we can get better performance ?

SK1 · ‎08-08-2018

@Akhil S Naik How to replace IP's instead of FQDN ? I do not see any option to change it.

SK1 · ‎08-07-2018

Actually I have enabled proxy web server for yarn .and when I am looking logs for running jobs then it is proxy server redirecting me to one of the node manager where task is running and when I m clicking on on Logs then it is giving me following error. "This site can’t be reached w2.hdp22’s server DNS address could not be found." Tough if I change host fqdn to ips in URL string then it is working fine. http://w2.hdp22:8042/node/containerlogs/container_e18_1533570782201_0002_01_000001/root to http://196.152.56.51:8042/node/containerlogs/container_e18_1533570782201_0002_01_000001/root So I am thinking is this the good idea to change FQDN to ips or is there any other way ?

SK1 · ‎08-07-2018

can we register a new host with IP not a FQDN ?

Online	Offline
Last Visited	‎01-15-2021 02:12 AM

Member Since	‎05-29-2017 06:13 AM
Last Visited	‎01-15-2021 02:12 AM
Posts	408
Kudos received	123

Cloudera Community

Re: select * from table is not returning any rows ...

Re: Falcon feed throwing an error during feed sche...

Re: we are getting below error/exception while exe...

Re: bin/solr status throwing an error "clusterstat...

Re: How to solve buffer memory issue in Solr

Re: How to get all scheduled oozie coordinator job...

Re: How to get all scheduled oozie coordinator job...

Re: How to get all scheduled oozie coordinator job...

How to get all scheduled oozie coordinator jobs

Re: How to launch spark-shell in debug mode

How to launch spark-shell in debug mode

is there any way to find our number of hive querie...

Re: is it possible to change hostname fqdn to Ips ...

is it possible to change hostname fqdn to Ips only...

can we register a new host with IP not a FQDN