[HIVE-3147] Regex Serde Column Type Not Checked Before Alter

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.7.1
• Component/s: CLI
• Assignee: Unassigned
• Reporter: Dan Fitch
• Created: 15/Jun/12 21:30
• Updated: 15/Jun/12 21:30

Description

Create a table without a RegexSerde and the columns with types other than string. Modify the table to use a RegexSerde and the table will update the metadata for the table to use the RegexSerde but any attempt to modify or read the table results in exceptions referencing the columns are not of type string.

I can't drop the table or modify the serde. I had to modify the metastore database columns of the table to strings manually to fix.