Improving query performance on hive and hdfs

[iwannaplay games <fu...@gmail.com>]

Hi all,

I ran a query on hive on top of 90 million records that took 12 minutes to
execute and same query on sql server took 8 minutes.My question is how can
i make hadoop's performance better.What all configurations will improve the
latency?

Thanks & Regards
Prabhjot

RE: New Learner for Haddop and Hive

[Ajit Kumar Shreevastava <Aj...@hcl.com>]

Hi,


I have Apace Hadoop 0.20.2 installed on Cygwin (on Windows 7). Hadoop is working fine through SSHD on Cygwin. After installing Hadoop, I have installed Hive 0.8.1 following the standard installation instructions. $HADOOP_HOME and $HIVE_HOME are both exported to PATH.

The problem I am facing is that when I type bin/hive from $HIVE_HOME I get the Hive (hive>) prompt. But when I type in something (e.g. SHOW TABLES; etc) there is no output. The cursor simply keeps on blinking.

I have tried some patches (e.g. https://issues.apache.org/jira/browse/HIVE-344) but it has not helped. Can somebody help?

Thanks,

Ajit

Regards,
Ajit

From: Babu, Prashanth [mailto:Prashanth.Babu@nttdata.com]
Sent: Friday, September 07, 2012 3:46 PM
To: user@hive.apache.org
Cc: user@hadoop.apache.org; hdfs-user
Subject: RE: New Learner for Haddop and Hive

Ajit,

Please follow the guidelines as mentioned by Bertrand.

Apart from that, What is the output of
hive> show tables;

Does it display anything?
If not, what is the message or stacktrace you see on the console?

Also, post your Hadoop Environment details like what is the version of Hadoop, Hive, etc you are using etc and also the OS info, which will help the community to understand the issue better.


From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
Sent: Wednesday, September 05, 2012 3:07 PM
To: user@hive.apache.org
Cc: user@hadoop.apache.org; hdfs-user
Subject: Re: New Learner for Haddop and Hive


1) First do not post across multiple mailing list. I am replying to all in order to share my answer but you should then reply only on the mailing list which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org<ma...@hadoop.apache.org>
3) Does your hive installation work? If not, ask user@hive.apache.org<ma...@hive.apache.org>
4) Explain your problem : " I got nothing" and no error message won't provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki : https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand
On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <Aj...@hcl.com>> wrote:
Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.
----------------------------------------------------------------------------------------------------------------------------------------------------



--
Bertrand Dechoux

______________________________________________________________________
Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data. If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

Re: New Learner for Haddop and Hive

[Michael Segel <mi...@hotmail.com>]

How Jason ever got top billing, I'll never know. :-)
(Just kidding Jason!)

Yes, that's the book. 

-Mike

On Sep 7, 2012, at 1:14 PM, Robert Dyer <rd...@iastate.edu> wrote:

> Amazon says Oct 9.
> 
> http://www.amazon.com/Programming-Hive-Jason-Rutherglen/dp/1449319335
> 
> On Fri, Sep 7, 2012 at 1:11 PM, Michael Segel <mi...@hotmail.com> wrote:
>> You could just wait until the new Hive book comes out.
>> I think its sometime this month...
>> 
>> On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com>
>> wrote:
>> 
>> Ajit,
>> 
>> Please follow the guidelines as mentioned by Bertrand.
>> 
>> Apart from that, What is the output of
>> hive> show tables;
>> 
>> Does it display anything?
>> If not, what is the message or stacktrace you see on the console?
>> 
>> Also, post your Hadoop Environment details like what is the version of
>> Hadoop, Hive, etc you are using etc and also the OS info, which will help
>> the community to understand the issue better.
>> 
>> 
>> From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
>> Sent: Wednesday, September 05, 2012 3:07 PM
>> To: user@hive.apache.org
>> Cc: user@hadoop.apache.org; hdfs-user
>> Subject: Re: New Learner for Haddop and Hive
>> 
>> 
>> 
>> 1) First do not post across multiple mailing list. I am replying to all in
>> order to share my answer but you should then reply only on the mailing list
>> which is concerned with your issue.
>> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
>> 3) Does your hive installation work? If not, ask user@hive.apache.org
>> 4) Explain your problem : " I got nothing" and no error message won't
>> provide you any good feedback.
>> 6) Hive installation is pretty well explained in the hive wiki :
>> https://cwiki.apache.org/confluence/display/Hive/Home
>> 
>> Regards
>> 
>> Bertrand
>> 
>> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava
>> <Aj...@hcl.com> wrote:
>> Hi All,
>> 
>> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The
>> process for setting Hadoop and Hive to start and work”. I have visited lots
>> of site and do the configuration according to that.
>> Now I want run Hive after starting all the services of hadoop,  I got
>> nothing.
>> 
>> Ajit.Shreevastava@hclt-40124697 ~
>> $ start-all.sh
>> starting namenode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
>> localhost: starting datanode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
>> localhost: starting secondarynamenode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
>> starting jobtracker, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
>> localhost: starting tasktracker, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>> 
>> Ajit.Shreevastava@hclt-40124697 ~
>> $ hive
>> Logging initialized using configuration in
>> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
>> Hive history
>> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
>> hive> show tables;
>> 
>> I am also sending you my configuration files of Hive conf directory.
>> 
>> Please help me.
>> 
>> Regards,
>> Ajit Kumar Shreevastava
>> 
>> 
>> ::DISCLAIMER::
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
>> The contents of this e-mail and any attachment(s) are confidential and
>> intended for the named recipient(s) only.
>> E-mail transmission is not guaranteed to be secure or error-free as
>> information could be intercepted, corrupted,
>> lost, destroyed, arrive late or incomplete, or may contain viruses in
>> transmission. The e mail and its contents
>> (with or without referred errors) shall therefore not attach any liability
>> on the originator or HCL or its affiliates.
>> Views or opinions, if any, presented in this email are solely those of the
>> author and may not necessarily reflect the
>> views or opinions of HCL or its affiliates. Any form of reproduction,
>> dissemination, copying, disclosure, modification,
>> distribution and / or publication of this message without the prior written
>> consent of authorized representative of
>> HCL is strictly prohibited. If you have received this email in error please
>> delete it and notify the sender immediately.
>> Before opening any email and/or attachments, please check them for viruses
>> and other defects.
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
>> 
>> 
>> 
>> --
>> Bertrand Dechoux
>> 
>> ______________________________________________________________________
>> Disclaimer:This email and any attachments are sent in strictest confidence
>> for the sole use of the addressee and may contain legally privileged,
>> confidential, and proprietary data. If you are not the intended recipient,
>> please advise the sender by replying promptly to this email and then delete
>> and destroy this email and any attachments without any further use, copying
>> or forwarding
>> 
>> 
> 
> 
> 
> -- 
> 
> Robert Dyer
> rdyer@iastate.edu
> 

Re: New Learner for Haddop and Hive

[Michael Segel <mi...@hotmail.com>]

How Jason ever got top billing, I'll never know. :-)
(Just kidding Jason!)

Yes, that's the book. 

-Mike

On Sep 7, 2012, at 1:14 PM, Robert Dyer <rd...@iastate.edu> wrote:

