On our helm chart based setup (image sha256:95bb1841335c41ae32b1e9fb9a4c779ec047903e94cc66e0a6b7ed3657feddfe) if I try to query information_schema.columns I get
IllegalArgumentException: No enum constant com.dremio.common.types.TypeProtos.MinorType.TIMEMICRO.Show less
I reproduced the problem and checked the generated jobs: both the query from DataGrip and the one from the Web UI are actually listed as “failed”, with the same error.
However, DataGrip rather strangely manages to show valid-looking output and doesn’t emit any error.
For what concerns sending you the profile: are you suggesting to upload the zip files that one can download from the UI?
In that case, is it OK if I avoid sending the header.json file that appears in them?
There seems to be a lot of private information in it.
I think this problem was generated by a mysql source, which we removed yesterday for other reasons [*]: we don’t currently have this problem in production anymore.
We’re planning to simplify the deployment of dremio instances in our qa environments: when we have them we’ll try and find out what mysql types were generating this issue on the dremio side and send you an update.
Thank you for your help!
[*] We’re in the process of moving away from a PoC federation setup to more consistently use s3 as our main data source.