Thanks Asish! In our product, we've already bumped up our Hive version to 4.1 and connecting from a Hive 4.1 client to Hive 3.x doesn't work in many instances. We've made some changes to Hive 4.1 to allow slightly more backwards compatibility but there are some instances where serialized objects are used and can't be deserialized because of version mismatches. Thanks, Moe  ... View more

@zhouweibo  As mentioned previously, please provide the DDL, sample data, and corresponding SQL to reproduce the problem. With this information, we can reproduce the problem locally and  offer an exact working solution.  ... View more

@David_Ghazaleh, Did the response assist in resolving your query? If it did, please mark the relevant reply as the solution, as it will help others locate the answer more easily in the future. ... View more

@lbourgeois, Did the response assist in resolving your query? If it did, please mark the relevant reply as the solution, as it will help others locate the answer more easily in the future.  ... View more

Is the source table a JdbcStorageHandler table? Please provide the DDL of the source table, the query used, and any sample data if possible. This information will help us understand the problem better. Also, validate the set -v command, especially configurations like hive.tez.container.size. ... View more

SELECT * FROM your_table WHERE data_dt = '__HIVE_DEFAULT_PARTITION__'; ok thank's for your reply ,i understand this example But my question is, in my Third SQL statement, using length() function in the select statement is effective and the result is 26, while in the first and second  SQL , why can't this record be filtered by length in the where statement when I use the length function on the partition key? Thank You ... View more

@Jackallboy Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. If you are still experiencing the issue, can you provide the information requested? Thanks. ... View more

Perfect, thanks four your help and quick responses. ... View more