> Amazon says Oct 9.
> 
> http://www.amazon.com/Programming-Hive-Jason-Rutherglen/dp/1449319335
> 
> On Fri, Sep 7, 2012 at 1:11 PM, Michael Segel <mi...@hotmail.com> wrote:
>> You could just wait until the new Hive book comes out.
>> I think its sometime this month...
>> 
>> On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com>
>> wrote:
>> 
>> Ajit,
>> 
>> Please follow the guidelines as mentioned by Bertrand.
>> 
>> Apart from that, What is the output of
>> hive> show tables;
>> 
>> Does it display anything?
>> If not, what is the message or stacktrace you see on the console?
>> 
>> Also, post your Hadoop Environment details like what is the version of
>> Hadoop, Hive, etc you are using etc and also the OS info, which will help
>> the community to understand the issue better.
>> 
>> 
>> From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
>> Sent: Wednesday, September 05, 2012 3:07 PM
>> To: user@hive.apache.org
>> Cc: user@hadoop.apache.org; hdfs-user
>> Subject: Re: New Learner for Haddop and Hive
>> 
>> 
>> 
>> 1) First do not post across multiple mailing list. I am replying to all in
>> order to share my answer but you should then reply only on the mailing list
>> which is concerned with your issue.
>> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
>> 3) Does your hive installation work? If not, ask user@hive.apache.org
>> 4) Explain your problem : " I got nothing" and no error message won't
>> provide you any good feedback.
>> 6) Hive installation is pretty well explained in the hive wiki :
>> https://cwiki.apache.org/confluence/display/Hive/Home
>> 
>> Regards
>> 
>> Bertrand
>> 
>> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava
>> <Aj...@hcl.com> wrote:
>> Hi All,
>> 
>> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The
>> process for setting Hadoop and Hive to start and work”. I have visited lots
>> of site and do the configuration according to that.
>> Now I want run Hive after starting all the services of hadoop,  I got
>> nothing.
>> 
>> Ajit.Shreevastava@hclt-40124697 ~
>> $ start-all.sh
>> starting namenode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
>> localhost: starting datanode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
>> localhost: starting secondarynamenode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
>> starting jobtracker, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
>> localhost: starting tasktracker, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>> 
>> Ajit.Shreevastava@hclt-40124697 ~
>> $ hive
>> Logging initialized using configuration in
>> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
>> Hive history
>> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
>> hive> show tables;
>> 
>> I am also sending you my configuration files of Hive conf directory.
>> 
>> Please help me.
>> 
>> Regards,
>> Ajit Kumar Shreevastava
>> 
>> 
>> ::DISCLAIMER::
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
>> The contents of this e-mail and any attachment(s) are confidential and
>> intended for the named recipient(s) only.
>> E-mail transmission is not guaranteed to be secure or error-free as
>> information could be intercepted, corrupted,
>> lost, destroyed, arrive late or incomplete, or may contain viruses in
>> transmission. The e mail and its contents
>> (with or without referred errors) shall therefore not attach any liability
>> on the originator or HCL or its affiliates.
>> Views or opinions, if any, presented in this email are solely those of the
>> author and may not necessarily reflect the
>> views or opinions of HCL or its affiliates. Any form of reproduction,
>> dissemination, copying, disclosure, modification,
>> distribution and / or publication of this message without the prior written
>> consent of authorized representative of
>> HCL is strictly prohibited. If you have received this email in error please
>> delete it and notify the sender immediately.
>> Before opening any email and/or attachments, please check them for viruses
>> and other defects.
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
>> 
>> 
>> 
>> --
>> Bertrand Dechoux
>> 
>> ______________________________________________________________________
>> Disclaimer:This email and any attachments are sent in strictest confidence
>> for the sole use of the addressee and may contain legally privileged,
>> confidential, and proprietary data. If you are not the intended recipient,
>> please advise the sender by replying promptly to this email and then delete
>> and destroy this email and any attachments without any further use, copying
>> or forwarding
>> 
>> 
> 
> 
> 
> -- 
> 
> Robert Dyer
> rdyer@iastate.edu
> 

Re: New Learner for Haddop and Hive

[Michael Segel <mi...@hotmail.com>]

How Jason ever got top billing, I'll never know. :-)
(Just kidding Jason!)

Yes, that's the book. 

-Mike

On Sep 7, 2012, at 1:14 PM, Robert Dyer <rd...@iastate.edu> wrote:

> Amazon says Oct 9.
> 
> http://www.amazon.com/Programming-Hive-Jason-Rutherglen/dp/1449319335
> 
> On Fri, Sep 7, 2012 at 1:11 PM, Michael Segel <mi...@hotmail.com> wrote:
>> You could just wait until the new Hive book comes out.
>> I think its sometime this month...
>> 
>> On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com>
>> wrote:
>> 
>> Ajit,
>> 
>> Please follow the guidelines as mentioned by Bertrand.
>> 
>> Apart from that, What is the output of
>> hive> show tables;
>> 
>> Does it display anything?
>> If not, what is the message or stacktrace you see on the console?
>> 
>> Also, post your Hadoop Environment details like what is the version of
>> Hadoop, Hive, etc you are using etc and also the OS info, which will help
>> the community to understand the issue better.
>> 
>> 
>> From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
>> Sent: Wednesday, September 05, 2012 3:07 PM
>> To: user@hive.apache.org
>> Cc: user@hadoop.apache.org; hdfs-user
>> Subject: Re: New Learner for Haddop and Hive
>> 
>> 
>> 
>> 1) First do not post across multiple mailing list. I am replying to all in
>> order to share my answer but you should then reply only on the mailing list
>> which is concerned with your issue.
>> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
>> 3) Does your hive installation work? If not, ask user@hive.apache.org
>> 4) Explain your problem : " I got nothing" and no error message won't
>> provide you any good feedback.
>> 6) Hive installation is pretty well explained in the hive wiki :
>> https://cwiki.apache.org/confluence/display/Hive/Home
>> 
>> Regards
>> 
>> Bertrand
>> 
>> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava
>> <Aj...@hcl.com> wrote:
>> Hi All,
>> 
>> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The
>> process for setting Hadoop and Hive to start and work”. I have visited lots
>> of site and do the configuration according to that.
>> Now I want run Hive after starting all the services of hadoop,  I got
>> nothing.
>> 
>> Ajit.Shreevastava@hclt-40124697 ~
>> $ start-all.sh
>> starting namenode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
>> localhost: starting datanode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
>> localhost: starting secondarynamenode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
>> starting jobtracker, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
>> localhost: starting tasktracker, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>> 
>> Ajit.Shreevastava@hclt-40124697 ~
>> $ hive
>> Logging initialized using configuration in
>> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
>> Hive history
>> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
>> hive> show tables;
>> 
>> I am also sending you my configuration files of Hive conf directory.
>> 
>> Please help me.
>> 
>> Regards,
>> Ajit Kumar Shreevastava
>> 
>> 
>> ::DISCLAIMER::
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
>> The contents of this e-mail and any attachment(s) are confidential and
>> intended for the named recipient(s) only.
>> E-mail transmission is not guaranteed to be secure or error-free as
>> information could be intercepted, corrupted,
>> lost, destroyed, arrive late or incomplete, or may contain viruses in
>> transmission. The e mail and its contents
>> (with or without referred errors) shall therefore not attach any liability
>> on the originator or HCL or its affiliates.
>> Views or opinions, if any, presented in this email are solely those of the
>> author and may not necessarily reflect the
>> views or opinions of HCL or its affiliates. Any form of reproduction,
>> dissemination, copying, disclosure, modification,
>> distribution and / or publication of this message without the prior written
>> consent of authorized representative of
>> HCL is strictly prohibited. If you have received this email in error please
>> delete it and notify the sender immediately.
>> Before opening any email and/or attachments, please check them for viruses
>> and other defects.
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
>> 
>> 
>> 
>> --
>> Bertrand Dechoux
>> 
>> ______________________________________________________________________
>> Disclaimer:This email and any attachments are sent in strictest confidence
>> for the sole use of the addressee and may contain legally privileged,
>> confidential, and proprietary data. If you are not the intended recipient,
>> please advise the sender by replying promptly to this email and then delete
>> and destroy this email and any attachments without any further use, copying
>> or forwarding
>> 
>> 
> 
> 
> 
> -- 
> 
> Robert Dyer
> rdyer@iastate.edu
> 

Re: New Learner for Haddop and Hive

[Michael Segel <mi...@hotmail.com>]

How Jason ever got top billing, I'll never know. :-)
(Just kidding Jason!)

Yes, that's the book. 

-Mike

On Sep 7, 2012, at 1:14 PM, Robert Dyer <rd...@iastate.edu> wrote:

