Does the latest version of the Arrow Flight ODBC SQL driver support queries with interval data types in Dremio?

1

Hi everyone,

I am currently using the Arrow Flight ODBC SQL driver version 0.09.01.194 with Dremio to connect to my database. However, I’m having trouble executing queries that contain interval data types.

(‘ODBC SQL type 103 is not yet supported. column-index=0 type=103’, ‘HY106’)

This is the error I’m getting while executing a query having Interval Datatype in Dremio.

I’m wondering if the latest version of the Arrow Flight ODBC SQL driver supports interval data types in Dremio. Has anyone tried this before or know if it’s possible?

Thanks in advance for your help!

2

Can you provide examples of these queries? Do they execute in the web UI?

3

Yes they do execute in the Web UI.

Any simple query with interval function is failing.

For example : SELECT INTERVAL ‘5’ HOUR

4

@Maziha

Can you please run the query from both UI and Flight and send us the profiles?

5

image
image1273×538 44.4 KB

The above is the profile of the Flight run.

The below is the profile of the UI run.

image
image1274×550 62 KB

I hope this helps.

6

Turns out, it wasn’t actually a Flight issue but rather a limitation with the Python dataframe. Unfortunately, the dataframe doesn’t support the interval datatype, which caused the whole mess. Casting the interval as varchar fixes the problem.

I want to apologize for any confusion or trouble this may have caused. Thanks a bunch for your help, and I truly appreciate your understanding.

Thank you.

7

@Maziha No worries, glad the issue is resolved

1 Like