Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-6687

Upsert fails on Kudu table with upper case primary key and default value

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: Impala 2.12.0
    • Fix Version/s: Impala 2.12.0
    • Component/s: Catalog
    • Labels:
    • Epic Color:
      ghx-label-6

      Description

      Repro:

      > create table test1 (A string primary key, b int default 0) stored as kudu;
      > upsert into test1 (A) values ('a');
      ERROR: AnalysisException: All primary key columns must be specified for UPSERTing into Kudu tables. Missing columns are: a
      
      I0316 10:14:27.774098  8825 jni-util.cc:230] org.apache.impala.common.AnalysisException: All primary key columns must be specified for UPSERTing into Kudu tables. Missing columns are: a
              at org.apache.impala.analysis.InsertStmt.checkRequiredKuduColumns(InsertStmt.java:591)
              at org.apache.impala.analysis.InsertStmt.checkColumnCoverage(InsertStmt.java:539)
              at org.apache.impala.analysis.InsertStmt.analyze(InsertStmt.java:369)
              at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:424)
              at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:393)
              at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1014)
              at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:156)
      

        Attachments

          Activity

            People

            • Assignee:
              twmarshall Thomas Tauber-Marshall
              Reporter:
              twmarshall Thomas Tauber-Marshall
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: