How to filter based on query/statement in CM

[#1]

Hi

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.

[#2 · Accepted solution]

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.

[#3]

@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... RLIKE ".*fawzea.*"' >>f.json

Can you help