I'm looking for Hive query scenarios, where it uses only mappers or only reducers. ... View more

In the below query, I want to force a column value to null by casting it to required datatype. This works with usual sql. But Hive is throwing the exception. Select * from(select driverid, name, ssn from drivers where driverid<15 UNION ALL Select driverid,name, cast(null as bigint) from drivers where driverid BETWEEN 18 AND 21) T ; SemanticException 3:48 Schema of both sides of union should match. T-subquery2 does not have the field ssn. Error encountered near token 'drivers'. ... View more

My dataset set is as below: 700,Angus (1995),Comedy 702,Faces (1968),Drama 703,Boys (1996),Drama 704,"Quest, The (1996)",Action|Adventure 705,Cosi (1996),Comedy 747,"Stupids, The (1996)",Comedy Create table movies( movieid int, title String, genre string) row format delimited fields terminated by ',' ; Select title , genre from movies; Since the rows have comma separated values, the records like 704,"Quest, The (1996)",Action|Adventure returns Quest as title, instead of Quest,The (1996). And Genre value is shown as The(1996) instead of Action|Adventure. How to load such data correctly by escaping the delimiter in the value ? ... View more