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

["Pavan Kulkarni (JIRA)" <ji...@apache.org>]

Pavan Kulkarni created KUDU-1665:
------------------------------------

             Summary: KUDU lets you create table with wrong/non existent 'kudu.key_columns' columns and then it fails to load/drop the table
                 Key: KUDU-1665
                 URL: https://issues.apache.org/jira/browse/KUDU-1665
             Project: Kudu
          Issue Type: Bug
          Components: master
    Affects Versions: 0.10.0
         Environment: Linux 
            Reporter: Pavan Kulkarni


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)