Reply
Explorer
Posts: 23
Registered: ‎02-22-2016
Accepted Solution

How to filter based on query/statement in CM

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.

Posts: 642
Topics: 3
Kudos: 121
Solutions: 67
Registered: ‎08-16-2016

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

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.
Highlighted
Expert Contributor
Posts: 362
Registered: ‎01-25-2017

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

@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