hi xinyu, 1. about the issue in https://issues.apache.org/jira/browse/CARBONDATA-4334 you can create the table with the sort_scope option(GLOBAL_SORT or LOCAL_SORT), it will help to sort data during loading.
2. about configuration, the following parameters can be used. spark.driver.extraJavaOptions -Dcarbon.properties.filepath = $SPARK_HOME/conf/carbon.properties spark.executor.extraJavaOptions -Dcarbon.properties.filepath = $SPARK_HOME/conf/carbon.properties Note: put carbon.properties file to the specified path.