Latest Activity

code

java.sql.SQLException: unexpected exception; nested exception is: com.denodo.internal.o.a.r.netty.KeepAliveException: Channel time out exception.

Hi, I'm trying to run a query on Denodo from AWS Glue. I connect to Denodo using denodo-vdp-jdbcdriver.jar. I'm using Spark 2.4.3 on Glue and my query looks something like this. Query: sql = select <columns> from <interface> where col1 = '...

Spark-sql connection

code

Getting py4j.protocol.Py4JJavaError: An error occurred while calling o65.jdbc. : java.sql.SQLException: Unsupported type TIMESTAMP_WITH_TIMEZONE

I am making JDBC connection to Denodo database using pyspark. The table that i am connecting to contains "TIMESTAMP_WITH_TIMEZONE" datatype for 2 columns. Since spark provides builtin jdbc connection to a handful of dbs only of which denodo is not a pa...

JDBC Spark Spark-sql connection

code

Spark fires multiple queries for a single denodo query

Hi, I'm connecting to denodo from AWS Glue (with Spark 2.4.3). When I issue a query to denodo from Glue, it fires multiple queries to denodo. eg: Denodo Query: select * from (select sum(col1) as col1, col2, col3 from interface view where filters grou...

Spark-sql connection

code

Denodo + Spark SQL

I had created spark conenction in denodo. Datbase Adapter: Spark SQL 1.6 Driver Class : org.apache.hive.jdbc.HiveDriver Database URI : jdbc:hive2://xyx.abc.com:10000 But while running queries;still the job is running on mapreduce. In yarn for the job...

Spark-sql connection

code

Connector to Spark SQL

Hi Team, We are looking for Connector for Spark SQL. when i go through the same question, i see one answer that we need to create the baseview from query instead import baseview. Also config change in hive datasource. These answers are when the versio...

Spark-sql connection

code

How can I connect from Spark sql?

Hi, I need to connect to Denodo platform vdp from spark sql? I have denodo 6. Where can I get the connector? Please advice. Thanks.

Spark-sql connection