Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala Jdbc connection

Highlighted

Impala Jdbc connection

Explorer

Hello, 

 

We are using C3P0 to configure the Jdbc Connection with Impala, and when we try to execute queries, we have this error: 

 

java.sql.SQLException: [Simba][ImpalaJDBCDriver](500151) Error setting/closing session: {0}.
 
This error, probably causes the next error: 
 
SQL state [HY000]; error code [500051]; [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: java.net.SocketException: Tubería rota (Write failed)

 

Our config: 

 

ComboPooledDataSource dataSource = new ComboPooledDataSource();
dataSource.setJdbcUrl(dataSourceImpalaUrl);
dataSource.setDriverClass(dataSourceImpalaDriver);
dataSource.setIdleConnectionTestPeriod(60);
dataSource.setMaxPoolSize(20);
dataSource.setMaxStatements(50);
dataSource.setMinPoolSize(3);
return dataSource;

  

  Our Libraries: 

 

<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.3.RELEASE</version>
</dependency>
<dependency>
<groupId>com.cloudera.impala.jdbc</groupId>
<artifactId>ImpalaJDBC4</artifactId>
<version>2.5.36</version>
</dependency>
<dependency>
<groupId>com.cloudera</groupId>
<artifactId>TCLIServiceClient</artifactId>
<version>2.5.36</version>
</dependency>
<dependency>
<groupId>org.apache.thrift</groupId>
<artifactId>libfb303</artifactId>
<version>0.9.3</version>
</dependency>

 

Could you help us, please?

 

Thanks!