[Image](/uploads/documents/2/5/8/d/258d7dc08dc63cce8614319473794444/p24_2.jpg) ## TPCH performance improvement TPCH 性能提升 24% ![Image](/uploads/documents/2/5/8/d/258d7dc08dc63cce8614319473794444/p25_1

+---------------------| 1 row selected (0.422 seconds) 0: jdbc:hive2://localhost:10009/default> select * from tpch.tiny.customer limit 6; 11:10:07.869 INFO org.apache.kyuubi.operation.ExecuteStatement: Processing cd1-d1e2-4068-b250-c5a66950e629]: INITIALIZED_STATE -> PENDING_STATE, statement: select * from tpch.tiny.customer limit 6 11:10:07.878 INFO org.apache.kyuubi.operation.ExecuteStatement: Processing b96ccd1-d1e2-4068-b250-c5a66950e629]: PENDING_STATE -> RUNNING_STATE, statement: select * from tpch.tiny.customer limit 6 11:10:07.871 INFO org.apache.kyuubi.engine.trino.operation.ExecuteStatement:

-----+ 1 row selected (0.422 seconds) 0: jdbc:hive2://localhost:10009/default> select * from tpch.tiny.customer limit 6; 11:10:07.869 INFO org.apache.kyuubi.operation.ExecuteStatement: Processing query[8b96ccd1-d1e2-4068-b250-c5a66950e629]: INITIALIZED_STATE -> PENDING_STATE, statement: select * from tpch.tiny.customer limit 6 11:10:07.878 INFO org.apache.kyuubi.operation.ExecuteStatement: Processing query[8b96ccd1-d1e2-4068-b250-c5a66950e629]: PENDING_STATE -> RUNNING_STATE, statement: select * from tpch.tiny.customer limit 6 11:10:07.877 INFO org.apache.kyuubi.engine.trino.operation.ExecuteStatement:

-----+ 1 row selected (0.422 seconds) 0: jdbc:hive2://localhost:10009/default> select * from tpch.tiny.customer limit 6; 11:10:07.869 INFO org.apache.kyuubi.operation.ExecuteStatement: Processing query[8b96ccd1-d1e2-4068-b250-c5a66950e629]: INITIALIZED_STATE -> PENDING_STATE, statement: select * from tpch.tiny.customer limit 6 11:10:07.878 INFO org.apache.kyuubi.operation.ExecuteStatement: Processing query[8b96ccd1-d1e2-4068-b250-c5a66950e629]: PENDING_STATE -> RUNNING_STATE, statement: select * from tpch.tiny.customer limit 6 11:10:07.877 INFO org.apache.kyuubi.engine.trino.operation.ExecuteStatement:

jar deployed with Kyuubi distributions 2. a copy of spark distribution 3. kyuubi-spark-connector-tpch-1.7.0_2.12.jar, which can be found in the Maven Central In order to make the TPC-H connector package the TPC-H connector package into $SPARK_HOME/jars directly 2. Set spark.jars=kyuubi-spark-connector-tpch-1.7.0_2.12.jar ## Configurations To add TPC-H tables as a catalog, we can set the following configurations defaults.conf: # (required) Register a catalog named `tpch` for the spark engine. spark.sql.catalog.tpch=org.apache.kyuubi.spark.connector.tpch.TPCHCatalog # (optional) Excluded database list from the

jar deployed with Kyuubi distributions 2. a copy of spark distribution 3. kyuubi-spark-connector-tpch-1.7.3\_2.12.jar, which can be found in the Maven Central In order to make the TPC-H connector package the TPC-H connector package into $SPARK_HOME/jars directly 2. Set spark.jars=kyuubi-spark-connector-tpch-1.7.3_2.12.jar ## Configurations To add TPC-H tables as a catalog, we can set the following configurations defaults.conf: # (required) Register a catalog named `tpch` for the spark engine. spark.sql.catalog.tpch=org.apache.kyuubi.spark.connector.tpch.TPCHCatalog # (optional) Excluded database list from the

jar deployed with Kyuubi distributions 2. a copy of spark distribution 3. kyuubi-spark-connector-tpch-1.9.0-SNAPSHOT_2.12.jar, which can be found in the Maven Central In order to make the TPC-H connector the TPC-H connector package into $SPARK_HOME/jars directly 2. Set spark.jars=kyuubi-spark-connector-tpch-1.9.0-SNAPSHOT_2.12.jar ## Configurations To add TPC-H tables as a catalog, we can set the following defaults.conf: # (required) Register a catalog named `tpch` for the spark engine. spark.sql.catalog.tpch=org.apache.kyuubi.spark.connector.tpch.TPCHCatalog # (optional) Excluded database list from the

jar deployed with Kyuubi distributions 2. a copy of spark distribution 3. kyuubi-spark-connector-tpch-1.7.1_2.12.jar, which can be found in the Maven Central In order to make the TPC-H connector package the TPC-H connector package into $SPARK_HOME/jars directly 2. Set spark.jars=kyuubi-spark-connector-tpch-1.7.1_2.12.jar ## Configurations To add TPC-H tables as a catalog, we can set the following configurations defaults.conf: # (required) Register a catalog named `tpch` for the spark engine. spark.sql.catalog.tpch=org.apache.kyuubi.spark.connector.tpch.TPCHCatalog # (optional) Excluded database list from the

jar deployed with Kyuubi distributions 2. a copy of spark distribution 3. kyuubi-spark-connector-tpch-1.8.0_2.12.jar, which can be found in the Maven Central In order to make the TPC-H connector package the TPC-H connector package into $SPARK_HOME/jars directly 2. Set spark.jars=kyuubi-spark-connector-tpch-1.8.0_2.12.jar ## Configurations To add TPC-H tables as a catalog, we can set the following configurations defaults.conf: # (required) Register a catalog named `tpch` for the spark engine. spark.sql.catalog.tpch=org.apache.kyuubi.spark.connector.tpch.TPCHCatalog # (optional) Excluded database list from the

jar deployed with Kyuubi distributions 2. a copy of spark distribution 3. kyuubi-spark-connector-tpch-1.7.3\_2.12.jar, which can be found in the Maven Central In order to make the TPC-H connector package the TPC-H connector package into $SPARK_HOME/jars directly 2. Set spark.jars=kyuubi-spark-connector-tpch-1.7.3_2.12.jar ## Configurations To add TPC-H tables as a catalog, we can set the following configurations defaults.conf: # (required) Register a catalog named `tpch` for the spark engine. spark.sql.catalog.tpch=org.apache.kyuubi.spark.connector.tpch.TPCHCatalog # (optional) Excluded database list from the