[KUDU-1665] KUDU lets you create table with wrong/non existent 'kudu.key_columns' columns and then it fails to load/drop the table

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.0.0
• Fix Version/s: n/a
• Component/s: master
• Labels: kudu
• Environment: Linux
• Assignee: Unassigned
• Reporter: Pavan Kulkarni
• Created: 29/Sep/16 20:15
• Updated: 06/Mar/17 20:22
• Resolved: 06/Mar/17 20:22

Description

Create a table
CREATE TABLE test(
id INT,
display_name STRING
)
DISTRIBUTE BY RANGE (id)
SPLIT ROWS ((10000),(20000),(30000))
TBLPROPERTIES(
'storage_handler' = 'com.cloudera.kudu.hive.KuduStorageHandler',
'kudu.table_name' = 'test',
'kudu.master_addresses' = 'master_server:port',
'kudu.key_columns' = 'id,wrong_column,non_existent_column'
);
It succesfully creates the table, but on loading or dropping the table you get an exception as follows:
ERROR: AnalysisException: Some key columns were not found in the set of columns. List of column names: [wrong_column,non_existent_column]
CAUSED BY: TableLoadingException: Some key columns were not found in the set of columns. List of column names: [wrong_column,non_existent_column]

The fix should be to check the id columns exist as legit columns in the table before creating it.