JoshuaZhuCN opened a new issue, #6004: URL: https://github.com/apache/hudi/issues/6004
Creating a Hudi external table will modify the value of "hoodie.table.name" in the "hoodie.properties" file. This problem does not occur when using auto sync to hive. Then how can i create _rt table manually by using spark sql? **To Reproduce** Steps to reproduce the behavior: 1.execute the sql to create an external table ``` create table `default`.`spark_hudi_test_ddl` (`id` int, `vname` string, `price` decimal(14, 2), `sync_time` timestamp) using hudi options(`hoodie.query.as.ro.table` = 'true') TBLPROPERTIES (type='mor', primaryKey='id', preCombineField='sync_time') location 'hdfs://localhost:9000/hoodie/test/oms/spark_hudi_ddl'; ``` 2. see the hoodie.properties file，the value of hoodie.table.name is "spark_hudi_test_ddl" 3. try to execute the sql to create an _rt table ``` create table `default`.`spark_hudi_test_ddl_rt` using hudi options(`hoodie.query.as.ro.table` = 'false') TBLPROPERTIES (type='mor', primaryKey='id', preCombineField='sync_time') location 'hdfs://localhost:9000/hoodie/test/oms/spark_hudi_ddl'; ``` 4. see the hoodie.properties file，the value of hoodie.table.name is "spark_hudi_test_ddl_rt" **Expected behavior** A clear and concise description of what you expected to happen. **Environment Description** * Hudi version : 0.10.1 * Spark version : 3.1.3 * Hive version : 3.1.0 * Hadoop version : 3.1.1 * Storage (HDFS/S3/GCS..) : hdfs * Running on Docker? (yes/no) : no -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
