[GitHub] [hudi] levisLi commented on issue #6931: SparkSQL create hudi DDL do not support hoodie.datasource.write.operation = 'insert'

[GitBox <gi...@apache.org>]

levisLi commented on issue #6931:
URL: https://github.com/apache/hudi/issues/6931#issuecomment-1276911694

   Version: hudi-0.11+spark-3.2.1
   Setup: ${SPARK_HOME}/bin/spark-sql
   Create hudi table with spark-sql cmd
   spark-sql >
   create table if not exists hudi.h3(
         id bigint,
        name string,
        price double
      ) using hudi
        options (
           primaryKey = 'id',
           type = 'mor',
           hoodie.cleaner.fileversions.retained = '1',
           hoodie.datasource.write.operation = 'insert');
   spark-sql> insert into hudi.h3 values(1,'name1','0.5');
   spark-sql> insert into hudi.h3 values(1,'name2','0.6');
   spark-sql> select * from hudi.h3;
    
   When i query my hudi table records,its show only one record,others two record
   I expect result is :
      1|name1|0.5
      1|name2|0.6
   But  last result is below: 
      1|name2|0.6 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org