Clear Values equal to 'Cell Value' does not behave as expected.
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.
0.9.2 with Livy in CDH sandbox VB