I'm encountering a frustrating and somewhat hard to troubleshoot issue with sending queries through the Cloudera Hive Driver implementation in my Spring Batch app.
I have my select statement as follows:
SELECT * FROM table WHERE `table`.`column`=y;
(the above query is generated using a string concat function, though the stacktrace displays the sql query as it should be expected)
ERROR :
SQL state [HY000]; error code [10360]; [Cloudera][JDBC](10360) Column name not found: column.;
For some reason there is a full stop appended to the end of the column name. Why? Googling has yielded no solution
Odd note; This error only occurs every 5-30 of identical queries that my program fires off to hive, so I am struggling to debug at what point this error can occur. It doesn't correlate with my pool size either.
I have attempted to use the UseNativeQuery option in the hive driver but there seems to be no effect on this occurrence with it enabled or disabled.