> Amazon says Oct 9.
> 
> http://www.amazon.com/Programming-Hive-Jason-Rutherglen/dp/1449319335
> 
> On Fri, Sep 7, 2012 at 1:11 PM, Michael Segel <mi...@hotmail.com> wrote:
>> You could just wait until the new Hive book comes out.
>> I think its sometime this month...
>> 
>> On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com>
>> wrote:
>> 
>> Ajit,
>> 
>> Please follow the guidelines as mentioned by Bertrand.
>> 
>> Apart from that, What is the output of
>> hive> show tables;
>> 
>> Does it display anything?
>> If not, what is the message or stacktrace you see on the console?
>> 
>> Also, post your Hadoop Environment details like what is the version of
>> Hadoop, Hive, etc you are using etc and also the OS info, which will help
>> the community to understand the issue better.
>> 
>> 
>> From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
>> Sent: Wednesday, September 05, 2012 3:07 PM
>> To: user@hive.apache.org
>> Cc: user@hadoop.apache.org; hdfs-user
>> Subject: Re: New Learner for Haddop and Hive
>> 
>> 
>> 
>> 1) First do not post across multiple mailing list. I am replying to all in
>> order to share my answer but you should then reply only on the mailing list
>> which is concerned with your issue.
>> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
>> 3) Does your hive installation work? If not, ask user@hive.apache.org
>> 4) Explain your problem : " I got nothing" and no error message won't
>> provide you any good feedback.
>> 6) Hive installation is pretty well explained in the hive wiki :
>> https://cwiki.apache.org/confluence/display/Hive/Home
>> 
>> Regards
>> 
>> Bertrand
>> 
>> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava
>> <Aj...@hcl.com> wrote:
>> Hi All,
>> 
>> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The
>> process for setting Hadoop and Hive to start and work”. I have visited lots
>> of site and do the configuration according to that.
>> Now I want run Hive after starting all the services of hadoop,  I got
>> nothing.
>> 
>> Ajit.Shreevastava@hclt-40124697 ~
>> $ start-all.sh
>> starting namenode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
>> localhost: starting datanode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
>> localhost: starting secondarynamenode, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
>> starting jobtracker, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
>> localhost: starting tasktracker, logging to
>> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>> 
>> Ajit.Shreevastava@hclt-40124697 ~
>> $ hive
>> Logging initialized using configuration in
>> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
>> Hive history
>> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
>> hive> show tables;
>> 
>> I am also sending you my configuration files of Hive conf directory.
>> 
>> Please help me.
>> 
>> Regards,
>> Ajit Kumar Shreevastava
>> 
>> 
>> ::DISCLAIMER::
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
>> The contents of this e-mail and any attachment(s) are confidential and
>> intended for the named recipient(s) only.
>> E-mail transmission is not guaranteed to be secure or error-free as
>> information could be intercepted, corrupted,
>> lost, destroyed, arrive late or incomplete, or may contain viruses in
>> transmission. The e mail and its contents
>> (with or without referred errors) shall therefore not attach any liability
>> on the originator or HCL or its affiliates.
>> Views or opinions, if any, presented in this email are solely those of the
>> author and may not necessarily reflect the
>> views or opinions of HCL or its affiliates. Any form of reproduction,
>> dissemination, copying, disclosure, modification,
>> distribution and / or publication of this message without the prior written
>> consent of authorized representative of
>> HCL is strictly prohibited. If you have received this email in error please
>> delete it and notify the sender immediately.
>> Before opening any email and/or attachments, please check them for viruses
>> and other defects.
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
>> 
>> 
>> 
>> --
>> Bertrand Dechoux
>> 
>> ______________________________________________________________________
>> Disclaimer:This email and any attachments are sent in strictest confidence
>> for the sole use of the addressee and may contain legally privileged,
>> confidential, and proprietary data. If you are not the intended recipient,
>> please advise the sender by replying promptly to this email and then delete
>> and destroy this email and any attachments without any further use, copying
>> or forwarding
>> 
>> 
> 
> 
> 
> -- 
> 
> Robert Dyer
> rdyer@iastate.edu
> 

Re: New Learner for Haddop and Hive

[Robert Dyer <rd...@iastate.edu>]

Amazon says Oct 9.

http://www.amazon.com/Programming-Hive-Jason-Rutherglen/dp/1449319335

On Fri, Sep 7, 2012 at 1:11 PM, Michael Segel <mi...@hotmail.com> wrote:
> You could just wait until the new Hive book comes out.
> I think its sometime this month...
>
> On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com>
> wrote:
>
> Ajit,
>
> Please follow the guidelines as mentioned by Bertrand.
>
> Apart from that, What is the output of
> hive> show tables;
>
> Does it display anything?
> If not, what is the message or stacktrace you see on the console?
>
> Also, post your Hadoop Environment details like what is the version of
> Hadoop, Hive, etc you are using etc and also the OS info, which will help
> the community to understand the issue better.
>
>
> From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
> Sent: Wednesday, September 05, 2012 3:07 PM
> To: user@hive.apache.org
> Cc: user@hadoop.apache.org; hdfs-user
> Subject: Re: New Learner for Haddop and Hive
>
>
>
> 1) First do not post across multiple mailing list. I am replying to all in
> order to share my answer but you should then reply only on the mailing list
> which is concerned with your issue.
> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
> 3) Does your hive installation work? If not, ask user@hive.apache.org
> 4) Explain your problem : " I got nothing" and no error message won't
> provide you any good feedback.
> 6) Hive installation is pretty well explained in the hive wiki :
> https://cwiki.apache.org/confluence/display/Hive/Home
>
> Regards
>
> Bertrand
>
> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava
> <Aj...@hcl.com> wrote:
> Hi All,
>
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The
> process for setting Hadoop and Hive to start and work”. I have visited lots
> of site and do the configuration according to that.
> Now I want run Hive after starting all the services of hadoop,  I got
> nothing.
>
> Ajit.Shreevastava@hclt-40124697 ~
> $ start-all.sh
> starting namenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
> localhost: starting datanode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
> localhost: starting secondarynamenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> starting jobtracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> localhost: starting tasktracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>
> Ajit.Shreevastava@hclt-40124697 ~
> $ hive
> Logging initialized using configuration in
> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> Hive history
> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> hive> show tables;
>
> I am also sending you my configuration files of Hive conf directory.
>
> Please help me.
>
> Regards,
> Ajit Kumar Shreevastava
>
>
> ::DISCLAIMER::
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as
> information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in
> transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability
> on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the
> author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior written
> consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error please
> delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses
> and other defects.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
>
>
> --
> Bertrand Dechoux
>
> ______________________________________________________________________
> Disclaimer:This email and any attachments are sent in strictest confidence
> for the sole use of the addressee and may contain legally privileged,
> confidential, and proprietary data. If you are not the intended recipient,
> please advise the sender by replying promptly to this email and then delete
> and destroy this email and any attachments without any further use, copying
> or forwarding
>
>



-- 

Robert Dyer
rdyer@iastate.edu

Re: New Learner for Haddop and Hive

[Robert Dyer <rd...@iastate.edu>]

Amazon says Oct 9.

http://www.amazon.com/Programming-Hive-Jason-Rutherglen/dp/1449319335

