web console argument support

[Evaldas Miliauskas]

Right now I cannot execute a following query in Web Console:
"select count(*) from ReviewCacheRecord where city = ?"
as I get:
[CacheException] class org.apache.ignite.IgniteException: Invalid number of
query parameters. Cannot find 1 parameter.
    [IgniteException] Invalid number of query parameters. Cannot find 1
parameter.

How one should set arguments?
--
Thanks,
Evaldas Miliauskas

[Alexey Kuznetsov]

Hi, Evaldas!

There no such feature in Web Console yet.
But I think it is worth to implement.
Feel free to create issue in JIRA for this.
But I suppose it is not that trivial and may be not implemented quickly.

On Tue, Jun 26, 2018 at 1:46 AM Evaldas Miliauskas <
[hidden email]> wrote:

> Right now I cannot execute a following query in Web Console:
> "select count(*) from ReviewCacheRecord where city = ?"
> as I get:
> [CacheException] class org.apache.ignite.IgniteException: Invalid number of
> query parameters. Cannot find 1 parameter.
>     [IgniteException] Invalid number of query parameters. Cannot find 1
> parameter.
>
> How one should set arguments?
> --
> Thanks,
> Evaldas Miliauskas
>
> --
> Alexey Kuznetsov
>
>

[dsetrakyan]

Hi Evaldas,

I am not sure why do you need to pass the "?" from the Web Console? Why not
just pass the real parameter?

D.

On Mon, Jun 25, 2018 at 7:05 PM, Evaldas Miliauskas <
[hidden email]> wrote:

> Right now I cannot execute a following query in Web Console:
> "select count(*) from ReviewCacheRecord where city = ?"
> as I get:
> [CacheException] class org.apache.ignite.IgniteException: Invalid number
> of
> query parameters. Cannot find 1 parameter.
>     [IgniteException] Invalid number of query parameters. Cannot find 1
> parameter.
>
> How one should set arguments?
> --
> Thanks,
> Evaldas Miliauskas
>

[Evaldas Miliauskas]

Hey, I was trying to test queries that use condition "? is null" to be able
to use explain command and see what query plan is generated.

On Tue, Jun 26, 2018 at 11:15 AM, Dmitriy Setrakyan <[hidden email]>
wrote:

> Hi Evaldas,
>
> I am not sure why do you need to pass the "?" from the Web Console? Why
> not just pass the real parameter?
>
> D.
>
> On Mon, Jun 25, 2018 at 7:05 PM, Evaldas Miliauskas <
> [hidden email]> wrote:
>
>> Right now I cannot execute a following query in Web Console:
>> "select count(*) from ReviewCacheRecord where city = ?"
>> as I get:
>> [CacheException] class org.apache.ignite.IgniteException: Invalid number
>> of
>> query parameters. Cannot find 1 parameter.
>>     [IgniteException] Invalid number of query parameters. Cannot find 1
>> parameter.
>>
>> How one should set arguments?
>> --
>> Thanks,
>> Evaldas Miliauskas
>>
>
>

--
Thanks,
Evaldas Miliauskas
StackTome
Co-Founder

[image: View my LinkedIn profile from The Linked In Man]
<https://www.linkedin.com/in/evaldas-miliauskas-6269b5132/>

[dsetrakyan]

On Tue, Jun 26, 2018 at 9:23 AM, Evaldas Miliauskas <
[hidden email]> wrote:

> Hey, I was trying to test queries that use condition "? is null" to be
> able to use explain command and see what query plan is generated.
>

Got it. Currently web console accepts SQL statements, not JDBC statements.
I would just change the argument name manually for now.

[Evaldas Miliauskas]

I see, could you give an example about "changing arg name manually"? Or do
you mean only constant values can be passed as args in that case?

On Tue, Jun 26, 2018 at 11:28 AM, Dmitriy Setrakyan <[hidden email]>
wrote:

>
>
> On Tue, Jun 26, 2018 at 9:23 AM, Evaldas Miliauskas <
> [hidden email]> wrote:
>
>> Hey, I was trying to test queries that use condition "? is null" to be
>> able to use explain command and see what query plan is generated.
>>
>
> Got it. Currently web console accepts SQL statements, not JDBC
> statements.  I would just change the argument name manually for now.
>
>

--
Thanks,
Evaldas Miliauskas
StackTome
Co-Founder

[image: View my LinkedIn profile from The Linked In Man]
<https://www.linkedin.com/in/evaldas-miliauskas-6269b5132/>

[dsetrakyan]

On Tue, Jun 26, 2018 at 9:58 AM, Evaldas Miliauskas <
[hidden email]> wrote:

> I see, could you give an example about "changing arg name manually"? Or do
> you mean only constant values can be passed as args in that case?
>

What I meant is passing an actual value instead of the "?".

[Evaldas Miliauskas]

I see ok thanks!

On Tue, Jun 26, 2018 at 12:18 PM, Dmitriy Setrakyan <[hidden email]>
wrote:

>
>
> On Tue, Jun 26, 2018 at 9:58 AM, Evaldas Miliauskas <
> [hidden email]> wrote:
>
>> I see, could you give an example about "changing arg name manually"? Or
>> do you mean only constant values can be passed as args in that case?
>>
>
> What I meant is passing an actual value instead of the "?".
>
>

--
Thanks,
Evaldas Miliauskas
StackTome
Co-Founder

[image: View my LinkedIn profile from The Linked In Man]
<https://www.linkedin.com/in/evaldas-miliauskas-6269b5132/>