Feedback
Did this article resolve your question/issue?

   

Article

OData Model Creation fails for HDP JDBC drivers when connecting to Impala

Information

 
TitleOData Model Creation fails for HDP JDBC drivers when connecting to Impala
URL NameOData-Model-Creation-fails-for-HDP-JDBC-drivers-when-connecting-to-Impala
Article Number000113077
EnvironmentProduct: DataDirect Hybrid Data Pipeline
Version: 4.5
OS: Linux
Database: Impala
Application: All supported applications
Question/Problem Description
When configuring an OData connection for a single table in Impala instance that has multiple tables, Hybrid Data Pipeline issues a “describe” call on every table in the database. This causes the describe call to hang on an incompatible table, and eventually it fails with the error below.
Steps to Reproduce1) Create an incompatible table that works in Hive, but fails in Impala.

CREATE TABLE test_deflate_hang
(
id INT,
value STRING
)
STORED AS TEXTFILE;

2) Run set and insert values. After these are run .deflate file in the hdfs hive table directory will be seen.

set hive.exec.compress.output=true;
INSERT OVERWRITE TABLE test_deflate_hang VALUES (1, "v1"), (2, "v2");

3) Now using the Impala JDBC connection in HDP run a describe command which will hang and eventually fails with the error below.
Clarifying Information
Error Messagesync operation failed
Defect NumberDefect HDP-3878
Enhancement Number
Cause
Resolution
Fixed in hot fix 4.5.0.61 
Refer to 000088760 "Hybrid Data Pipeline hot fix download and install instructions" for instructions on how to download and install the hot fix.
Workaround
Notes
Last Modified Date6/11/2019 7:56 PM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.