On Fri, Sep 7, 2012 at 1:11 PM, Michael Segel <mi...@hotmail.com> wrote:
> You could just wait until the new Hive book comes out.
> I think its sometime this month...
>
> On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com>
> wrote:
>
> Ajit,
>
> Please follow the guidelines as mentioned by Bertrand.
>
> Apart from that, What is the output of
> hive> show tables;
>
> Does it display anything?
> If not, what is the message or stacktrace you see on the console?
>
> Also, post your Hadoop Environment details like what is the version of
> Hadoop, Hive, etc you are using etc and also the OS info, which will help
> the community to understand the issue better.
>
>
> From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
> Sent: Wednesday, September 05, 2012 3:07 PM
> To: user@hive.apache.org
> Cc: user@hadoop.apache.org; hdfs-user
> Subject: Re: New Learner for Haddop and Hive
>
>
>
> 1) First do not post across multiple mailing list. I am replying to all in
> order to share my answer but you should then reply only on the mailing list
> which is concerned with your issue.
> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
> 3) Does your hive installation work? If not, ask user@hive.apache.org
> 4) Explain your problem : " I got nothing" and no error message won't
> provide you any good feedback.
> 6) Hive installation is pretty well explained in the hive wiki :
> https://cwiki.apache.org/confluence/display/Hive/Home
>
> Regards
>
> Bertrand
>
> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava
> <Aj...@hcl.com> wrote:
> Hi All,
>
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The
> process for setting Hadoop and Hive to start and work”. I have visited lots
> of site and do the configuration according to that.
> Now I want run Hive after starting all the services of hadoop,  I got
> nothing.
>
> Ajit.Shreevastava@hclt-40124697 ~
> $ start-all.sh
> starting namenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
> localhost: starting datanode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
> localhost: starting secondarynamenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> starting jobtracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> localhost: starting tasktracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>
> Ajit.Shreevastava@hclt-40124697 ~
> $ hive
> Logging initialized using configuration in
> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> Hive history
> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> hive> show tables;
>
> I am also sending you my configuration files of Hive conf directory.
>
> Please help me.
>
> Regards,
> Ajit Kumar Shreevastava
>
>
> ::DISCLAIMER::
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as
> information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in
> transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability
> on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the
> author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior written
> consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error please
> delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses
> and other defects.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
>
>
> --
> Bertrand Dechoux
>
> ______________________________________________________________________
> Disclaimer:This email and any attachments are sent in strictest confidence
> for the sole use of the addressee and may contain legally privileged,
> confidential, and proprietary data. If you are not the intended recipient,
> please advise the sender by replying promptly to this email and then delete
> and destroy this email and any attachments without any further use, copying
> or forwarding
>
>



-- 

Robert Dyer
rdyer@iastate.edu

Re: New Learner for Haddop and Hive

[Robert Dyer <rd...@iastate.edu>]

Amazon says Oct 9.

http://www.amazon.com/Programming-Hive-Jason-Rutherglen/dp/1449319335

On Fri, Sep 7, 2012 at 1:11 PM, Michael Segel <mi...@hotmail.com> wrote:
> You could just wait until the new Hive book comes out.
> I think its sometime this month...
>
> On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com>
> wrote:
>
> Ajit,
>
> Please follow the guidelines as mentioned by Bertrand.
>
> Apart from that, What is the output of
> hive> show tables;
>
> Does it display anything?
> If not, what is the message or stacktrace you see on the console?
>
> Also, post your Hadoop Environment details like what is the version of
> Hadoop, Hive, etc you are using etc and also the OS info, which will help
> the community to understand the issue better.
>
>
> From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
> Sent: Wednesday, September 05, 2012 3:07 PM
> To: user@hive.apache.org
> Cc: user@hadoop.apache.org; hdfs-user
> Subject: Re: New Learner for Haddop and Hive
>
>
>
> 1) First do not post across multiple mailing list. I am replying to all in
> order to share my answer but you should then reply only on the mailing list
> which is concerned with your issue.
> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
> 3) Does your hive installation work? If not, ask user@hive.apache.org
> 4) Explain your problem : " I got nothing" and no error message won't
> provide you any good feedback.
> 6) Hive installation is pretty well explained in the hive wiki :
> https://cwiki.apache.org/confluence/display/Hive/Home
>
> Regards
>
> Bertrand
>
> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava
> <Aj...@hcl.com> wrote:
> Hi All,
>
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The
> process for setting Hadoop and Hive to start and work”. I have visited lots
> of site and do the configuration according to that.
> Now I want run Hive after starting all the services of hadoop,  I got
> nothing.
>
> Ajit.Shreevastava@hclt-40124697 ~
> $ start-all.sh
> starting namenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
> localhost: starting datanode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
> localhost: starting secondarynamenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> starting jobtracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> localhost: starting tasktracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>
> Ajit.Shreevastava@hclt-40124697 ~
> $ hive
> Logging initialized using configuration in
> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> Hive history
> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> hive> show tables;
>
> I am also sending you my configuration files of Hive conf directory.
>
> Please help me.
>
> Regards,
> Ajit Kumar Shreevastava
>
>
> ::DISCLAIMER::
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as
> information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in
> transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability
> on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the
> author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior written
> consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error please
> delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses
> and other defects.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
>
>
> --
> Bertrand Dechoux
>
> ______________________________________________________________________
> Disclaimer:This email and any attachments are sent in strictest confidence
> for the sole use of the addressee and may contain legally privileged,
> confidential, and proprietary data. If you are not the intended recipient,
> please advise the sender by replying promptly to this email and then delete
> and destroy this email and any attachments without any further use, copying
> or forwarding
>
>



-- 

Robert Dyer
rdyer@iastate.edu

Re: New Learner for Haddop and Hive

[Robert Dyer <rd...@iastate.edu>]

Amazon says Oct 9.

http://www.amazon.com/Programming-Hive-Jason-Rutherglen/dp/1449319335

On Fri, Sep 7, 2012 at 1:11 PM, Michael Segel <mi...@hotmail.com> wrote:
> You could just wait until the new Hive book comes out.
> I think its sometime this month...
>
> On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com>
> wrote:
>
> Ajit,
>
> Please follow the guidelines as mentioned by Bertrand.
>
> Apart from that, What is the output of
> hive> show tables;
>
> Does it display anything?
> If not, what is the message or stacktrace you see on the console?
>
> Also, post your Hadoop Environment details like what is the version of
> Hadoop, Hive, etc you are using etc and also the OS info, which will help
> the community to understand the issue better.
>
>
> From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
> Sent: Wednesday, September 05, 2012 3:07 PM
> To: user@hive.apache.org
> Cc: user@hadoop.apache.org; hdfs-user
> Subject: Re: New Learner for Haddop and Hive
>
>
>
> 1) First do not post across multiple mailing list. I am replying to all in
> order to share my answer but you should then reply only on the mailing list
> which is concerned with your issue.
> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
> 3) Does your hive installation work? If not, ask user@hive.apache.org
> 4) Explain your problem : " I got nothing" and no error message won't
> provide you any good feedback.
> 6) Hive installation is pretty well explained in the hive wiki :
> https://cwiki.apache.org/confluence/display/Hive/Home
>
> Regards
>
> Bertrand
>
> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava
> <Aj...@hcl.com> wrote:
> Hi All,
>
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The
> process for setting Hadoop and Hive to start and work”. I have visited lots
> of site and do the configuration according to that.
> Now I want run Hive after starting all the services of hadoop,  I got
> nothing.
>
> Ajit.Shreevastava@hclt-40124697 ~
> $ start-all.sh
> starting namenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
> localhost: starting datanode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
> localhost: starting secondarynamenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> starting jobtracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> localhost: starting tasktracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>
> Ajit.Shreevastava@hclt-40124697 ~
> $ hive
> Logging initialized using configuration in
> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> Hive history
> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> hive> show tables;
>
> I am also sending you my configuration files of Hive conf directory.
>
> Please help me.
>
> Regards,
> Ajit Kumar Shreevastava
>
>
> ::DISCLAIMER::
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as
> information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in
> transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability
> on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the
> author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior written
> consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error please
> delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses
> and other defects.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
>
>
> --
> Bertrand Dechoux
>
> ______________________________________________________________________
> Disclaimer:This email and any attachments are sent in strictest confidence
> for the sole use of the addressee and may contain legally privileged,
> confidential, and proprietary data. If you are not the intended recipient,
> please advise the sender by replying promptly to this email and then delete
> and destroy this email and any attachments without any further use, copying
> or forwarding
>
>



-- 

Robert Dyer
rdyer@iastate.edu

Re: New Learner for Haddop and Hive

[Michael Segel <mi...@hotmail.com>]

You could just wait until the new Hive book comes out. 
I think its sometime this month...

On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com> wrote:

