hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <leftylever...@gmail.com>
Subject Re: unsubscribe
Date Thu, 31 Mar 2016 08:05:04 GMT
Anand Murali, to unsubscribe please send a message to
user-unsubscribe@hive.apache.org 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 <anand_vihar@yahoo.com> wrote:

> Unsubscribe
>
> ------------------------------
> * From: * Lunagariya, Dhaval <dhaval.lunagariya@citi.com>;
> * To: * 'user@hive.apache.org' <user@hive.apache.org>;
> * Cc: * 'er.dcpatel@gmail.com' <er.dcpatel@gmail.com>; '
> gupta.akhil.004@gmail.com' <gupta.akhil.004@gmail.com>; '
> shaurdby@gmail.com' <shaurdby@gmail.com>;
> * 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
>
>
>

Mime
View raw message