Use csvserde to load the csv file into a staging Hive table. Once done write a select clause using regex which select only numbers & alphabets for every column and insert it into the target table. By that way you can eliminate the other characters.
Use [a-zA-Z0-9_.] in the regex function to select only numbers & alphabets. Hope it helps!!