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.