Re: Unix script for identifying current active namenode in a HA cluster

Good work Devopam Mittra. *RegardsMuthupandi.K* Think before you print. On Wed, Nov 5, 2014 at 12:31 PM, Nitin Pawar wrote: > +1 > If you can optionally add hadoop home directory in the script and use that > in path, it can be used out of the box. > > Also can you share this on github > >

Re: Unix script for identifying current active namenode in a HA cluster

+1 If you can optionally add hadoop home directory in the script and use that in path, it can be used out of the box. Also can you share this on github On Wed, Nov 5, 2014 at 10:02 AM, Devopam Mittra wrote: > hi All, > Please find attached a simple shell script to dynamically determine the > ac

Re: Fwd: I have some errors to run hql from shell script

Hard to say what the problem is just based on the stderr; try checking hive's logs for more information: https://cwiki.apache.org/confluence/display/Hive/GettingStarted#GettingStarted-ErrorLogs Andrew On 11/4/14, 9:43 PM, Jihyun Suh wrote: I have a problem to run hql from shell script. I ca

Fwd: I have some errors to run hql from shell script

I have a problem to run hql from shell script. I can run partition query just like "use myDB; show partitions myTbl;" But I have a problem count query just like "use myDB; select count(*) from myTbl where date=20141102;" I have these error messages for it. How can I run my count hive query in she

Unix script for identifying current active namenode in a HA cluster

hi All, Please find attached a simple shell script to dynamically determine the active namenode in the HA Cluster and subsequently run the Hive job / query via Talend OS generated workflows. It was tried successfully on a HDP2.1 cluster with 2 nn, 7 dn running on CentOS 6.5. Each ETL job invokes t

Re: Hive 0.14 configuration

Here's more information about configuring for transactions: Hive Transactions -- Configuration . -- Lefty On Tue, Nov 4, 2014 at 4:19 AM, mahesh kumar wrote: > Hi, > Finally i updated and d

Oozie job not running

Hi All, I am trying to run my oozie job but its giving below error user@ubuntu:~/hive_oozie$ oozie job -oozie http://ubuntu:11000/oozie -config job.properties -run Error: E0501 : E0501: Could not perform authorization operation, Call From ubuntu/192.168.31.130 to localhost:8020 failed on connect

Re: confirm subscribe to user@hive.apache.org

Hi User, I want to join this group On Tue, Nov 4, 2014 at 9:35 PM, wrote: > Hi! This is the ezmlm program. I'm managing the > user@hive.apache.org mailing list. > > To confirm that you would like > >amit.bd...@gmail.com > > added to the user mailing list, please send > a short reply to this

Re: Beeline client

Thanks szehon to correct me, sorry, i didn't get the question properly. On Tue, Nov 4, 2014 at 6:10 PM, Hanish Bansal < hanish.bansal.agar...@gmail.com> wrote: > Thanks all for response !! > > Szehon, yup I was facing issue mentioned in HIVE-6928. By using > --outputFormat=vertical it is showing

Re: Beeline client

Thanks all for response !! Szehon, yup I was facing issue mentioned in HIVE-6928. By using --outputFormat=vertical it is showing proper result but not user friendly. For now it is fine for me. I ll have to wait for hive release 0.14.0 to get proper result in tabular form. Once again Thanks Szeho

Re: Hive 0.14 configuration

Hi, Finally i updated and deleted from hive table.we need to create table with transactional = true like following. create table test(id int, name varchar(128)) clustered by (id) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') insert into table test values(1,'Mahesh'); upd

Re: Hive 0.14 configuration

Hi Nitin, I created table with ORC format when i update it shows the following error. CREATE TABLE students (name VARCHAR(64), age INT, gpa DECIMAL(3, 2)) CLUSTERED BY (age) INTO 2 BUCKETS STORED AS ORC; INSERT INTO TABLE students VALUES ('fred flintstone', 35, 1.28), ('barney rubble',

Re: Hive 0.14 configuration

currently only ORCFileformat is supports ACIDOutputformat So you may want to create a table with orcfile format and see if you are able to do acid opertaions. On Tue, Nov 4, 2014 at 1:14 PM, mahesh kumar wrote: > Hi Nitin, > > how to create table with AcidOuptut Format.?Can you s