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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • Impala 2.12.0
    • Impala 2.12.0
    • Catalog
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: