[
https://issues.apache.org/jira/browse/SOLR-13560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joel Bernstein updated SOLR-13560:
----------------------------------
Description:
This ticket adds two Stream Evaluators for testing for null values in Tuples.
These are much needed functions as currently null values are not possible to
detect with the *eq* Stream Evaluator because null values are evaluated to the
parameter name, rather then null. This change was made to support String
literal parameters without quotes.
The isNull and notNull Stream Evaluators properly detect nulls so they can be
used to filter tuples in a *having* expression or replace nulls in a *select*
expression.
Sample syntax for null filtering:
{code:java}
having(random(testapp, q="*:*", fl="response_d", rows="20000"),
notNull(response_d)){code}
Sample syntax for null filterring:
{code:java}
select(random(testapp, q="*:*", fl="id, response_d", rows="20000"),
id,
if(isNull(response_d),-1, response_d) as response_d){code}
was:
This ticket adds two Stream Evaluators for testing for null values in Tuples.
These are much needed functions as currently null values are not possible to
detect with the *eq* Stream Evaluator because null values are evaluated to the
parameter name, rather then null. This change was made to support String
literal parameters without quotes.
The isNull and notNull Stream Evaluators properly detect nulls so they can be
used to filter tuples in a *having* expression or replace nulls in a *select*
expression.
Sample syntax for null filtering:
{code:java}
having(random(testapp, q="*:*", fl="response_d", rows="20000"),
notNull(response_d)){code}
Sample syntax for null filterring:
{code:java}
select(random(testapp, q="*:*", fl="id, response_d", rows="20000"),
id,
if(isNull(response_d),-1, response_d) as response_d){code}
> Add isNull and notNull Stream Evaluators
> ----------------------------------------
>
> Key: SOLR-13560
> URL: https://issues.apache.org/jira/browse/SOLR-13560
> Project: Solr
> Issue Type: New Feature
> Security Level: Public(Default Security Level. Issues are Public)
> Reporter: Joel Bernstein
> Priority: Major
> Attachments: SOLR-13560.patch
>
>
> This ticket adds two Stream Evaluators for testing for null values in Tuples.
> These are much needed functions as currently null values are not possible to
> detect with the *eq* Stream Evaluator because null values are evaluated to
> the parameter name, rather then null. This change was made to support String
> literal parameters without quotes.
> The isNull and notNull Stream Evaluators properly detect nulls so they can be
> used to filter tuples in a *having* expression or replace nulls in a *select*
> expression.
> Sample syntax for null filtering:
> {code:java}
> having(random(testapp, q="*:*", fl="response_d", rows="20000"),
> notNull(response_d)){code}
> Sample syntax for null filterring:
> {code:java}
> select(random(testapp, q="*:*", fl="id, response_d", rows="20000"),
> id,
> if(isNull(response_d),-1, response_d) as response_d){code}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
