According to the Hive SerDe Docs, there are some extras steps involved in getting the CSV SerDe working with Hive.
I would like to propose that we move this SerDe into first-class status:
STORED AS CSVFILE
STORED AS TSVFILE
The user should have to perform no additional steps to use this SerDe.