Re: Re: Migrating Hive 3 to Hive 4

2025-05-24 Thread Naresh P R
> > By the way, I have one other question, how to migrate transaction table to > normal orc table(with no acid but stored as orc format) > > Thanks for your help. > Regards, > Zhao Wenbing > > -- > 243776...@qq.com > > > *From:* Denys Kuzmen

Re: Re: Migrating Hive 3 to Hive 4

2025-05-20 Thread 243776...@qq.com
Hive 3 cannot read ACID tables created by Hive 4, as Hive 4 is forward compatible only, not backward compatible.

Re: Migrating Hive 3 to Hive 4

2025-05-20 Thread Denys Kuzmenko
Hive 3 cannot read ACID tables created by Hive 4, as Hive 4 is forward compatible only, not backward compatible.

Re: Migrating Hive 3 to Hive 4

2025-05-20 Thread Sungwoo Park
Hi Ratnesh, For 1, I think you might need to upgrade Metastore database schema. Here are some results from my experiments. In my experiments, Hive 4 merges HIVE-26537 (Deprecate older APIs in the HMS thrift interface), and the results might be different without merging HIVE-26537. Exp #1. Can H

Re: Migrating Hive 3 to Hive 4

2025-05-19 Thread Denys Kuzmenko
Hi Ratnesh, 1. Hive 4.x is expected to support reading ACID tables created with Hive 3.x. Could you please share the exact error message or exception you are encountering? Make sure 'hive' user has access to the underlying data. 2. Are you using MR or query-based compaction? Have you checked th