Created on 07-18-2019 03:31 AM - edited 09-16-2022 07:31 AM
sql1
select nick_name as nickName from customer where tenant_id = 29 and id in (:ids)
the column label in resultSetColumnMeta is nickName
sql2
select nick_name as nickName from customer where tenant_id = 29 and id in (:ids) limit 10
the column label in resultSetColumnMeta is nickname
I use NamedParameterJdbcTemplate to execute query and set LowerCaseResultSetColumnName 0!
Created 08-19-2019 12:58 AM
I am sorry to reply so late. I have update my impala-connector to latest 2.6.12, but the problem still exists.
spring.datasource.url=jdbc:impala://localhost:9012/test;SocketTimeout=300;LowerCaseResultSetColumnName=0
spring.datasource.driverClassName=com.cloudera.impala.jdbc41.Driver
Created 08-25-2019 10:18 PM
The parameter LowerCaseResultSetColumnName also can not work while using latest ImpalaJDBC41.jar
Created 09-04-2019 03:44 AM
Hi
Can you please try with alias names, actually this is not working without alias in Query
e.g.,
select col_a AS COL_A from SAMPLE_TABLE;
this works!