Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

How to filter based on query/statement in CM

SOLVED Go to solution

How to filter based on query/statement in CM

Explorer

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

Accepted Solutions
Highlighted

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

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.
2 REPLIES 2
Highlighted

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

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.

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

Super 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