Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to filter based on query/statement in CM

avatar
Contributor

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.

1 ACCEPTED SOLUTION

avatar
Champion
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.

View solution in original post

2 REPLIES 2

avatar
Champion
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.

avatar
Master Collaborator

@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