Hi !   Did you find some explanations regarding you issue ?   I faced a similar problem using HWS executeQuery that didn't retrieve expected rows compared with beeline. My table is defined as ORC with transactional set to True. NB: executeQuery worked "forcing" the whol repo scan by using of a specific "WHERE clause" on a given field of the table   Regards ... View more

Hello @Bender , Thank you for your answer that is very clear. Even HDP last version, which is 3.1.5, uses Hive 3.1.0 (not 3.1.2). And Hive 3.1.2 should be a minor release to fix bugs from 3.1.0 version. If I really want to "force" upgrade from 3.1.0 to 3.1.2, do you have any advice to proceed ? or any upgrade procedure ? Thank you ... View more