Skip to main content
HWSupport
Bronze ⭐️⭐️⭐️
Jul 21, 2016 10:01 PM UTC

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.

  • Oct 5, 2026 9:38 AM UTC
  • 0 replies
  • 749 views
  • Translate All
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