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.

• Get All Questions & Answer for CDP Generalist Exam (CDP-0011) and trainings.
• Get All Questions & Answer for CDP Administrator - Private Cloud Base Exam CDP-2001 and trainings.
• Get All Questions & Answer for CDP Data Developer Exam CDP-3001 and trainings.

This Question is from QuickTechie Cloudera CDP Certification Preparation Kit. 

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