Help Center/ MapReduce Service/ Component Operation Guide (LTS) (Ankara Region)/ Using Hudi/ Hudi SQL Syntax Reference/ Constraints
Updated on 2024-11-29 GMT+08:00
View PDF
Share

Constraints

Hudi supports the DDL/DML syntax of using Spark SQL, making it easier for all users (non-engineers and analysts) to access and operate Hudi.

Constraints

  • You can use Spark SQL to operate Hudi on the Hudi client.
  • Spark SQL operations can be performed on Hudi in JDBCServer of Spark.
  • Spark SQL operations cannot be performed on Hudi on the Spark client.
  • You cannot write data to Hudi tables or modify the Hudi table structure in Hive and Hetu engines. Only read operations are supported.
  • The default value of KeyGenerator in SQL is org.apache.hudi.keygen.ComplexKeyGenerator. Therefore, you need to set the KeyGenerator value to that of SQL when data is written in DataSource mode.
  • Only primary MOR tables can be modified. The MOR tables suffixed with ro or rt are used only for query.