Null value handling in data wrangler/livy

Description

Clear Values equal to 'Cell Value' does not behave as expected.

Repro:
1. Create table with the following data:
CREATE TABLE HASNULLS ( name varchar(20), id int );
INSERT INTO HASNULLS VALUES ( NULL, 1 );
INSERT INTO HASNULLS VALUES ( 'NULL', 2 );
INSERT INTO HASNULLS VALUES ( 'null', 3 );
INSERT INTO HASNULLS VALUES ( 'NAME NOT NULL', 4 );
2. Select Clear Values equal to 'NAME NOT NULL'


3. The following is returned:


4. Click on the cell in row 4, name column and choose "Find rows equal to 'null'", it is expected that rows 1,3 and the transformed row for 4 will be returned. The result is row 3.

NOTE: tested in Livy and Shell environment. Spark-Shell is handling nulls correctly for this use case.

Environment

0.9.2 with Livy in CDH sandbox VB

Done

Assignee

Tim Harsch

Reporter

Tim Harsch

Labels

None

Reviewer

None

Story point estimate

2

Story Points

2

Components

Sprint

None

Fix versions

Affects versions

Priority

Medium