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.
SYMPTOMS: Below is a sample query
ROOT CAUSE: Product defect
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

