Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, you will get to Preview Screen.

 

Step 2: On preview screen, select the"remove null" from others section in drop down list as shown

 

 

 


 

Step 3:  As and when you click on remove null, the system will apply the operation and will delete the null entries by deleting the rows.