[SUPPORT] The query results of the Hive and Spark columns are different

[minchowang]

This patch is great, but there is one small problem，following：

• when I delete record with id 5
  hive query reslut：
  
  spark query reslut：
  
  flink query reslut is right

Originally posted by @mincwang in #3703 (comment)

[minchowang]

hive> desc user_rt;
OK
_hoodie_commit_time     string
_hoodie_commit_seqno    string
_hoodie_record_key      string
_hoodie_partition_path  string
_hoodie_file_name       string
_hoodie_operation       string
id                      int
name                    string

spark reslut lost the _hoodie_operation column

[minchowang]

cc @garyli1019

[minchowang]

hope to contain the _hoodie_operation column for the spark sql query

[xushiyan]

@mincwang makes sense. tracking this in https://issues.apache.org/jira/browse/HUDI-2941

[XuQianJin-Stars]

hi @mincwang I put a pr for fix this. #4649

[minchowang]

hi @mincwang I put a pr for fix this. #4649

thanks a lot for your support