did you try runining the query in the hive shell or beeline ?  was your hiveserver2 up and runining during the query execution time ?    you may want to take peek in this current settings in your cluster    hive.server2.session.check.interval hive.server2.idle.operation.timeout hive.server2.idle.session.timeout ... View more

It has been a long time since this question was answered. Has there been further recommendation by Cloudera on this ? Does cloudera support STRING data type to be used to store BINARY data ? or its something that works today and may stop working tomorrow ? ... View more