Support Questions

Find answers, ask questions, and share your expertise

impala query, parameter LowerCaseResultSetColumnName can not work

avatar
Explorer

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!

 

 

12 REPLIES 12

avatar
Explorer

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

 

avatar
Explorer

The parameter LowerCaseResultSetColumnName also can not work while using latest ImpalaJDBC41.jar

avatar
New Contributor

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!