> Ajit,
>  
> Please follow the guidelines as mentioned by Bertrand.
>  
> Apart from that, What is the output of
> hive> show tables;
>  
> Does it display anything?
> If not, what is the message or stacktrace you see on the console?
>  
> Also, post your Hadoop Environment details like what is the version of Hadoop, Hive, etc you are using etc and also the OS info, which will help the community to understand the issue better.
>  
>  
> From: Bertrand Dechoux [mailto:dechouxb@gmail.com] 
> Sent: Wednesday, September 05, 2012 3:07 PM
> To: user@hive.apache.org
> Cc: user@hadoop.apache.org; hdfs-user
> Subject: Re: New Learner for Haddop and Hive
>  
> 
> 1) First do not post across multiple mailing list. I am replying to all in order to share my answer but you should then reply only on the mailing list which is concerned with your issue.
> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
> 3) Does your hive installation work? If not, ask user@hive.apache.org
> 4) Explain your problem : " I got nothing" and no error message won't provide you any good feedback.
> 6) Hive installation is pretty well explained in the hive wiki : https://cwiki.apache.org/confluence/display/Hive/Home
> 
> Regards
> 
> Bertrand
> 
> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <Aj...@hcl.com> wrote:
> Hi All,
>  
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The process for setting Hadoop and Hive to start and work”. I have visited lots of site and do the configuration according to that.
> Now I want run Hive after starting all the services of hadoop,  I got nothing.
>  
> Ajit.Shreevastava@hclt-40124697 ~
> $ start-all.sh
> starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
> localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
> localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>  
> Ajit.Shreevastava@hclt-40124697 ~
> $ hive
> Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> hive> show tables;
>  
> I am also sending you my configuration files of Hive conf directory.
>  
> Please help me.
>  
> Regards,
> Ajit Kumar Shreevastava
> 
> 
> ::DISCLAIMER::
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, 
> lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents 
> (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. 
> Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the 
> views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, 
> distribution and / or publication of this message without the prior written consent of authorized representative of 
> HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. 
> Before opening any email and/or attachments, please check them for viruses and other defects.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> 
> 
> 
> -- 
> Bertrand Dechoux
> 
> ______________________________________________________________________
> Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data. If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

Re: New Learner for Haddop and Hive

[Michael Segel <mi...@hotmail.com>]

You could just wait until the new Hive book comes out. 
I think its sometime this month...

On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com> wrote:

> Ajit,
>  
> Please follow the guidelines as mentioned by Bertrand.
>  
> Apart from that, What is the output of
> hive> show tables;
>  
> Does it display anything?
> If not, what is the message or stacktrace you see on the console?
>  
> Also, post your Hadoop Environment details like what is the version of Hadoop, Hive, etc you are using etc and also the OS info, which will help the community to understand the issue better.
>  
>  
> From: Bertrand Dechoux [mailto:dechouxb@gmail.com] 
> Sent: Wednesday, September 05, 2012 3:07 PM
> To: user@hive.apache.org
> Cc: user@hadoop.apache.org; hdfs-user
> Subject: Re: New Learner for Haddop and Hive
>  
> 
> 1) First do not post across multiple mailing list. I am replying to all in order to share my answer but you should then reply only on the mailing list which is concerned with your issue.
> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
> 3) Does your hive installation work? If not, ask user@hive.apache.org
> 4) Explain your problem : " I got nothing" and no error message won't provide you any good feedback.
> 6) Hive installation is pretty well explained in the hive wiki : https://cwiki.apache.org/confluence/display/Hive/Home
> 
> Regards
> 
> Bertrand
> 
> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <Aj...@hcl.com> wrote:
> Hi All,
>  
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The process for setting Hadoop and Hive to start and work”. I have visited lots of site and do the configuration according to that.
> Now I want run Hive after starting all the services of hadoop,  I got nothing.
>  
> Ajit.Shreevastava@hclt-40124697 ~
> $ start-all.sh
> starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
> localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
> localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>  
> Ajit.Shreevastava@hclt-40124697 ~
> $ hive
> Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> hive> show tables;
>  
> I am also sending you my configuration files of Hive conf directory.
>  
> Please help me.
>  
> Regards,
> Ajit Kumar Shreevastava
> 
> 
> ::DISCLAIMER::
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, 
> lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents 
> (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. 
> Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the 
> views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, 
> distribution and / or publication of this message without the prior written consent of authorized representative of 
> HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. 
> Before opening any email and/or attachments, please check them for viruses and other defects.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> 
> 
> 
> -- 
> Bertrand Dechoux
> 
> ______________________________________________________________________
> Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data. If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

Re: New Learner for Haddop and Hive

[Michael Segel <mi...@hotmail.com>]

You could just wait until the new Hive book comes out. 
I think its sometime this month...

On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com> wrote:

> Ajit,
>  
> Please follow the guidelines as mentioned by Bertrand.
>  
> Apart from that, What is the output of
> hive> show tables;
>  
> Does it display anything?
> If not, what is the message or stacktrace you see on the console?
>  
> Also, post your Hadoop Environment details like what is the version of Hadoop, Hive, etc you are using etc and also the OS info, which will help the community to understand the issue better.
>  
>  
> From: Bertrand Dechoux [mailto:dechouxb@gmail.com] 
> Sent: Wednesday, September 05, 2012 3:07 PM
> To: user@hive.apache.org
> Cc: user@hadoop.apache.org; hdfs-user
> Subject: Re: New Learner for Haddop and Hive
>  
> 
> 1) First do not post across multiple mailing list. I am replying to all in order to share my answer but you should then reply only on the mailing list which is concerned with your issue.
> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
> 3) Does your hive installation work? If not, ask user@hive.apache.org
> 4) Explain your problem : " I got nothing" and no error message won't provide you any good feedback.
> 6) Hive installation is pretty well explained in the hive wiki : https://cwiki.apache.org/confluence/display/Hive/Home
> 
> Regards
> 
> Bertrand
> 
> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <Aj...@hcl.com> wrote:
> Hi All,
>  
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The process for setting Hadoop and Hive to start and work”. I have visited lots of site and do the configuration according to that.
> Now I want run Hive after starting all the services of hadoop,  I got nothing.
>  
> Ajit.Shreevastava@hclt-40124697 ~
> $ start-all.sh
> starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
> localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
> localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>  
> Ajit.Shreevastava@hclt-40124697 ~
> $ hive
> Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> hive> show tables;
>  
> I am also sending you my configuration files of Hive conf directory.
>  
> Please help me.
>  
> Regards,
> Ajit Kumar Shreevastava
> 
> 
> ::DISCLAIMER::
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, 
> lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents 
> (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. 
> Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the 
> views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, 
> distribution and / or publication of this message without the prior written consent of authorized representative of 
> HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. 
> Before opening any email and/or attachments, please check them for viruses and other defects.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> 
> 
> 
> -- 
> Bertrand Dechoux
> 
> ______________________________________________________________________
> Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data. If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

Re: New Learner for Haddop and Hive

[Michael Segel <mi...@hotmail.com>]

You could just wait until the new Hive book comes out. 
I think its sometime this month...

On Sep 7, 2012, at 5:15 AM, "Babu, Prashanth" <Pr...@nttdata.com> wrote:

> Ajit,
>  
> Please follow the guidelines as mentioned by Bertrand.
>  
> Apart from that, What is the output of
> hive> show tables;
>  
> Does it display anything?
> If not, what is the message or stacktrace you see on the console?
>  
> Also, post your Hadoop Environment details like what is the version of Hadoop, Hive, etc you are using etc and also the OS info, which will help the community to understand the issue better.
>  
>  
> From: Bertrand Dechoux [mailto:dechouxb@gmail.com] 
> Sent: Wednesday, September 05, 2012 3:07 PM
> To: user@hive.apache.org
> Cc: user@hadoop.apache.org; hdfs-user
> Subject: Re: New Learner for Haddop and Hive
>  
> 
> 1) First do not post across multiple mailing list. I am replying to all in order to share my answer but you should then reply only on the mailing list which is concerned with your issue.
> 2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
> 3) Does your hive installation work? If not, ask user@hive.apache.org
> 4) Explain your problem : " I got nothing" and no error message won't provide you any good feedback.
> 6) Hive installation is pretty well explained in the hive wiki : https://cwiki.apache.org/confluence/display/Hive/Home
> 
> Regards
> 
> Bertrand
> 
> On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <Aj...@hcl.com> wrote:
> Hi All,
>  
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “ The process for setting Hadoop and Hive to start and work”. I have visited lots of site and do the configuration according to that.
> Now I want run Hive after starting all the services of hadoop,  I got nothing.
>  
> Ajit.Shreevastava@hclt-40124697 ~
> $ start-all.sh
> starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
> localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
> localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
>  
> Ajit.Shreevastava@hclt-40124697 ~
> $ hive
> Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> hive> show tables;
>  
> I am also sending you my configuration files of Hive conf directory.
>  
> Please help me.
>  
> Regards,
> Ajit Kumar Shreevastava
> 
> 
> ::DISCLAIMER::
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, 
> lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents 
> (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. 
> Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the 
> views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, 
> distribution and / or publication of this message without the prior written consent of authorized representative of 
> HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. 
> Before opening any email and/or attachments, please check them for viruses and other defects.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> 
> 
> 
> -- 
> Bertrand Dechoux
> 
> ______________________________________________________________________
> Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data. If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

RE: New Learner for Haddop and Hive

["Babu, Prashanth" <Pr...@nttdata.com>]

Ajit,

Please follow the guidelines as mentioned by Bertrand.

Apart from that, What is the output of
hive> show tables;

Does it display anything?
If not, what is the message or stacktrace you see on the console?

Also, post your Hadoop Environment details like what is the version of Hadoop, Hive, etc you are using etc and also the OS info, which will help the community to understand the issue better.


From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
Sent: Wednesday, September 05, 2012 3:07 PM
To: user@hive.apache.org
Cc: user@hadoop.apache.org; hdfs-user
Subject: Re: New Learner for Haddop and Hive


1) First do not post across multiple mailing list. I am replying to all in order to share my answer but you should then reply only on the mailing list which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org<ma...@hadoop.apache.org>
3) Does your hive installation work? If not, ask user@hive.apache.org<ma...@hive.apache.org>
4) Explain your problem : " I got nothing" and no error message won't provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki : https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand
On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <Aj...@hcl.com>> wrote:
Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.
----------------------------------------------------------------------------------------------------------------------------------------------------



