You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by komara nagarjuna <ko...@gmail.com> on 2011/04/07 06:00:08 UTC
How To Use Hive
Sir,
I am new to Hadoop and Hive. Now i am developing an application Hadoop
with Hive
in MultiNode cluster. I install and run Hadoop successfully in master and
slave
machines successfully.Hive installed in Master machine and it also
connecting to
database through mysql.
In Hive, I create a table successfully.My problem is how to insert data
to hive tables.
How to communicate Hadoop with Hive.How to use Hive datawarehouse.What is
the
purpose of hive.
Please explain how to use Hive in real time.
*Thanks & Regards*,
*Nagarjuna komara.*
Re: How To Use Hive
Posted by Geoff Howard <ge...@gmail.com>.
Answered on the users list.
On Thu, Apr 7, 2011 at 12:00 AM, komara nagarjuna
<ko...@gmail.com> wrote:
> Sir,
>
> I am new to Hadoop and Hive. Now i am developing an application Hadoop
> with Hive
> in MultiNode cluster. I install and run Hadoop successfully in master and
> slave
> machines successfully.Hive installed in Master machine and it also
> connecting to
> database through mysql.
>
> In Hive, I create a table successfully.My problem is how to insert data
> to hive tables.
> How to communicate Hadoop with Hive.How to use Hive datawarehouse.What is
> the
> purpose of hive.
>
> Please explain how to use Hive in real time.
>
>
> *Thanks & Regards*,
> *Nagarjuna komara.*
>
Re: How To Use Hive
Posted by sangeetha s <sa...@gmail.com>.
Hi,
I agree with Geoff.
Before proceeding further, First, decide whether hive is suitable for your
problem or your project environment. To do that,you should understand the
basics of Hive. Kindly look at the apache wiki suggested by Geoff.
Once you had decided to proceed with Hive, there are several documents and
articles available to explore and program further in Hive.
I would also suggest you to give a look on the the book by Tom White. "Hadoop:
The Definitive Guide" to get a beetre insight of Hadoop and various project
of Apache.
Good Luck!...
On Thu, Apr 7, 2011 at 4:48 PM, Geoff Howard <ge...@gmail.com> wrote:
> Well, I'm new here but I can point you to the docs as well as old
> timers probably. First, I think the developers would prefer that you
> only direct questions like this to the users list, not to both. Other
> answers are inline below:
>
> On Thu, Apr 7, 2011 at 12:00 AM, komara nagarjuna
> <ko...@gmail.com> wrote:
> >
> > In Hive, I create a table successfully.My problem is how to insert data
> > to hive tables.
>
> I can only assume you've not found the documentation on the Wiki.
> There is a big section that covers "loading data" here:
> http://wiki.apache.org/hadoop/Hive/Tutorial and a section called DML
> operations here: http://wiki.apache.org/hadoop/Hive/GettingStarted
>
> I would also highly suggest going through the video tutorial on
> Cloudera's site related to Hadoop, HDFS, and Hive available here:
> http://www.cloudera.com/resources/?type=Training which is all free.
>
> You may really want to consider buying the Hadoop book from O'Reilly
>
> http://www.amazon.com/Hadoop-Definitive-Guide-Tom-White/dp/1449389732/ref=sr_1_1?ie=UTF8&qid=1302174753&sr=8-1
> I've read it (nearly) cover to cover and it is a great resource.
> There is one chapter on Hive, but also good real world cases of how
> Hadoop and Hive are being used. The facebook example is very
> instructive on practical use of Hive.
>
> > How to communicate Hadoop with Hive.
>
> I'm not sure I understand the question. Hive of course uses Hadoop
> natively, and you'll see documented above examples of how to load data
> from HDFS if it is already there.
>
> > How to use Hive datawarehouse.
> > What is the purpose of hive.
>
> These questions are too general to really answer, except that you use
> the "SQL-like" language of HQL to run queries, or you may want to use
> a related project like Sqoop to extract data out to another database
> for use building a datamart or loading into a cube for use in a more
> traditional (and untrained analyst-friendly) tool.
>
> > Please explain how to use Hive in real time.
>
> If by real time you mean incremental inserts, or very low latency
> queries, you need to especially see the "What Hive is NOT" section of
> this page: http://wiki.apache.org/hadoop/Hive
>
> Hope that helps,
> Geoff
>
--
Regards,
Sangita Sundar
Re: How To Use Hive
Posted by Geoff Howard <ge...@gmail.com>.
Well, I'm new here but I can point you to the docs as well as old
timers probably. First, I think the developers would prefer that you
only direct questions like this to the users list, not to both. Other
answers are inline below:
On Thu, Apr 7, 2011 at 12:00 AM, komara nagarjuna
<ko...@gmail.com> wrote:
>
> In Hive, I create a table successfully.My problem is how to insert data
> to hive tables.
I can only assume you've not found the documentation on the Wiki.
There is a big section that covers "loading data" here:
http://wiki.apache.org/hadoop/Hive/Tutorial and a section called DML
operations here: http://wiki.apache.org/hadoop/Hive/GettingStarted
I would also highly suggest going through the video tutorial on
Cloudera's site related to Hadoop, HDFS, and Hive available here:
http://www.cloudera.com/resources/?type=Training which is all free.
You may really want to consider buying the Hadoop book from O'Reilly
http://www.amazon.com/Hadoop-Definitive-Guide-Tom-White/dp/1449389732/ref=sr_1_1?ie=UTF8&qid=1302174753&sr=8-1
I've read it (nearly) cover to cover and it is a great resource.
There is one chapter on Hive, but also good real world cases of how
Hadoop and Hive are being used. The facebook example is very
instructive on practical use of Hive.
> How to communicate Hadoop with Hive.
I'm not sure I understand the question. Hive of course uses Hadoop
natively, and you'll see documented above examples of how to load data
from HDFS if it is already there.
> How to use Hive datawarehouse.
> What is the purpose of hive.
These questions are too general to really answer, except that you use
the "SQL-like" language of HQL to run queries, or you may want to use
a related project like Sqoop to extract data out to another database
for use building a datamart or loading into a cube for use in a more
traditional (and untrained analyst-friendly) tool.
> Please explain how to use Hive in real time.
If by real time you mean incremental inserts, or very low latency
queries, you need to especially see the "What Hive is NOT" section of
this page: http://wiki.apache.org/hadoop/Hive
Hope that helps,
Geoff