Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

"Guess Query" and "Guess schema" fail when connecting to sql server datawarehouse

I am using JDBC to connect to an azure sql server data warehouse.

 

I am able to connect and pull data and log rows fine, but when I attempt to use the "Guess Query" and "Guess schema" functions, I get a "Client driver version is not supported"

 

It appears that the guess query/guess schema functions are trying to connect via jtds and not jdbc, which is not supported by azure sql server data warehouse.

 

Is there a fix for this? 

 

Labels (4)
11 Replies
Anonymous
Not applicable
Author

I did not solve it, I just avoided using the feature

Mayot
Contributor III
Contributor III

I was facing the same issue on Studio 7.0.1.20180411_1414 with jre1.8.0_131. Restarting the Studio doesn't solve the problem.

!ENTRY org.talend.platform.logging 1 0 2020-03-10 09:48:08.082
!MESSAGE 2020-03-10 09:48:08,081 INFO org.talend.designer.core.runprocess.Processor - Command line: C:/Program Files (x86)/Talend-Studio/jre1.8.0_131/bin/java.exe -Xms256M -Xmx1024M -Dfile.encoding=UTF-8 -cp D:/workspace/test/.Java/target/classpath.jar; plateforme.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema --context=DEV %*

!ENTRY org.talend.platform.logging 4 0 2020-03-10 09:48:08.257
!MESSAGE 2020-03-10 09:48:08,256 ERROR org.talend.commons.exception.CommonExceptionHandler -

Delete the workspace then restart the Studio solve it.