--
Bertrand Dechoux

______________________________________________________________________
Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data.  If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

RE: New Learner for Haddop and Hive

["Babu, Prashanth" <Pr...@nttdata.com>]

Ajit,

Please follow the guidelines as mentioned by Bertrand.

Apart from that, What is the output of
hive> show tables;

Does it display anything?
If not, what is the message or stacktrace you see on the console?

Also, post your Hadoop Environment details like what is the version of Hadoop, Hive, etc you are using etc and also the OS info, which will help the community to understand the issue better.


From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
Sent: Wednesday, September 05, 2012 3:07 PM
To: user@hive.apache.org
Cc: user@hadoop.apache.org; hdfs-user
Subject: Re: New Learner for Haddop and Hive


1) First do not post across multiple mailing list. I am replying to all in order to share my answer but you should then reply only on the mailing list which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org<ma...@hadoop.apache.org>
3) Does your hive installation work? If not, ask user@hive.apache.org<ma...@hive.apache.org>
4) Explain your problem : " I got nothing" and no error message won't provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki : https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand
On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <Aj...@hcl.com>> wrote:
Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.
----------------------------------------------------------------------------------------------------------------------------------------------------



--
Bertrand Dechoux

______________________________________________________________________
Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data.  If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

RE: New Learner for Haddop and Hive

["Babu, Prashanth" <Pr...@nttdata.com>]

Ajit,

Please follow the guidelines as mentioned by Bertrand.

Apart from that, What is the output of
hive> show tables;

Does it display anything?
If not, what is the message or stacktrace you see on the console?

Also, post your Hadoop Environment details like what is the version of Hadoop, Hive, etc you are using etc and also the OS info, which will help the community to understand the issue better.


From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
Sent: Wednesday, September 05, 2012 3:07 PM
To: user@hive.apache.org
Cc: user@hadoop.apache.org; hdfs-user
Subject: Re: New Learner for Haddop and Hive


1) First do not post across multiple mailing list. I am replying to all in order to share my answer but you should then reply only on the mailing list which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org<ma...@hadoop.apache.org>
3) Does your hive installation work? If not, ask user@hive.apache.org<ma...@hive.apache.org>
4) Explain your problem : " I got nothing" and no error message won't provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki : https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand
On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <Aj...@hcl.com>> wrote:
Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.
----------------------------------------------------------------------------------------------------------------------------------------------------



--
Bertrand Dechoux

______________________________________________________________________
Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data.  If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

RE: New Learner for Haddop and Hive

["Babu, Prashanth" <Pr...@nttdata.com>]

Ajit,

Please follow the guidelines as mentioned by Bertrand.

Apart from that, What is the output of
hive> show tables;

Does it display anything?
If not, what is the message or stacktrace you see on the console?

Also, post your Hadoop Environment details like what is the version of Hadoop, Hive, etc you are using etc and also the OS info, which will help the community to understand the issue better.


From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
Sent: Wednesday, September 05, 2012 3:07 PM
To: user@hive.apache.org
Cc: user@hadoop.apache.org; hdfs-user
Subject: Re: New Learner for Haddop and Hive


1) First do not post across multiple mailing list. I am replying to all in order to share my answer but you should then reply only on the mailing list which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org<ma...@hadoop.apache.org>
3) Does your hive installation work? If not, ask user@hive.apache.org<ma...@hive.apache.org>
4) Explain your problem : " I got nothing" and no error message won't provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki : https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand
On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <Aj...@hcl.com>> wrote:
Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.
----------------------------------------------------------------------------------------------------------------------------------------------------



--
Bertrand Dechoux

______________________________________________________________________
Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data.  If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

RE: New Learner for Haddop and Hive

["Babu, Prashanth" <Pr...@nttdata.com>]

Ajit,

Please follow the guidelines as mentioned by Bertrand.

Apart from that, What is the output of
hive> show tables;

Does it display anything?
If not, what is the message or stacktrace you see on the console?

Also, post your Hadoop Environment details like what is the version of Hadoop, Hive, etc you are using etc and also the OS info, which will help the community to understand the issue better.


From: Bertrand Dechoux [mailto:dechouxb@gmail.com]
Sent: Wednesday, September 05, 2012 3:07 PM
To: user@hive.apache.org
Cc: user@hadoop.apache.org; hdfs-user
Subject: Re: New Learner for Haddop and Hive


1) First do not post across multiple mailing list. I am replying to all in order to share my answer but you should then reply only on the mailing list which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org<ma...@hadoop.apache.org>
3) Does your hive installation work? If not, ask user@hive.apache.org<ma...@hive.apache.org>
4) Explain your problem : " I got nothing" and no error message won't provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki : https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand
On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <Aj...@hcl.com>> wrote:
Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697<ma...@hclt-40124697> ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.
----------------------------------------------------------------------------------------------------------------------------------------------------



--
Bertrand Dechoux

______________________________________________________________________
Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data.  If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

Re: New Learner for Haddop and Hive

[Bertrand Dechoux <de...@gmail.com>]

1) First do not post across multiple mailing list. I am replying to all in
order to share my answer but you should then reply only on the mailing list
which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
3) Does your hive installation work? If not, ask user@hive.apache.org
4) Explain your problem : " I got nothing" and no error message won't
provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki :
https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand

On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <
Ajit.Shreevastava@hcl.com> wrote:

> Hi All,****
>
> ** **
>
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “
> The process for setting Hadoop and Hive to start and work”. I have visited
> lots of site and do the configuration according to that. ****
>
> Now I want run Hive after starting all the services of hadoop,  I got
> nothing.****
>
> ** **
>
> Ajit.Shreevastava@hclt-40124697 ~****
>
> $ start-all.sh****
>
> starting namenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out**
> **
>
> localhost: starting datanode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out**
> **
>
> localhost: starting secondarynamenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> ****
>
> starting jobtracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> ****
>
> localhost: starting tasktracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
> ****
>
> ** **
>
> Ajit.Shreevastava@hclt-40124697 ~****
>
> $ hive****
>
> Logging initialized using configuration in
> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> ****
>
> Hive history
> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> ****
>
> hive> show tables;****
>
> ** **
>
> I am also sending you my configuration files of Hive conf directory.****
>
> ** **
>
> Please help me.****
>
> ** **
>
> Regards,****
>
> Ajit Kumar Shreevastava****
>
>
>
> ::DISCLAIMER::
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as
> information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in
> transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability
> on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the
> author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior
> written consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error
> please delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses
> and other defects.
>
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>



