@balaji.ramaswamy@ben please can you help explain?
apprently after upgrade dremio generate "AH_CUENTA"."OFICIAL_CUENTA" as column name but this is incorrect de column name is only "OFICIAL_CUENTA" because "AH_CUENTA" is the table name and "REPORTES" is the schema name
Is the source DB2? Unfortunately, we no longer support that connector, so unless a comparable problem presents itself in another officially supported source, I don’t think we can “fix” the pushdown.
I developed a custom connector that is very madurate we want contributing to dremio with it, all work well only when query to other scheme present this issue,
in postgres also generated this issue, but postgres doesnt fail because internal driver avoid this wrong names
the questions is:
using custom connector can i override this wrong columns name generated?
what changed from 4.0.5 to latest dremio that cause this wrong column names?
Very thanks by your response
Thanks @ben, using this explain by @jduongPush down not work expected I fixed the error extending ArpDialect and @Override hasImplicitTableAlias to false but can you explained me whats is this method? or any documentation about ArpDialect?