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 column which you want to rename.
Step 3: Double click the column name which you want rename, it will allow you to edit the name
Step 4: Type the new name and press enter to rename the column.