Spark Thrift Server JDBC Issue

[Sonu Prakash]

Hi,

We are trying to connect to Spark Thrift server using JDBC through Spotfire but it's throwing

Error retrieving metadata: Error getting tables: java.lang.IllegalArgumentException: Can not create a Path from an empty string (HRESULT: 80131500) error.

When we check the Spark Thrift server logs the statement it's sending is:Listing tables 'catalog : null, schemaPattern : %, tableTypes : TABLE,EXTERNAL TABLE, tableName : null'

 

When we try the same jars using SQL Developer: The statement is:Listing tables 'catalog : null, schemaPattern : sample_db, tableTypes : TABLE,VIEW, tableName : null'

The SQL Developer sends the right schemaPattern : sample_dbbut Spotfire sendsschemaPattern : %. This is the discrepancy between the 2 JDBC client.

Any help is much appreciated.

 

Thanks,

Sonu

[David Boot-Olazabal]

Hi Sonu,

 

How does your data source template look like And are you able to connect to this datasource via DBVisualizer for example

 

Kind regards,

 

David Boot-Olazabal