[HIVE-6141] Can't select from views after upgrading metastore from 0.7 to 0.10

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.10.0
• Component/s: Metastore
• Assignee: Unassigned
• Reporter: dima machlin
• Created: 05/Jan/14 13:43
• Updated: 05/Jan/14 13:45

Description

Selecting from a view created in 0.7 after upgrade to 0.10 fails on

Invalid table alias or column reference

The reason is that while running this :

create view a as select b from c.d;

in v0.7 will generate in the metastore this SQL :

select `c.d`.b from `c`.`d`;

which fails in v0.10
While running the same create SQL in v0.10 generates different SQL in the metastore :

select `d`.b from `c`.`d`;

which succeeds in v0.10 (notice there is no DB prefix in the select part)

A workaround is to recreate the view.