question Re: How to filter based on query/statement in CM in Archives of Support Questions (Read Only)

How to filter based on query/statement in CM

npdell — Fri, 16 Sep 2022 11:05:46 GMT

I wanted to list down all insert statements run in impala for a specific duration (impala queries), How do i query that. I am looking for something like statement like insert* (it should list all the statment which starts with insert). But this option not available.

Pls suggest any alternatives.

Re: How to filter based on query/statement in CM

mbigelow — Fri, 17 Feb 2017 08:07:48 GMT

In CM, in the cluster drop down menu select Impala queries. Select your time range and then enter statement RLIKE 'insert.*' into the search box. That should do it.

Re: How to filter based on query/statement in CM

Fawze — Sun, 05 Nov 2017 14:52:35 GMT

@mbigelow Hi mbigelow,

I tried to use LIKE in the CM API with now success:

I ahve one like this:

curl -u 'xxxx':'xxxx' 'http://CM_server.domain.com:7180/api/v11/clusters/cluster/services/impala/impalaQueries?from=2017-10-10T00:00:00&to2017-10-11T00:00:00&limit=1000&filter=statement RLIKE ".*fawzea.*"' >>f.json

Can you help