This is an automated email from the ASF dual-hosted git repository. github-bot pushed a change to branch dependabot/maven/org.apache.avro-avro-1.11.4 in repository https://gitbox.apache.org/repos/asf/hive.git
omit 205f34e8c45 Bump org.apache.avro:avro from 1.11.3 to 1.11.4 add f583467f608 HIVE-21614: Derby/Oracle does not support CLOB comparisons when listTableNamesByFilter using the parameter (#3720) (Zhihua Deng, reviewed by Denys Kuzmenko) add 34a9c6305d2 HIVE-28556: Remove unnecessary Statsistics#clone invocation in StatsRulesProcFactory#applyRuntimeStats (Seonggon Namgung, reviewed by Denys Kuzmenko, Shohei Okumiya) add 436639a86f6 HIVE-28543: Iceberg: Previous snapshotId is stored in backend database (Raghav Aggarwal, reviewed by Ayush Saxena, Butao Zhang, Denys Kuzmenko) add 90d48dfa1a0 HIVE-28524: Iceberg: Major QB Compaction add sort order support (#5456)(Dmitriy Fingerman, reviewed by Simhadri Govindappa) add 4d964df5918 HIVE-28569: ReExecuteLostAMQueryPlugin doesn't kick in if the message contains line break and diagnostics (#5499) (Laszlo Bodor reviewed by Denys Kuzmenko) add b6c191db42c HIVE-28259: Common table expression detection and rewrites using CBO (Stamatis Zampetakis reviewed by Alessandro Solimando, Aman Sinha) new 3b6eb40e58f Bump org.apache.avro:avro from 1.11.3 to 1.11.4 This update added new revisions after undoing existing revisions. That is to say, some revisions that were in the old version of the branch are not in the new version. This situation occurs when a user --force pushes a change and generates a repository containing something like this: * -- * -- B -- O -- O -- O (205f34e8c45) \ N -- N -- N refs/heads/dependabot/maven/org.apache.avro-avro-1.11.4 (3b6eb40e58f) You should already have received notification emails for all of the O revisions, and so the following emails describe only the N revisions from the common base, B. Any revisions marked "omit" are not gone; other references still refer to them. Any revisions marked "discard" are gone forever. The 1 revisions listed above as "new" are entirely new to this repository and will be described in separate emails. The revisions listed as "add" were already present in the repository and have only been added to this reference. Summary of changes: .../java/org/apache/hadoop/hive/conf/HiveConf.java | 4 + .../iceberg/mr/hive/HiveIcebergMetaHook.java | 5 - .../compaction/IcebergMajorQueryCompactor.java | 17 +- ...major_compaction_partition_evolution_ordered.q} | 62 +- .../iceberg_major_compaction_unpartitioned.q | 2 + ...eberg_major_compaction_unpartitioned_ordered.q} | 34 +- ...r_compaction_partition_evolution_ordered.q.out} | 289 +++---- .../iceberg_major_compaction_unpartitioned.q.out | 20 + ...g_major_compaction_unpartitioned_ordered.q.out} | 202 ++--- .../test/resources/testconfiguration.properties | 5 +- .../hadoop/hive/ql/parse/AlterClauseParser.g | 4 +- .../hive/ql/parse/TestParseOptimizeTable.java | 67 +- .../ql/optimizer/calcite/CalciteCteException.java | 23 + .../CommonTableExpressionIdentitySuggester.java | 54 ++ .../CommonTableExpressionPrintSuggester.java | 44 + .../calcite/CommonTableExpressionRegistry.java | 54 ++ .../calcite/CommonTableExpressionSuggester.java | 48 ++ .../CommonTableExpressionSuggesterFactory.java | 48 ++ .../hive/ql/optimizer/calcite/HiveCalciteUtil.java | 17 + .../calcite/HiveDefaultRelMetadataProvider.java | 6 + .../ql/optimizer/calcite/HiveRelFactories.java | 6 +- .../hive/ql/optimizer/calcite/HiveSqlTypeUtil.java | 49 ++ .../hive/ql/optimizer/calcite/RelOptHiveTable.java | 4 + .../calcite/reloperators/HiveTableSpool.java | 41 + .../rules/CommonRelSubExprRegisterRule.java | 84 ++ .../ql/optimizer/calcite/rules/CteRuleConfig.java | 41 + .../calcite/rules/HivePartitionPruneRule.java | 3 + .../calcite/rules/RemoveInfrequentCteRule.java | 54 ++ .../calcite/rules/TableScanToSpoolRule.java | 67 ++ .../rules/views/HiveMaterializedViewUtils.java | 39 + .../optimizer/calcite/stats/AggregatedColumns.java | 50 ++ .../calcite/stats/HiveRelMdAggregatedColumns.java | 81 ++ .../calcite/stats/HiveRelMdColumnUniqueness.java | 5 + .../calcite/stats/HiveRelMdDistinctRowCount.java | 6 + .../calcite/stats/HiveRelMdTableReferences.java | 45 ++ .../calcite/stats/HiveRelMetadataQuery.java | 52 ++ .../ql/optimizer/calcite/stats/MetadataMethod.java | 36 + .../optimizer/calcite/translator/ASTBuilder.java | 12 + .../optimizer/calcite/translator/ASTConverter.java | 30 +- .../calcite/translator/PlanModifierForASTConv.java | 8 + .../stats/annotation/StatsRulesProcFactory.java | 3 +- .../hadoop/hive/ql/parse/CalcitePlanner.java | 164 +++- .../hadoop/hive/ql/parse/SemanticAnalyzer.java | 7 +- .../hive/ql/reexec/ReExecuteLostAMQueryPlugin.java | 2 +- .../hive/ql/txn/compactor/CompactorUtil.java | 1 + .../hive/metastore/TestTablesListByFilter.java | 171 ++++ .../ql/reexec/TestReExecuteLostAMQueryPlugin.java | 10 + .../queries/clientpositive/cte_cbo_plan_json.q | 16 + .../queries/clientpositive/cte_cbo_rewrite_0.q | 161 ++++ ql/src/test/queries/clientpositive/cte_mat_12.q | 45 ++ .../test/queries/clientpositive/perf/cbo_query1.q | 1 + .../test/queries/clientpositive/perf/cbo_query10.q | 1 + .../test/queries/clientpositive/perf/cbo_query11.q | 1 + .../test/queries/clientpositive/perf/cbo_query12.q | 1 + .../test/queries/clientpositive/perf/cbo_query13.q | 1 + .../test/queries/clientpositive/perf/cbo_query14.q | 1 + .../test/queries/clientpositive/perf/cbo_query15.q | 1 + .../test/queries/clientpositive/perf/cbo_query16.q | 1 + .../test/queries/clientpositive/perf/cbo_query17.q | 1 + .../test/queries/clientpositive/perf/cbo_query18.q | 1 + .../test/queries/clientpositive/perf/cbo_query19.q | 1 + .../test/queries/clientpositive/perf/cbo_query2.q | 1 + .../test/queries/clientpositive/perf/cbo_query20.q | 1 + .../test/queries/clientpositive/perf/cbo_query21.q | 1 + .../test/queries/clientpositive/perf/cbo_query22.q | 1 + .../test/queries/clientpositive/perf/cbo_query23.q | 1 + .../test/queries/clientpositive/perf/cbo_query24.q | 1 + .../test/queries/clientpositive/perf/cbo_query25.q | 1 + .../test/queries/clientpositive/perf/cbo_query26.q | 1 + .../test/queries/clientpositive/perf/cbo_query27.q | 1 + .../test/queries/clientpositive/perf/cbo_query28.q | 1 + .../test/queries/clientpositive/perf/cbo_query29.q | 1 + .../test/queries/clientpositive/perf/cbo_query3.q | 1 + .../test/queries/clientpositive/perf/cbo_query30.q | 1 + .../test/queries/clientpositive/perf/cbo_query31.q | 1 + .../test/queries/clientpositive/perf/cbo_query32.q | 1 + .../test/queries/clientpositive/perf/cbo_query33.q | 1 + .../test/queries/clientpositive/perf/cbo_query34.q | 1 + .../test/queries/clientpositive/perf/cbo_query35.q | 1 + .../test/queries/clientpositive/perf/cbo_query36.q | 1 + .../test/queries/clientpositive/perf/cbo_query37.q | 1 + .../test/queries/clientpositive/perf/cbo_query38.q | 1 + .../test/queries/clientpositive/perf/cbo_query39.q | 1 + .../test/queries/clientpositive/perf/cbo_query4.q | 1 + .../test/queries/clientpositive/perf/cbo_query40.q | 1 + .../test/queries/clientpositive/perf/cbo_query41.q | 1 + .../test/queries/clientpositive/perf/cbo_query42.q | 1 + .../test/queries/clientpositive/perf/cbo_query43.q | 1 + .../test/queries/clientpositive/perf/cbo_query44.q | 1 + .../test/queries/clientpositive/perf/cbo_query45.q | 1 + .../test/queries/clientpositive/perf/cbo_query46.q | 1 + .../test/queries/clientpositive/perf/cbo_query47.q | 1 + .../test/queries/clientpositive/perf/cbo_query48.q | 1 + .../test/queries/clientpositive/perf/cbo_query49.q | 1 + .../test/queries/clientpositive/perf/cbo_query5.q | 1 + .../test/queries/clientpositive/perf/cbo_query50.q | 1 + .../test/queries/clientpositive/perf/cbo_query51.q | 1 + .../test/queries/clientpositive/perf/cbo_query52.q | 1 + .../test/queries/clientpositive/perf/cbo_query53.q | 1 + .../test/queries/clientpositive/perf/cbo_query54.q | 1 + .../test/queries/clientpositive/perf/cbo_query55.q | 1 + .../test/queries/clientpositive/perf/cbo_query56.q | 1 + .../test/queries/clientpositive/perf/cbo_query57.q | 1 + .../test/queries/clientpositive/perf/cbo_query58.q | 1 + .../test/queries/clientpositive/perf/cbo_query59.q | 1 + .../test/queries/clientpositive/perf/cbo_query6.q | 1 + .../test/queries/clientpositive/perf/cbo_query60.q | 1 + .../test/queries/clientpositive/perf/cbo_query61.q | 1 + .../test/queries/clientpositive/perf/cbo_query62.q | 1 + .../test/queries/clientpositive/perf/cbo_query63.q | 1 + .../test/queries/clientpositive/perf/cbo_query64.q | 1 + .../test/queries/clientpositive/perf/cbo_query65.q | 1 + .../test/queries/clientpositive/perf/cbo_query66.q | 1 + .../test/queries/clientpositive/perf/cbo_query67.q | 1 + .../test/queries/clientpositive/perf/cbo_query68.q | 1 + .../test/queries/clientpositive/perf/cbo_query69.q | 1 + .../test/queries/clientpositive/perf/cbo_query7.q | 1 + .../test/queries/clientpositive/perf/cbo_query70.q | 1 + .../test/queries/clientpositive/perf/cbo_query71.q | 1 + .../test/queries/clientpositive/perf/cbo_query72.q | 1 + .../test/queries/clientpositive/perf/cbo_query73.q | 1 + .../test/queries/clientpositive/perf/cbo_query74.q | 1 + .../test/queries/clientpositive/perf/cbo_query75.q | 1 + .../test/queries/clientpositive/perf/cbo_query76.q | 1 + .../test/queries/clientpositive/perf/cbo_query77.q | 1 + .../test/queries/clientpositive/perf/cbo_query78.q | 1 + .../test/queries/clientpositive/perf/cbo_query79.q | 1 + .../test/queries/clientpositive/perf/cbo_query8.q | 1 + .../test/queries/clientpositive/perf/cbo_query80.q | 1 + .../test/queries/clientpositive/perf/cbo_query81.q | 1 + .../test/queries/clientpositive/perf/cbo_query82.q | 1 + .../test/queries/clientpositive/perf/cbo_query83.q | 1 + .../test/queries/clientpositive/perf/cbo_query84.q | 1 + .../test/queries/clientpositive/perf/cbo_query85.q | 1 + .../test/queries/clientpositive/perf/cbo_query86.q | 1 + .../test/queries/clientpositive/perf/cbo_query87.q | 1 + .../test/queries/clientpositive/perf/cbo_query88.q | 1 + .../test/queries/clientpositive/perf/cbo_query89.q | 1 + .../test/queries/clientpositive/perf/cbo_query9.q | 1 + .../test/queries/clientpositive/perf/cbo_query90.q | 1 + .../test/queries/clientpositive/perf/cbo_query91.q | 1 + .../test/queries/clientpositive/perf/cbo_query92.q | 1 + .../test/queries/clientpositive/perf/cbo_query93.q | 1 + .../test/queries/clientpositive/perf/cbo_query94.q | 1 + .../test/queries/clientpositive/perf/cbo_query95.q | 1 + .../test/queries/clientpositive/perf/cbo_query96.q | 1 + .../test/queries/clientpositive/perf/cbo_query97.q | 1 + .../test/queries/clientpositive/perf/cbo_query98.q | 1 + .../test/queries/clientpositive/perf/cbo_query99.q | 1 + .../clientpositive/llap/cte_cbo_plan_json.q.out | 37 + .../clientpositive/llap/cte_cbo_rewrite_0.q.out | 883 +++++++++++++++++++++ .../results/clientpositive/llap/cte_mat_12.q.out | 182 +++++ .../llap/partition_explain_ddl.q.out | 72 +- .../perf/tpcds30tb/tez/cbo_query1.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query10.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query11.q.out | 24 + .../perf/tpcds30tb/tez/cbo_query2.q.out | 15 + .../perf/tpcds30tb/tez/cbo_query23.q.out | 41 + .../perf/tpcds30tb/tez/cbo_query24.q.out | 20 + .../perf/tpcds30tb/tez/cbo_query30.q.out | 10 + .../perf/tpcds30tb/tez/cbo_query31.q.out | 30 + .../perf/tpcds30tb/tez/cbo_query32.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query33.q.out | 20 + .../perf/tpcds30tb/tez/cbo_query35.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query38.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query4.q.out | 30 + .../perf/tpcds30tb/tez/cbo_query44.q.out | 14 + .../perf/tpcds30tb/tez/cbo_query47.q.out | 38 + .../perf/tpcds30tb/tez/cbo_query49.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query5.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query51.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query54.q.out | 8 + .../perf/tpcds30tb/tez/cbo_query56.q.out | 15 + .../perf/tpcds30tb/tez/cbo_query57.q.out | 38 + .../perf/tpcds30tb/tez/cbo_query58.q.out | 20 + .../perf/tpcds30tb/tez/cbo_query59.q.out | 10 + .../perf/tpcds30tb/tez/cbo_query60.q.out | 15 + .../perf/tpcds30tb/tez/cbo_query61.q.out | 24 + .../perf/tpcds30tb/tez/cbo_query64.q.out | 39 + .../perf/tpcds30tb/tez/cbo_query65.q.out | 10 + .../perf/tpcds30tb/tez/cbo_query66.q.out | 15 + .../perf/tpcds30tb/tez/cbo_query69.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query71.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query74.q.out | 20 + .../perf/tpcds30tb/tez/cbo_query75.q.out | 30 + .../perf/tpcds30tb/tez/cbo_query77.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query78.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query80.q.out | 15 + .../perf/tpcds30tb/tez/cbo_query81.q.out | 10 + .../perf/tpcds30tb/tez/cbo_query83.q.out | 15 + .../perf/tpcds30tb/tez/cbo_query87.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query88.q.out | 15 + .../perf/tpcds30tb/tez/cbo_query90.q.out | 14 + .../perf/tpcds30tb/tez/cbo_query92.q.out | 5 + .../perf/tpcds30tb/tez/cbo_query97.q.out | 5 + .../hadoop/hive/metastore/DatabaseProduct.java | 5 + .../hive/metastore/parser/ExpressionTree.java | 6 + 197 files changed, 3765 insertions(+), 447 deletions(-) copy iceberg/iceberg-handler/src/test/queries/positive/{iceberg_major_compaction_unpartitioned.q => iceberg_major_compaction_partition_evolution_ordered.q} (54%) rename iceberg/iceberg-handler/src/test/queries/positive/{iceberg_optimize_table_unpartitioned.q => iceberg_major_compaction_unpartitioned_ordered.q} (57%) copy iceberg/iceberg-handler/src/test/results/positive/llap/{iceberg_major_compaction_unpartitioned.q.out => iceberg_major_compaction_partition_evolution_ordered.q.out} (53%) rename iceberg/iceberg-handler/src/test/results/positive/llap/{iceberg_optimize_table_unpartitioned.q.out => iceberg_major_compaction_unpartitioned_ordered.q.out} (52%) create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/CalciteCteException.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/CommonTableExpressionIdentitySuggester.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/CommonTableExpressionPrintSuggester.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/CommonTableExpressionRegistry.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/CommonTableExpressionSuggester.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/CommonTableExpressionSuggesterFactory.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveSqlTypeUtil.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveTableSpool.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/CommonRelSubExprRegisterRule.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/CteRuleConfig.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/RemoveInfrequentCteRule.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/TableScanToSpoolRule.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/AggregatedColumns.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/HiveRelMdAggregatedColumns.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/HiveRelMdTableReferences.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/HiveRelMetadataQuery.java create mode 100644 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/MetadataMethod.java create mode 100644 ql/src/test/org/apache/hadoop/hive/metastore/TestTablesListByFilter.java create mode 100644 ql/src/test/queries/clientpositive/cte_cbo_plan_json.q create mode 100644 ql/src/test/queries/clientpositive/cte_cbo_rewrite_0.q create mode 100644 ql/src/test/queries/clientpositive/cte_mat_12.q create mode 100644 ql/src/test/results/clientpositive/llap/cte_cbo_plan_json.q.out create mode 100644 ql/src/test/results/clientpositive/llap/cte_cbo_rewrite_0.q.out create mode 100644 ql/src/test/results/clientpositive/llap/cte_mat_12.q.out