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.

How to filter based on query/statement in CM

Solved Go to solution
Highlighted

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

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

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