Member since
07-18-2019
7
Posts
0
Kudos Received
0
Solutions
08-25-2019
10:18 PM
The parameter LowerCaseResultSetColumnName also can not work while using latest ImpalaJDBC41.jar
... View more
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
... View more
07-23-2019
07:29 PM
Sorry, the version of impala jdbc is 2.5.41.1061 I think it is not so early
... View more
07-19-2019
02:30 AM
I am not sure. May be impala-jdbc:1.0.0 How can I get new version impala jdbc driver? I can not found in maven repo
... View more
07-18-2019
10:00 PM
1. I use impala-jdbc 2. I set LowerCaseResultSetColumnName for all query, and the result of sql2 is correct. the url setting: spring.datasource.url=jdbc:impala://localhost:21050/cdp_prod;SocketTimeout=5;LowerCaseResultSetColumnName=0 execute sql1: String sql = "select nick_name as nickName from customer where tenant_id = 29 and id in (:ids)";
MapSqlParameterSource sqlParameterSource = new MapSqlParameterSource();
List<Long> ids = new ArrayList<>();
ids.add(484599978900144160l);
ids.add(484599978900144159l);
sqlParameterSource.addValue("ids", ids);
List<Map<String, Object>> customers = namedJdbcTemplate.queryForList(sql, sqlParameterSource); execute sql2: String sql = "select nick_name as nickName from customer where tenant_id = 29 and id in (:ids) limit 10";
MapSqlParameterSource sqlParameterSource = new MapSqlParameterSource();
List<Long> ids = new ArrayList<>();
ids.add(484599978900144160l);
ids.add(484599978900144159l);
sqlParameterSource.addValue("ids", ids);
List<Map<String, Object>> customers = namedJdbcTemplate.queryForList(sql, sqlParameterSource);
... View more
07-18-2019
06:56 PM
column label in result set should not be lowercase while set LowerCaseResultSetColumnName to 0
... View more
07-18-2019
03: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!
... View more
Labels:
- Labels:
-
Apache Impala
-
Apache Kudu