hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lunagariya, Dhaval " <dhaval.lunagar...@citi.com>
Subject Extra ZEROS getting generated in Target table
Date Wed, 30 Mar 2016 14:25:27 GMT
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


Mime
View raw message