In dremio to Qlik Sense, we are using “Arrow Flight SQL Driver” driver which you suggest and it showing this error while loading one table (VDS) from dremio,
QVX_UNEXPECTED_END_OF_DATA: SQL##f- SqlState: $1000, ErrorCode: 100, ErrorMsg: [Apache Arrow] [Dremio Server] (100) bad conversion: LOAD id, operationld, projectid, tailNo, documentTypeld, flightNo, “documentName”, sourcePath, stagingAreaPath, processStartTime, processEndTime, status, createdAt, updatedAt
@mevadadhruv Has this created a job under the UI jobs page? Are you able to download the profile and send it over? What happens if you try to query this table via the Dremio UI or over a regular JDBC connection like DBeaver?
yes through dremio to qlik sense, profile? in dremio ui i’m able to run, but if i load that data in qlik sense via Arrow Flight SQL Driver (ODBC Driver) i’m not able to load that data in qlik sense, and we didn’t discover DBeaver!
@mevadadhruv After the job fails via Arrow Flight SQL Driver, can you see if it has generated a job on the Dremio side and if yes, download the profile
Not following your DBeaver question, are you going to test with DBeaver?
Good Morning @balaji.ramaswamy,
- profile what do you mean by that !
- in dremio i have created vds that’s why i’m able to load in qlik sense, job (loading vds in qlik sense) fails in qlik sense to load data."
- in DBeaver, i’m able to connect dremio in it!
but i don’t know connect here in qlik sense
@mevadadhruv For every job you run from Qlik or DBeaver, the moment the job hits Dremio there will be a job and profle created on the Dremio end. So I want to know if the job fails even before hitting Dremio or it starts running and then fails. That is why I would like to see if there is a profile created
Good afternoon, @balaji.ramaswamy ?
Sorry for the delay in reply, it does look like the client is sending the cancellation request, you can see if there is either a query timeout or fetch size set on the client side. On the screen you pasted, can you please scroll on the left hand side and scroll down and click on download profile? It will download a zip file with a 16 digit UUID as its name, please attach that
@balaji.ramaswamy , hi now i’m having errors in small execution
ed0f38bf-2d3e-4cc0-abdc-0de40fe6525e.zip (17.5 KB)
@mevadadhruv There is a know issue with the Arrow Flight SQL Driver that we are working on. Let me confirm if this is the same issue
@balaji.ramaswamy, okay! But we are Hoping this to be Solved!, or else same solution is there, then let us know please.