Re: Re:Re: Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-08 Thread Joice Jacob
Hi Kaka & Doris Community, Thank you for your suggestion. Following your advice, I manually placed the "_orc_acid_version" file into the HDFS directory of Hive. I'm pleased to report that this solution has resolved the issue, and the integration with Doris is now functioning correctly. Your guida

Re: Re:Re: Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-07 Thread Joice Jacob
Yes, I will check. I will update you by EOD today. Thanks for support. Thanks & Regards Joice On Sun, Oct 8, 2023, 7:48 AM kaka chen wrote: > Hi Joice, > > BTW,could you pls try to query it by Doris after putting the > "_orc_acid_version" > file to the hdfs directory of hive manually? Thanks. >

Re: Re:Re: Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-07 Thread kaka chen
Hi Joice, BTW,could you pls try to query it by Doris after putting the "_orc_acid_version" file to the hdfs directory of hive manually? Thanks. Best regards, Kaka kaka chen 于2023年10月8日周日 10:10写道: > Hi Joice, > > Got it, thanks very much. We will setup a cdp env and do some > compatibility work

Re: Re:Re: Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-07 Thread kaka chen
Hi Joice, Got it, thanks very much. We will setup a cdp env and do some compatibility work. Best regards, Kaka Joice Jacob 于2023年10月7日周六 14:58写道: > Hi,Dear Doris Community, > I wanted to provide an update on my recent experience with integrating > Doris with both Apache Hive and CDP Hive, as w

Re: Re:Re: Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-06 Thread Joice Jacob
Hi,Dear Doris Community, I wanted to provide an update on my recent experience with integrating Doris with both Apache Hive and CDP Hive, as well as seek insights into a particular observation. In my integration with Apache Hive, I noticed that transaction tables retain the "_orc_acid_version" fil

Re: Re:Re: Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-06 Thread kaka chen
Hi Joice: Thanks your reporting. It seems the root cause of this issue is missing "_orc_acid_version" file. >From Hive version >= 3.0, delta/base files will always have file '_orc_acid_version' with value >= '2'. Maybe the hive3 of HDP has similar issue? https://issues.apache.org/jira/browse/HIVE-

Re: Re:Re: Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-06 Thread Joice Jacob
Hi, I've checked the Hive data directory, and I couldn't find the "_orc_acid_version" file. I have attached screenshots for your reference. Are there any recommended workarounds or alternative approaches that I can consider to resolve this issue? I'm open to exploring different solutions to ensure

Re:Re: Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-05 Thread Mingyu Chen
Oh, I see, let me check it again. -- Best Regards Mingyu Chen Email: morning...@apache.org At 2023-10-05 21:49:28, "Joice Jacob" wrote: >Hi, >I wanted to share some important information regarding the CDP Hive version >that I am currently using, which is Hive 3.1.3000.7.1.7.0-551. > >In