Hey folks,

I am executing INSERT INTO SELECT hive query through oozie workflow. Below are 
the details. Extra zeros are getting generated in target table(parquet_table). 
Can anyone help me to identify the issue.

Ex.

Value of COLUMN_SAMPLE in source table(tab1) : 1
Value of COLUMN_SAMPLE in destination table(parquet_table) :  
1000000000000000000


Avro column:
"name":"COLUMN_SAMPLE","type":["null",{"type":"bytes","logicalType":"decimal","precision":"38","scale":"18"}]

Select Query(insert.sql):

insert into table parquet_table select * from default.tab1;


OOZIE HIVE Action:

<hive xmlns="uri:oozie:hive-action:0.2">
                                                
<job-tracker>${jobTracker}</job-tracker>
                                                
<name-node>${nameNode}</name-node>
                                                
<job-xml>${hive_site_location}</job-xml>
                                                <configuration>
                                                                <property>
                                                                                
<name>hive.querylog.location</name>
                                                                                
<value>/tmp</value>
                                                                </property>
                                                                <property>
                                                                                
<name>hive.exec.local.scratchdir</name>
                                                                                
<value>/tmp</value>
                                                                </property>
                                                                <property>
                                                                                
<name>hive.root.logger</name>
                                                                                
<value>INFO,console</value>
                                                                </property>
                                                </configuration>
                                                
<script>/user/file/insert.sql</script>
</hive>

Regards,
Dhaval

Reply via email to