Mailing-List: contact user-help@impala.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@impala.apache.org
MIME-Version: 1.0
In-Reply-To: <CAETy=eWwfEXP_0KGH8bAORuuS9fTz9PwmJN9QmdjSjw6i1H2NQ@mail.gmail.com>
References: <CAHdkLANqmgw5BWjnnaKk4TCG3cac4agzHEOoGbFFdoFZtMoRcA@mail.gmail.com>
 <CAETy=eWwfEXP_0KGH8bAORuuS9fTz9PwmJN9QmdjSjw6i1H2NQ@mail.gmail.com>
From: Alexander Behm <alex.behm@cloudera.com>
Date: Wed, 13 Dec 2017 21:42:38 -0800
Message-ID: <CAMvjXi8uh2APQOLsKbW1UGAn4bRtHWzH0Rj3FZF=M-R7q9P+Kg@mail.gmail.com>
Subject: Re: Using comments in query for detailed monitoring
To: user@impala.apache.org
Content-Type: multipart/alternative; boundary="001a11c17e4a10d7bb0560465a8d"
archived-at: Thu, 14 Dec 2017 05:42:45 -0000

--001a11c17e4a10d7bb0560465a8d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Not sure if this will work, but you could try enabling useNativeQuery in
the driver. Theoretically that should send the query string including
comments verbatim to Impala.

On Wed, Dec 13, 2017 at 7:57 PM, Philip Zeyliger <philip@cloudera.com>
wrote:

> I=E2=80=99m a little surprised comments are being stripped, but adding (1=
=3D1 or
> =E2=80=9C=E2=80=9D=3D=E2=80=9Cyour comment=E2=80=9D) to a where clause wo=
uld work similarly. Impala will
> simplify that away during query compilation.
>
> P
>
> On Wed, Dec 13, 2017 at 7:22 PM Sunil Parmar <sunilosunil@gmail.com>
> wrote:
>
>> 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 things that are not
>> typically supplied in the query string. We were thinking to use query
>> comments to pass such information along with query. It worked fine when
>> query is executed using impala-shell; I can see the comments in the impa=
la
>> monitoring page i.e. on port #25000 but when comments are sent over JDBC=
 ;
>> they're not visible to Impalad.
>>
>> 1. Is there an configuration in Impala driver ? We're using
>>      <dependency>
>>       <groupId>com.cloudera.impala</groupId>
>>       <artifactId>impala-jdbc</artifactId>
>>       <version>2.5.30</version>
>>       <scope>compile</scope>
>>     </dependency>
>>
>> 2. Is there any other way to send such hints along with query ?
>>
>>
>> Thanks,
>> Sunil
>>
>>

--001a11c17e4a10d7bb0560465a8d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Not sure if this will work, but you could try enabling use=
NativeQuery in the driver. Theoretically that should send the query string =
including comments verbatim to Impala.</div><div class=3D"gmail_extra"><br>=
<div class=3D"gmail_quote">On Wed, Dec 13, 2017 at 7:57 PM, Philip Zeyliger=
 <span dir=3D"ltr">&lt;<a href=3D"mailto:philip@cloudera.com" target=3D"_bl=
ank">philip@cloudera.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmai=
l_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left=
:1ex"><div><div dir=3D"auto">I=E2=80=99m a little surprised comments are be=
ing stripped, but adding (1=3D1 or =E2=80=9C=E2=80=9D=3D=E2=80=9Cyour comme=
nt=E2=80=9D) to a where clause would work similarly. Impala will simplify t=
hat away during query compilation.=C2=A0</div><span class=3D"HOEnZb"><font =
color=3D"#888888"><div dir=3D"auto"><br></div><div dir=3D"auto">P</div></fo=
nt></span><div><div class=3D"h5"><br><div class=3D"gmail_quote"><div>On Wed=
, Dec 13, 2017 at 7:22 PM Sunil Parmar &lt;<a href=3D"mailto:sunilosunil@gm=
ail.com" target=3D"_blank">sunilosunil@gmail.com</a>&gt; wrote:<br></div><b=
lockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px =
#ccc solid;padding-left:1ex"><div><div>Server version: impalad version 2.9.=
0-cdh5.12.1 RELEASE (build 5131a031f4aa38c1e50c430373c55c<wbr>a53e0517b9)</=
div><div><br></div><div>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 bui=
ld monitoring metrics per web page, logged in user and other things that ar=
e not typically supplied in the query string. We were thinking to use query=
 comments to pass such information along with query. It worked fine when qu=
ery is executed using impala-shell; I can see the comments in the impala mo=
nitoring page i.e. on port #25000 but when comments are sent over JDBC ; th=
ey&#39;re not visible to Impalad. <br></div><div><br></div><div>1. Is there=
 an configuration in Impala driver ? We&#39;re using <br></div><div>=C2=A0 =
=C2=A0=C2=A0 &lt;dependency&gt;<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &lt;group=
Id&gt;com.cloudera.impala&lt;/<wbr>groupId&gt;<br>=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0 &lt;artifactId&gt;impala-jdbc&lt;/<wbr>artifactId&gt;<br>=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0 &lt;version&gt;2.5.30&lt;/version&gt;<br>=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0 &lt;scope&gt;compile&lt;/scope&gt;<br>=C2=A0=C2=A0=C2=A0=
 &lt;/dependency&gt;<br></div><div><br></div><div>2. Is there any other way=
 to send such hints along with query ?</div><div><br></div><div><br></div><=
div>Thanks,</div><div>Sunil<br></div><div><br></div></div>
</blockquote></div></div></div></div>
</blockquote></div><br></div>

--001a11c17e4a10d7bb0560465a8d--