Unable to fetch data using impala drivers (2.5) in designer

Hi,
 
I'm trying to use impala latest driver (com.cloudera.impala.jdbc3.Driver (v2.5)) instead of Hive drivers for fetching the data from hadoop. But, I'm getting java.sql.SQLException:[Simba][JDBC](10460) Invalid fetch size:10000. Valid size range:0 to 500.0 error message while executing the query.Please find the more error logs in below. Table contains only one record. I have downloaded Impala drivers from cloudera link:
<a data-ipb='nomediaparse' href='http://www.cloudera.com/content/cloudera/en/downloads/connectors/impala/jdbc/impala-jdbc-v2-5-14.html'>http://www.cloudera.com/content/cloudera/en/downloads/connectors/impala/jdbc/impala-jdbc-v2-5-14.html</a>
<pre class="_prettyXprint">
org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot execute the statement.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:[Simba][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0.
;
java.sql.SQLException: [Simba][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0.

at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)

at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)

at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)

at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:586)

at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:980)

at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:607)

at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1237)

at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)

at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)

at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterator(ExtractionResults.java:157)

at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:69)

at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:372)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:[Simba][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0.
;
java.sql.SQLException: [Simba][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0.

at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:481)

at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doExecuteQuery(OdaQuery.java:480)

at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.executeQuery(OdaQuery.java:444)

at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:575)

... 9 more

Caused by: java.sql.SQLException: [Simba][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0.

at com.cloudera.impala.exceptions.ExceptionConverter.toSQLException(Unknown Source)

at com.cloudera.impala.jdbc.common.SForwardResultSet.setFetchSize(Unknown Source)

at com.cloudera.impala.jdbc.jdbc3.S3PreparedStatement.createResultSet(Unknown Source)

at com.cloudera.impala.jdbc.common.SPreparedStatement.executeQuery(Unknown Source)

at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:477)

... 12 more
</pre>
How to deploy third party driver jars (oda datasource driver jars) in iHub3.1 server.
Kindly help us on this issue.
 
Thanks in Adv.
 
Thanks,
Srinivas

Find more posts tagged with

Comments

JFreeman

Looks like you have already installed the JDBC driver properly or you wouldn't have been able to use it as a data source and received and error.
 
Based on the error, this looks to be an issue with the driver configuration working with your hadoop configuration. The impala driver is configured out of the box with a 10000 row fetch size just like the error is indicating and it appears your hadoop is configured with a maximum fetch size of 500.
 
Take a look at the impala driver documentation for confirmation of this and more details: <a data-ipb='nomediaparse' href='http://www.cloudera.com/content/cloudera/en/documentation/connectors/latest/PDF/Cloudera-JDBC-Driver-for-Impala-Install-Guide.pdf'>http://www.cloudera.com/content/cloudera/en/documentation/connectors/latest/PDF/Cloudera-JDBC-Driver-for-Impala-Install-Guide.pdf</a>
 
There are methods available to set the fetch size, however that will mean you will have to use scripting to set the fetch size and perform the queries manually.
 
I haven't been able to find much documentation on the available URI arguments for the impala jdbc driver but if there is an argument to specify the fetch size, that would be the way to go.