Regie, Looking at the error, it's alerting you that you cannot apply the + operator to string/char types. I would assume you need to use the concat function. Please follow the following documentation: http://hadooptutorial.info/string-functions-in-hive/#CONCAT So, something like: select CONCAT(firstname, ' ', lastname) from <tablename>; Amanda ... View more