-- 
Bertrand Dechoux

Re: New Learner for Haddop and Hive

[Bertrand Dechoux <de...@gmail.com>]

1) First do not post across multiple mailing list. I am replying to all in
order to share my answer but you should then reply only on the mailing list
which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
3) Does your hive installation work? If not, ask user@hive.apache.org
4) Explain your problem : " I got nothing" and no error message won't
provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki :
https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand

On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <
Ajit.Shreevastava@hcl.com> wrote:

> Hi All,****
>
> ** **
>
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “
> The process for setting Hadoop and Hive to start and work”. I have visited
> lots of site and do the configuration according to that. ****
>
> Now I want run Hive after starting all the services of hadoop,  I got
> nothing.****
>
> ** **
>
> Ajit.Shreevastava@hclt-40124697 ~****
>
> $ start-all.sh****
>
> starting namenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out**
> **
>
> localhost: starting datanode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out**
> **
>
> localhost: starting secondarynamenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> ****
>
> starting jobtracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> ****
>
> localhost: starting tasktracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
> ****
>
> ** **
>
> Ajit.Shreevastava@hclt-40124697 ~****
>
> $ hive****
>
> Logging initialized using configuration in
> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> ****
>
> Hive history
> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> ****
>
> hive> show tables;****
>
> ** **
>
> I am also sending you my configuration files of Hive conf directory.****
>
> ** **
>
> Please help me.****
>
> ** **
>
> Regards,****
>
> Ajit Kumar Shreevastava****
>
>
>
> ::DISCLAIMER::
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as
> information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in
> transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability
> on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the
> author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior
> written consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error
> please delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses
> and other defects.
>
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>



-- 
Bertrand Dechoux

Re: New Learner for Haddop and Hive

[Bertrand Dechoux <de...@gmail.com>]

1) First do not post across multiple mailing list. I am replying to all in
order to share my answer but you should then reply only on the mailing list
which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
3) Does your hive installation work? If not, ask user@hive.apache.org
4) Explain your problem : " I got nothing" and no error message won't
provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki :
https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand

On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <
Ajit.Shreevastava@hcl.com> wrote:

> Hi All,****
>
> ** **
>
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “
> The process for setting Hadoop and Hive to start and work”. I have visited
> lots of site and do the configuration according to that. ****
>
> Now I want run Hive after starting all the services of hadoop,  I got
> nothing.****
>
> ** **
>
> Ajit.Shreevastava@hclt-40124697 ~****
>
> $ start-all.sh****
>
> starting namenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out**
> **
>
> localhost: starting datanode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out**
> **
>
> localhost: starting secondarynamenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> ****
>
> starting jobtracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> ****
>
> localhost: starting tasktracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
> ****
>
> ** **
>
> Ajit.Shreevastava@hclt-40124697 ~****
>
> $ hive****
>
> Logging initialized using configuration in
> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> ****
>
> Hive history
> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> ****
>
> hive> show tables;****
>
> ** **
>
> I am also sending you my configuration files of Hive conf directory.****
>
> ** **
>
> Please help me.****
>
> ** **
>
> Regards,****
>
> Ajit Kumar Shreevastava****
>
>
>
> ::DISCLAIMER::
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as
> information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in
> transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability
> on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the
> author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior
> written consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error
> please delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses
> and other defects.
>
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>



-- 
Bertrand Dechoux

Re: New Learner for Haddop and Hive

[Bertrand Dechoux <de...@gmail.com>]

1) First do not post across multiple mailing list. I am replying to all in
order to share my answer but you should then reply only on the mailing list
which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
3) Does your hive installation work? If not, ask user@hive.apache.org
4) Explain your problem : " I got nothing" and no error message won't
provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki :
https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand

On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <
Ajit.Shreevastava@hcl.com> wrote:

> Hi All,****
>
> ** **
>
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “
> The process for setting Hadoop and Hive to start and work”. I have visited
> lots of site and do the configuration according to that. ****
>
> Now I want run Hive after starting all the services of hadoop,  I got
> nothing.****
>
> ** **
>
> Ajit.Shreevastava@hclt-40124697 ~****
>
> $ start-all.sh****
>
> starting namenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out**
> **
>
> localhost: starting datanode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out**
> **
>
> localhost: starting secondarynamenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> ****
>
> starting jobtracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> ****
>
> localhost: starting tasktracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
> ****
>
> ** **
>
> Ajit.Shreevastava@hclt-40124697 ~****
>
> $ hive****
>
> Logging initialized using configuration in
> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> ****
>
> Hive history
> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> ****
>
> hive> show tables;****
>
> ** **
>
> I am also sending you my configuration files of Hive conf directory.****
>
> ** **
>
> Please help me.****
>
> ** **
>
> Regards,****
>
> Ajit Kumar Shreevastava****
>
>
>
> ::DISCLAIMER::
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as
> information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in
> transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability
> on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the
> author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior
> written consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error
> please delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses
> and other defects.
>
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>



-- 
Bertrand Dechoux

Re: New Learner for Haddop and Hive

[Bertrand Dechoux <de...@gmail.com>]

1) First do not post across multiple mailing list. I am replying to all in
order to share my answer but you should then reply only on the mailing list
which is concerned with your issue.
2) Does you hadoop installation work? If not, ask user@hadoop.apache.org
3) Does your hive installation work? If not, ask user@hive.apache.org
4) Explain your problem : " I got nothing" and no error message won't
provide you any good feedback.
6) Hive installation is pretty well explained in the hive wiki :
https://cwiki.apache.org/confluence/display/Hive/Home

Regards

Bertrand

On Wed, Sep 5, 2012 at 11:14 AM, Ajit Kumar Shreevastava <
Ajit.Shreevastava@hcl.com> wrote:

> Hi All,****
>
> ** **
>
> I am new for Hive and Hadoop Technology. Can anyone tell me in detail “
> The process for setting Hadoop and Hive to start and work”. I have visited
> lots of site and do the configuration according to that. ****
>
> Now I want run Hive after starting all the services of hadoop,  I got
> nothing.****
>
> ** **
>
> Ajit.Shreevastava@hclt-40124697 ~****
>
> $ start-all.sh****
>
> starting namenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out**
> **
>
> localhost: starting datanode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out**
> **
>
> localhost: starting secondarynamenode, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
> ****
>
> starting jobtracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
> ****
>
> localhost: starting tasktracker, logging to
> /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out
> ****
>
> ** **
>
> Ajit.Shreevastava@hclt-40124697 ~****
>
> $ hive****
>
> Logging initialized using configuration in
> jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
> ****
>
> Hive history
> file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
> ****
>
> hive> show tables;****
>
> ** **
>
> I am also sending you my configuration files of Hive conf directory.****
>
> ** **
>
> Please help me.****
>
> ** **
>
> Regards,****
>
> Ajit Kumar Shreevastava****
>
>
>
> ::DISCLAIMER::
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as
> information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in
> transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability
> on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the
> author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior
> written consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error
> please delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses
> and other defects.
>
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>



-- 
Bertrand Dechoux

New Learner for Haddop and Hive

[Ajit Kumar Shreevastava <Aj...@hcl.com>]

Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697 ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697 ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

Re: Improving query performance on hive and hdfs

[Bertrand Dechoux <de...@gmail.com>]

It would be interesting to know the size of the data, how it is stored
within Hive and what kind of query you run on it.

Typically, 90 000 000 records could be less than 64 Mo and could even be
all loaded into memory. In that case, yes, it is not astonishing that
alternatives could outperform Hadoop.

