[HIVE-4344] CREATE VIEW fails when redundant casts are rewritten

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.11.0
• Fix Version/s: 0.12.0
• Component/s: Query Processor
• Assignee: Samuel Yuan
• Reporter: Samuel Yuan
• Created: 12/Apr/13 02:02
• Updated: 17/Oct/13 22:01
• Resolved: 24/Jul/13 04:04

Description

e.g. create view v as select cast(key as string) from src;

The rewriter tries to replace both cast(key as string) and key as `src`.`key`, because cast(key as string) is a no-op.

There may be other cases like this one.

See HIVE-2439 for context.

Issue Links

• is related to: HIVE-4547 A complex create view statement fails with new Antlr 3.4