question Re: jason and jq help in Support Questions

jason and jq help

ananthan_kathir — Fri, 16 Sep 2022 13:17:21 GMT

I need jason jq help. I have the health status, but I need to grep the few field only using jq

{ "href" : "http://xxxx:8080/api/v1/clusters/?fields=Clusters/health_report", "items" : [ { "href" : "http://xxxxx:8080/api/v1/clusters/xxxxx", "Clusters" : { "cluster_name" : "xxxx", "health_report" : { "Host/stale_config" : 0, "Host/maintenance_state" : 13, "Host/host_state/HEALTHY" : 13, "Host/host_state/UNHEALTHY" : 0, "Host/host_state/HEARTBEAT_LOST" : 0, "Host/host_state/INIT" : 0, "Host/host_status/HEALTHY" : 12, "Host/host_status/UNHEALTHY" : 1, "Host/host_status/UNKNOWN" : 0, "Host/host_status/ALERT" : 0 }, "version" : "HDP-2.6" } } ]

I only want to grep Host/host_status/UNHEALTHY and it's value. How can I do using jq command

Re: jason and jq help

falbani — Fri, 01 Jun 2018 04:01:58 GMT

@Anpan K What about this:

jq '.items[0].Clusters.health_report'

HTH

*** If you found this answer addressed your question, please take a moment to login and click the "accept" link on the answer.

Re: jason and jq help

falbani — Fri, 01 Jun 2018 04:04:08 GMT

@Anpan K If you need the value just for "Host/host_status/UNHEALTHY" you can use this one:

jq '.items[0].Clusters.health_report."Host/host_status/UNHEALTHY"'

Re: jason and jq help

wcbdata — Fri, 01 Jun 2018 04:09:56 GMT

jq '.items[].Clusters.health_report."Host/host_status/UNHEALTHY"'

should work. The key name Host/host_status/UNHEALTHY should be quoted to escape the forward slashes in the name.

Re: jason and jq help

ananthan_kathir — Fri, 01 Jun 2018 04:10:46 GMT

Thank you, I am getting null value.

Re: jason and jq help

ananthan_kathir — Fri, 01 Jun 2018 04:18:43 GMT

thanks a lot , but here is the output

]$ cat file1 | jq '.items[].Clusters.health_report."Host/host_status/UNHEALTHY" '

jq: error (at <stdin>:19): Cannot iterate over null (null) ]

$ cat file1 | jq '.items[0].Clusters.health_report."Host/host_status/UNHEALTHY" '

null

Re: jason and jq help

falbani — Fri, 01 Jun 2018 04:21:24 GMT

@Anpan K could you share the content of file1? I have run the following successfully

curl -u admin:admin -X GET 'http://localhost:8080/api/v1/clusters/?fields=Clusters/health_report' | jq '.items[0].Clusters.health_report."Host/host_status/UNHEALTHY"'

HTH

Re: jason and jq help

ananthan_kathir — Fri, 01 Jun 2018 04:35:15 GMT

Wow working, thank you so much what is the diffrence between putting in the file and trying directly through curl

Re: jason and jq help

wcbdata — Fri, 01 Jun 2018 04:36:59 GMT

Is it possible that something in your original redirection to the file is removing a character or two? As pasted into your original question, it's invalid JSON, which would also give you an error (since jq would be trying to parse a non-parseable string).

Re: jason and jq help

falbani — Fri, 01 Jun 2018 04:37:27 GMT

@Anpan K Please take a moment to login and click the "accept" link on my answer answer.

Re: jason and jq help

wcbdata — Fri, 01 Jun 2018 04:38:57 GMT

Is it possible that something in your original redirection to the file was removing a character or two? As pasted into your original question, it's invalid JSON, which would also give you an error (since jq would be trying to parse a non-parseable string). Just to be thorough, could you attach the original file?

Re: jason and jq help

ananthan_kathir — Wed, 06 Jun 2018 03:24:33 GMT

one of them shows as unhealthy, how do I find out which component or service is unhealthy in command line.

"Host/stale_config" : 0, "Host/maintenance_state" : 13, "Host/host_state/HEALTHY" : 13, "Host/host_state/UNHEALTHY" : 0, "Host/host_state/HEARTBEAT_LOST" : 0, "Host/host_state/INIT" : 0, "Host/host_status/HEALTHY" : 12, "Host/host_status/UNHEALTHY" : 1, "Host/host_status/UNKNOWN" : 0, "Host/host_status/ALERT" : 0