Column of type Int(10) which doesn’t fit in a java.lang.Integer

Hello,

I having some issues trying to load a physical dataset for an external connection.

when I try to do a SELECT * it returns me the following error
image

The data type from the source is and Int(10) and the database is a MYSQL

any ideas of how to fix this?

Regards

I think you need to use BIGINT. Here is the mapping of data types in your case:
https://docs.dremio.com/sql-reference/data-types-mysql/

Hi @Mahendrakar ,

Thank you so much for your reply, but I don’t see why it correct. If I am not wrong the only difference between INT and BIGINT it is the size (2^32 and 2^64).

But the number above is lower than 2^32 and it has 10 digit. Moreover, it works in mysql server, and the mapping link you shared with me seems to map **INT" with integer, so the mapping seems accurate

@capihacendado What happens if you run the same query as an External query

https://docs.dremio.com/data-sources/external-queries/

Hi @balaji.ramaswamy

Thank you so much for your answer

Sadly I got the same result

@capihacendado Can you please send me the profile from the external query job that failed?

Thank you for your answer @balaji.ramaswamy.
You can find attached the profile. I attached the profile here, but let me know if you want me to send it by another channel.

Let me know if you need anything else
b65b3091-7c65-4bc3-82f8-cda1e031ff4a.zip (11,4 KB)

@capihacendado What happens if you run SELECT * from matomo.piwik_log_action directly on MySQL?

Thank you for your answer @balaji.ramaswamy

Nothing special happens, it shows the data as expected.

I’ll share with you some screenshots with the max and min value, and a top 5 of those records

image


I share with you the definition as well
image

Let me know if you need anything else