@ericathm Let us start with the push down that is sent to Oracle, can you please provide us with the job profile that will tell us the pushdown, meanwhile, can you please try external query and see if that brings the right value?
BUT, when I try to convert the field to precision 8, it returns correctly
However, the table has a large volume and is not a possible alternative for us to use it like this
Because, for this conversion, all the volume of the table will be taken to Dremio, instead of being processed in Oracle
SELECT VAL_PRECO_UNITARIO FROM table(BDH.external_query('SELECT cast(VAL_PRECO_UNITARIO as decimal(38,8)) as VAL_PRECO_UNITARIO FROM CETIPH.OPERACAO where NUM_ID_OPERACAO_H = 6887275048'));
@ericathm Having trouble opening the normal profile. Let us do this, is it possibleto send the “CREATE TABLE” DDL for BASEH.OPERACAO from SQL Developer or SQL Plus. Best is to recreate the issue so we can find a workaround or solution