Uploaded image for project: 'Kudu'
  1. Kudu
  2. KUDU-1665

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

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Invalid
    • 1.0.0
    • n/a
    • master
    • Linux

    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.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            pkulkarnibe@gmail.com Pavan Kulkarni
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment