Mappings for External Sources-oracle Field type mismatch

Dremio University
1

Hi everyone,
The data source of oracle is configured in dremio, and the table is awh_ Test, field name is A, field type is VARCHAR2 (30)

Execute " desc awh_test " in SQL Runner; The type of A found is displayed as CHARACTER VARYING

Testing the dremio environment: version 22

Document description on official website: VARCHAR2 (Oracle Data Type) —>>>VARCHAR (Dremio Type) is inconsistent. How do I explain this inconsistency

2

I’m not sure I understand your question, but I think you might be wondering why DESC shows “CHARACTER VARYING” but Dremio docs say it should be VARCHAR? If so, the answer is that VARCHAR and CHARACTER VARYING are the same thing.

3

Your understanding is correct. Thank you for your reply