Storing result of Cassandra select into variable

[André Schütz <an...@wegtam.com>]

Hi,

I am trying to store the result of a SELECT query (1) to Cassandra into
a variable to use this within a second (2) query.

Sample of second query (2) where I would like to have a SEQ of
possibilities for the Dynamic Form:

{code}
SELECT * FROM companies WHERE country = '${country=Germany,Germany|USA|
France}';
{/code}

Should be:

{code}
SELECT * FROM companies WHERE country = '${country=Germany,$countries}';
{/code}

Would it be possible to execute a first query (1) like the following to
store the possible country names within a Sequence?

{code}
val countries = SELECT distinct country FROM companies;
{/code}

Is there may be a possibility?

Thank you for any help.

Kind regards,
Andre

-- 
Andre Schütz
COO / Founder - Wegtam GmbH
andre@wegtam.com | P: +49 (0) 381-80 699 041 | M: +49 (0) 176-218 02 604
www.wegtam.com | www.tensei-data.com | www.wegtam.net

Re: Storing result of Cassandra select into variable

[DuyHai Doan <do...@gmail.com>]

There is no integration for the moment yet of the Cassandra interpreter
with the common data sharing infrastructure

On Fri, Feb 9, 2018 at 2:47 PM, André Schütz <an...@wegtam.com> wrote:

> Hi,
>
> I am trying to store the result of a SELECT query (1) to Cassandra into
> a variable to use this within a second (2) query.
>
> Sample of second query (2) where I would like to have a SEQ of
> possibilities for the Dynamic Form:
>
> {code}
> SELECT * FROM companies WHERE country = '${country=Germany,Germany|USA|
> France}';
> {/code}
>
> Should be:
>
> {code}
> SELECT * FROM companies WHERE country = '${country=Germany,$countries}';
> {/code}
>
> Would it be possible to execute a first query (1) like the following to
> store the possible country names within a Sequence?
>
> {code}
> val countries = SELECT distinct country FROM companies;
> {/code}
>
> Is there may be a possibility?
>
> Thank you for any help.
>
> Kind regards,
> Andre
>
> --
> Andre Schütz
> COO / Founder - Wegtam GmbH
> andre@wegtam.com | P: +49 (0) 381-80 699 041 | M: +49 (0) 176-218 02 604
> www.wegtam.com | www.tensei-data.com | www.wegtam.net
>