[FEATURE]Add isEmpty ppl command

[YANG-DB]

Is your feature request related to a problem?
Add isEmpty command for PPL spark based execution driver .

Since spark sql doesnt offer such expression a possible option would be:

• translate the expression into a where clause which is an equivalent of

SELECT CASE  
       WHEN length(trim(column_name)) = 0 THEN true 
        ELSE false     
END AS is_empty

• register a custom expression IsEmptyExpression

Do you have any additional context?

• [META]Add Missing PPL commands - campaign #408

[kt-eliatra]

@YANG-DB
hi, just to confirm, isempty as well as ispresent and isblank - all of them should be implemented as commands?
e.g source=table | isempty(column);
Or rather as a functions? e.g. source=table | fields col_a, col_b | where isempty(col_c)?

[YANG-DB]

IMO functions - @LantaoJin what are your thoughts?

[lukasz-soszynski-eliatra]

@YANG-DB
I have a question related to the edge case associated with ternary logic. What should be the outcome of invoking eval r = isempty(null)? According to the below definition

SELECT CASE  
       WHEN length(trim(column_name)) = 0 THEN true 
        ELSE false     
END AS is_empty

isempty(null) evaluates to false. Is this expected?

[lukasz-soszynski-eliatra]

The initial implementation is ready for review. The version contains the unresolved problem described in the above comment. @YANG-DB , please let me know what you think.

[salyh]

can we close this as #676 is merged?