KnowageLabs/Knowage-Server

Hive Data Source

Closed this issue · 4 comments

CamilloGioeELMI commented

Hive2 datasource doesn't work using Knowage8 on Windows 10 (I also checked Knowage8 using docker container)

Steps to reproduce the behavior:

  1. Copy these files in [install_folder]\Knowage-Server-CE\lib folder
    hadoop-common-2.7.3.2.6.4.0-91.jar
    hive-common-1.2.1000.2.6.4.0-91.jar
    hive-exec-1.21.2.2.6.4.0-91.jar
    hive-jdbc-1.21.2.2.6.4.0-91.jar
    hive-metastore-1.21.2.2.6.4.0-91.jar
    hive-service-1.2.1000.2.6.4.0-91.jar
    guava-annotations-r03.jar
    guava-base-r03.jar
    guava-primitives-r03.jar

  2. Edit setenv.bat putting these line at the end
    set "CLASSPATH=[install_folder]\Knowage-Server-CE\lib"

  3. Create datasource using Apache Hive2 dialect. Test doesn't display informations if test connection is successfull. Then, save the datasource
    image

  4. Creata a dataset using Query and the data source created previously

  5. Click on Preview

  6. a "Method not supported" issue is displayed

This behavior is due to this class
https://commons.apache.org/proper/commons-dbcp/jacoco/org.apache.commons.dbcp2/DelegatingConnection.java.html
and in particular to isValid method
image

At the meantime, I applied a workaround editing just this class as follows
image

Then, I had to copy the commons-dbcp2-2.9.0.jar file too

matmassa commented

Hi,
thank you for your suggestion. We are analyzing the code and we will work for an update for next releases.
Regards
Matteo

github-actions commented

This issue is stale because it is related to an old version or it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

github-actions commented

This issue is stale because it is related to an old version or it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

github-actions commented

This issue was closed because it has been stalled for 5 days with no activity.