Anand Murali, to unsubscribe please send a message to [email protected] as described here: Mailing Lists <http://hive.apache.org/mailing_lists.html>. Thanks.
-- Lefty On Wed, Mar 30, 2016 at 8:18 AM, Anand Murali <[email protected]> wrote: > Unsubscribe > > ------------------------------ > * From: * Lunagariya, Dhaval <[email protected]>; > * To: * '[email protected]' <[email protected]>; > * Cc: * '[email protected]' <[email protected]>; ' > [email protected]' <[email protected]>; ' > [email protected]' <[email protected]>; > * Subject: * Extra ZEROS getting generated in Target table > * Sent: * Wed, Mar 30, 2016 2:25:27 PM > > 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 > > >
