Thank you for your time. I got this fix by adding Param UseNativeQuery=1, in my jdbc connection string. By default it take value 2. As per the driver documentation

0: The connector transforms the queries emitted by applications and converts them into an equivalent form in HiveQL.
1: The connector does not transform the queries emitted by applications, so the native query is used.
2: The connector automatically sets this property to either 0 or 1, depending on the server capabilities.