While evaluating the dremio tool for our business needs, below are some of the issue I have encountered. Please let me know if this issue is related to dremio or the particular custom connector “SAP ASE connector” that we are using to query SAP IQ database.
- We have huge tables with around 1500 columns. Whenever I query such tables Dremio returns an error. While using reflection also it said the hard limit for columns is 800. Is there a hard limit on the number of columns (800) for a table above which dremio cannot query.
- Issue with Datetime columns. Datetime is a data type on SAPIQ. However whenever i query the table I need to cast datetime to varchar without which I get a Nullpointer exception. Is this again a custom connector limitation.