Dear Doris Community, I am reaching out to the community to seek assistance with an integration issue I've encountered while trying to use Hive on a CDP distribution with Doris 2.0.1.1.
Here are the details of my setup: Doris Version: 2.0.1.1 Hive Version: 3.1.3 Cluster Security: Kerberized I have successfully created a Hive catalog in Doris and have been able to set up the integration between Hive and Doris. However, when I attempt to query a Hive table using Doris, I encounter the following error: ERROR 1105 (HY000): errCode = 2, detailMessage = get file split failed for table: baby1, err: java.lang.Exception: Hive 2.x versioned full-acid tables need to run major compaction. I have already performed a major compaction as recommended, but I am still encountering the same error. I would greatly appreciate any insights, guidance, or solutions that the Doris community can offer to help me resolve this issue. If anyone has encountered a similar problem or has expertise in integrating Hive with Doris, your assistance would be invaluable. Thank you in advance for your time and support. I look forward to hearing from the community and working together to find a solution to this challenge. [image: baby_table.JPG] [image: doris_hive_catlog_result.JPG] [image: doris_fe_log.JPG] [image: hive_metastore_error.JPG] Thanks Joice