Hive scripts used in Hive version 0.9 with the CAST function within a view statement no longer executes successfully in hive 0.11 if columns are not in single quotes.

[#1]

SYMPTOMS:  Below is a sample query

CREATE VIEW salary AS SELECT fname, (CAST (lname AS STRING)) from Employees;

The result is:

FAILED: IllegalArgumentException replace op boundaries of <ReplaceOp@@17,43:47='lname',<26>,1:43..@17,43:47='lname',<26>,1:43:"`employees`.`lname`"> overlap with previous <ReplaceOp@@13,36:36='(',<266>,1:36..@23,59:59=')',<276>,1:59:"`employees`.`lname`">
hive>

ROOT CAUSE:  Product defect 

SOLUTION:  Filed bug BUG-8944 that has been fixed in HDP 1.3.3

This article created by Hortonworks Support (Article: 000001718) on 2013-12-23 13:05
OS: Linux
Type: Developing_Code