[IMPALA-7015] Insert into Kudu table returns with Status OK even if there are Kudu errors

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 2.12.0
• Component/s: Backend
• Epic Color: ghx-label-9
• Assignee: Unassigned
• Reporter: Mostafa Mokhtar
• Created: 11/May/18 17:17
• Updated: 29/Jan/21 15:39

Description

DML statements against Kudu tables return status OK even if there are Kudu errors.
This behavior is misleading.

  Summary:
    Session ID: 18430b000e5dd8dc:e3e5dadb4a15d4b4
    Session Type: BEESWAX
    Start Time: 2018-05-11 10:10:07.314218000
    End Time: 2018-05-11 10:10:07.434017000
    Query Type: DML
    Query State: FINISHED
    Query Status: OK
    Impala Version: impalad version 2.12.0-cdh5.15.0 RELEASE (build 2f9498d5c2f980aa7ff9505c56654c8e59e026ca)
    User: mmokhtar
    Connected User: mmokhtar
    Delegated User: 
    Network Address: ::ffff:10.17.234.27:60760
    Default Db: tpcds_1000_kudu
    Sql Statement: insert into store_2 select * from store
    Coordinator: vd1317.foo:22000
    Query Options (set by configuration): 
    Query Options (set by configuration and planner): MT_DOP=0
    Plan: 

Operator          #Hosts   Avg Time  Max Time  #Rows  Est. #Rows  Peak Mem  Est. Peak Mem  Detail                                                
-------------------------------------------------------------------------------------------------------------------------------------------------
02:PARTIAL SORT        5  909.030us   1.025ms  1.00K       1.00K   6.14 MB        4.00 MB                                                        
01:EXCHANGE            5    6.262ms   7.232ms  1.00K       1.00K  75.50 KB              0  KUDU(KuduPartition(tpcds_1000_kudu.store.s_store_sk)) 
00:SCAN KUDU           5    3.694ms   4.137ms  1.00K       1.00K   4.34 MB              0  tpcds_1000_kudu.store                                 
    Errors: Key already present in Kudu table 'impala::tpcds_1000_kudu.store_2'. (1 of 1002 similar)

Issue Links

• is related to: IMPALA-10465 Improve Kudu DML error logging in Impala
• relates to: IMPALA-3710 INSERT, UPDATE, DELETE should ignore conflicts by default