Re: Using comments in query for detailed monitoring

The driver with this fix is now available. http://community.cloudera.com/t5/Community-News-Release/ANNOUNCE-New-Impala-JDBC-Driver-Released/m-p/65325#M220 On Fri, Feb 16, 2018 at 5:59 PM, Greg Rahn wrote: > Unfortunately there is not a JIRA to track because the drivers are

Re: Using comments in query for detailed monitoring

Unfortunately there is not a JIRA to track because the drivers are maintained by a 3rd party and are not part of the Apache Impala project. FWIW the version I tested was 2.5.43.1063 On Fri, Feb 16, 2018 at 4:52 PM, Sunil Parmar wrote: > Thanks is there a JIRA we can track

Re: Using comments in query for detailed monitoring

Thanks is there a JIRA we can track ? Sunil Parmar On Tue, Feb 13, 2018 at 3:18 PM, Greg Rahn wrote: > An upcoming release of the Impala driver will include a fix for not > removing comments when UseNativeQuery=1 is used. > > On Fri, Jan 26, 2018 at 10:29 AM, Greg Rahn

Re: Using comments in query for detailed monitoring

An upcoming release of the Impala driver will include a fix for not removing comments when UseNativeQuery=1 is used. On Fri, Jan 26, 2018 at 10:29 AM, Greg Rahn wrote: > I was able to repro this as well and checking in with Simba who authors > the driver. > > > On Wed, Jan

Re: Using comments in query for detailed monitoring

I was able to repro this as well and checking in with Simba who authors the driver. On Wed, Jan 17, 2018 at 9:03 PM, Sunil Parmar wrote: > Tried with case change but no luck. From the connection log. > > Jan 17 20:33:38.163 TRACE 1 >

Re: Using comments in query for detailed monitoring

Tried with case change but no luck. From the connection log. Jan 17 20:33:38.163 TRACE 1 com.cloudera.jdbc.common.SConnection.nativeSQL("select sum(1) from dwh.event_detail where org_group_id > 10; /*abcdefg*/"): + enter + Jan 17 20:33:38.163 TRACE 1 com.cloudera.hivecommon.core.

Re: Using comments in query for detailed monitoring

I’m a little surprised comments are being stripped, but adding (1=1 or “”=“your comment”) to a where clause would work similarly. Impala will simplify that away during query compilation. P On Wed, Dec 13, 2017 at 7:22 PM Sunil Parmar wrote: > Server version: impalad

Using comments in query for detailed monitoring

Server version: impalad version 2.9.0-cdh5.12.1 RELEASE (build 5131a031f4aa38c1e50c430373c55ca53e0517b9) One of the primary use of of Impala is it acts as a backend to a web application exposed to lot of users. We are trying to build monitoring metrics per web page, logged in user and other