[HIVE-24143] Include convention in JDBC converter operator in Calcite plan

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 10/Sep/20 20:59
• Updated: 27/Feb/24 22:24
• Resolved: 12/Sep/20 03:13

Description

Among others, it will be useful to debug the dialect being chosen for query generation. For instance:

 HiveProject(jdbc_type_conversion_table1.ikey=[$0], jdbc_type_conversion_table1.bkey=[$1], jdbc_type_conversion_table1.fkey=[$2], jdbc_type_conversion_table1.dkey=[$3], jdbc_type_conversion_table1.chkey=[$4], jdbc_type_conversion_table1.dekey=[$5], jdbc_type_conversion_table1.dtkey=[$6], jdbc_type_conversion_table1.tkey=[$7])
  HiveProject(ikey=[$0], bkey=[$1], fkey=[$2], dkey=[$3], chkey=[$4], dekey=[$5], dtkey=[$6], tkey=[$7])
----->    HiveJdbcConverter(convention=[JDBC.DERBY])
      JdbcHiveTableScan(table=[[default, jdbc_type_conversion_table1]], table:alias=[jdbc_type_conversion_table1])

Issue Links

• fixes: HIVE-23910 Some jdbc tests are unstable
• links to: GitHub Pull Request #1482