FIRST/FIRST_VALUE function returning empty value

Elastic Stack Elasticsearch
1

Hi All,

I have to select records from an index, and have to select the latest values for a Mobile number. There can be more than one record for each mobile number.

I am using FIrst function for the same and it is returning me the latest values. However I have to ignore if the latest value is blank and select the next value

Is there a way/function to select the latest non blank value from an index using sql Api

2

You could use the IS NOT NULL in the WHERE clause.
Can you post the query you're trying to run?

1 Like
3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.