[IMPALA-6687] Upsert fails on Kudu table with upper case primary key and default value

• 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: kudu
• Epic Color: ghx-label-6
• Assignee: Thomas Tauber-Marshall
• Reporter: Thomas Tauber-Marshall
• Created: 16/Mar/18 17:16
• Updated: 21/Mar/18 18:43
• Resolved: 21/Mar/18 18:43

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)