zhang-yue1 opened a new issue, #13856:
URL: https://github.com/apache/hudi/issues/13856

   When querying a Hudi table from Hive with hoodie.metadata.enable=true, the 
query fails with the following error:
   
   Error retrieving next row
   com.intellij.execution.rmi.RemoteObject$ForeignException
   
   
   However, if I add a filter on _hoodie_commit_time, the query works fine:
   
   SELECT * FROM hudi_table WHERE `_hoodie_commit_time` > '00000000000000000';
   
   This means that with metadata enabled, Hive full table scan fails, but 
filtered queries succeed.
   
   If I disable metadata (set hoodie.metadata.enable=false;), Hive can read the 
table successfully.
   
   Expected behavior
   
   Hive should be able to run SELECT * on a Hudi table with metadata enabled, 
not just when filtering by _hoodie_commit_time.
   
   Environment (please complete the following information):
   
   Hudi version: 0.12.3 (self-compiled, Hadoop 3.0 + HBase 2.4.9)
   
   Additional context
   
   Spark and Flink queries work fine.
   
   The issue only happens with Hive full table scan (SELECT *).


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to