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

 

Step 2: On preview screen,on right panel, you will see a section of "Other Operations".

 

 


 


Step 3You get to see various options available under this section :

  • Delete Multiple Columns - When you click on this tab, a pop up appears containing all the columns in that dataset, with a check box associated with each column at the left, you can conveniently select the column you wish to delete from that list. If you wish to select all the columns, then you can tick the check box just next to "Column Name". It will select all columns on checking and deselects all the columns on uncheck. And then you can click on "Delete Columns" to delete the columns according to your selection.