If you are using regexes in order to parse the line (row format), there
could be a point of improvement there.

Then again depending on the query (multiple joins? group by?), that could
have a huge impact too.

Regards

Bertrand

On Wed, Sep 5, 2012 at 8:28 AM, MiaoMiao <li...@gmail.com> wrote:

> Your store 90 million records in DB? What kind?
>
> Sure there are some optimizations to speed up hive query, but I don't
> see a universal one, except adding more servers.
>
> On Wed, Sep 5, 2012 at 2:19 PM, iwannaplay games
> <fu...@gmail.com> wrote:
> > Hi all,
> >
> > I ran a query on hive on top of 90 million records that took 12 minutes
> to
> > execute and same query on sql server took 8 minutes.My question is how
> can i
> > make hadoop's performance better.What all configurations will improve the
> > latency?
> >
> > Thanks & Regards
> > Prabhjot
>



-- 
Bertrand Dechoux

Re: Improving query performance on hive and hdfs

[MiaoMiao <li...@gmail.com>]

Your store 90 million records in DB? What kind?

Sure there are some optimizations to speed up hive query, but I don't
see a universal one, except adding more servers.

On Wed, Sep 5, 2012 at 2:19 PM, iwannaplay games
<fu...@gmail.com> wrote:
> Hi all,
>
> I ran a query on hive on top of 90 million records that took 12 minutes to
> execute and same query on sql server took 8 minutes.My question is how can i
> make hadoop's performance better.What all configurations will improve the
> latency?
>
> Thanks & Regards
> Prabhjot

New Learner for Haddop and Hive

[Ajit Kumar Shreevastava <Aj...@hcl.com>]

Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697 ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697 ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

New Learner for Haddop and Hive

[Ajit Kumar Shreevastava <Aj...@hcl.com>]

Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697 ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697 ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

Re: Improving query performance on hive and hdfs

[Vasco Visser <va...@gmail.com>]

You know that Hadoop is not designed for low latency. To say anything
useful I think you should share some more details:

- What query are you launching (does it have join/group by)
- How many mappers/reducers and jobs does the query spawn
- How does your data look like
- Also what version of Hadoop are you running, etc

Some things that are applicable depending on the things above
- Check if you can partition your data so that Hive can do partition pruning.
- If your query has joins then look at
https://cwiki.apache.org/Hive/languagemanual-joins.html (bottom of
page) to see how to organize your data to let Hive do a map side join.
- Try to play with the config option
mapreduce.job.reduce.slowstart.completedmaps, this can help you if you
have a lot of idle reducers in the map phase.
- I would try to limit the number of task per node to the number of
CPUs on the system, but I don't know if this is common practice.

On Wed, Sep 5, 2012 at 8:19 AM, iwannaplay games
<fu...@gmail.com> wrote:
> Hi all,
>
> I ran a query on hive on top of 90 million records that took 12 minutes to
> execute and same query on sql server took 8 minutes.My question is how can i
> make hadoop's performance better.What all configurations will improve the
> latency?
>
> Thanks & Regards
> Prabhjot

New Learner for Haddop and Hive

[Ajit Kumar Shreevastava <Aj...@hcl.com>]

Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697 ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697 ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

Re: Improving query performance on hive and hdfs

[Vasco Visser <va...@gmail.com>]

You know that Hadoop is not designed for low latency. To say anything
useful I think you should share some more details:

- What query are you launching (does it have join/group by)
- How many mappers/reducers and jobs does the query spawn
- How does your data look like
- Also what version of Hadoop are you running, etc

Some things that are applicable depending on the things above
- Check if you can partition your data so that Hive can do partition pruning.
- If your query has joins then look at
https://cwiki.apache.org/Hive/languagemanual-joins.html (bottom of
page) to see how to organize your data to let Hive do a map side join.
- Try to play with the config option
mapreduce.job.reduce.slowstart.completedmaps, this can help you if you
have a lot of idle reducers in the map phase.
- I would try to limit the number of task per node to the number of
CPUs on the system, but I don't know if this is common practice.

On Wed, Sep 5, 2012 at 8:19 AM, iwannaplay games
<fu...@gmail.com> wrote:
> Hi all,
>
> I ran a query on hive on top of 90 million records that took 12 minutes to
> execute and same query on sql server took 8 minutes.My question is how can i
> make hadoop's performance better.What all configurations will improve the
> latency?
>
> Thanks & Regards
> Prabhjot

Re: Improving query performance on hive and hdfs

[Vasco Visser <va...@gmail.com>]

You know that Hadoop is not designed for low latency. To say anything
useful I think you should share some more details:

- What query are you launching (does it have join/group by)
- How many mappers/reducers and jobs does the query spawn
- How does your data look like
- Also what version of Hadoop are you running, etc

Some things that are applicable depending on the things above
- Check if you can partition your data so that Hive can do partition pruning.
- If your query has joins then look at
https://cwiki.apache.org/Hive/languagemanual-joins.html (bottom of
page) to see how to organize your data to let Hive do a map side join.
- Try to play with the config option
mapreduce.job.reduce.slowstart.completedmaps, this can help you if you
have a lot of idle reducers in the map phase.
- I would try to limit the number of task per node to the number of
CPUs on the system, but I don't know if this is common practice.

On Wed, Sep 5, 2012 at 8:19 AM, iwannaplay games
<fu...@gmail.com> wrote:
> Hi all,
>
> I ran a query on hive on top of 90 million records that took 12 minutes to
> execute and same query on sql server took 8 minutes.My question is how can i
> make hadoop's performance better.What all configurations will improve the
> latency?
>
> Thanks & Regards
> Prabhjot

Re: Improving query performance on hive and hdfs

[Vasco Visser <va...@gmail.com>]

You know that Hadoop is not designed for low latency. To say anything
useful I think you should share some more details:

- What query are you launching (does it have join/group by)
- How many mappers/reducers and jobs does the query spawn
- How does your data look like
- Also what version of Hadoop are you running, etc

Some things that are applicable depending on the things above
- Check if you can partition your data so that Hive can do partition pruning.
- If your query has joins then look at
https://cwiki.apache.org/Hive/languagemanual-joins.html (bottom of
page) to see how to organize your data to let Hive do a map side join.
- Try to play with the config option
mapreduce.job.reduce.slowstart.completedmaps, this can help you if you
have a lot of idle reducers in the map phase.
- I would try to limit the number of task per node to the number of
CPUs on the system, but I don't know if this is common practice.

On Wed, Sep 5, 2012 at 8:19 AM, iwannaplay games
<fu...@gmail.com> wrote:
> Hi all,
>
> I ran a query on hive on top of 90 million records that took 12 minutes to
> execute and same query on sql server took 8 minutes.My question is how can i
> make hadoop's performance better.What all configurations will improve the
> latency?
>
> Thanks & Regards
> Prabhjot

New Learner for Haddop and Hive

[Ajit Kumar Shreevastava <Aj...@hcl.com>]

Hi All,

I am new for Hive and Hadoop Technology. Can anyone tell me in detail " The process for setting Hadoop and Hive to start and work". I have visited lots of site and do the configuration according to that.
Now I want run Hive after starting all the services of hadoop,  I got nothing.

Ajit.Shreevastava@hclt-40124697 ~
$ start-all.sh
starting namenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-namenode-hclt-40124697.out
localhost: starting datanode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-datanode-hclt-40124697.out
localhost: starting secondarynamenode, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-secondarynamenode-hclt-40124697.out
starting jobtracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-jobtracker-hclt-40124697.out
localhost: starting tasktracker, logging to /usr/local/hadoop/bin/../logs/hadoop-MYHADOOP-tasktracker-hclt-40124697.out

Ajit.Shreevastava@hclt-40124697 ~
$ hive
Logging initialized using configuration in jar:file:/C:/cygwin/usr/local/hadoop/hive/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/ajit.shreevastava/hive_job_log_ajit.shreevastava_201209051440_1301558122.txt
hive> show tables;

I am also sending you my configuration files of Hive conf directory.

Please help me.

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------