>>
>>> - ssh -i /path/on/your/desktop/to/amazonkeypair.pem hadoop@
>>> .compute.amazonaws.com
>>>
>>> - One the linux prompt
>>>--> hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS songs(id INT,
>>> SEQID INT, LASTNAME STRI
able for specifically Hive Training. I read alots
>>> of tutorial on net, but still not able to co-relate the file which is
>>> stored on the hadoop cluster and how the hive actually works. The complete
>>> end to end transaction and its storage.Can you take some class on the pay
>
Hi there,
To analyze the data you need to load the data file into hive first.this
will be done by creating a table(CREATE TABLE) and loading the file
data(LOAD DATA) into the table according to your requirement.
Actually the data is still stored in HDFS itself, you can go to
user/hive/warehouse d
MITED FIELDS TERMINATED BY ',' "
> --> hive -e "select songname from songs where lastname='lennon' OR
> lastname = 'harrison'"
>
> Hope this helps
>
> Hive on !!!
>
> sanjay
>
>
>
>
>
>
>id,seq,
will not be
tough to understand the hiveQL.
Thanks
Prashant
From: Subramanian, Sanjay (HQP) [mailto:sanjay.subraman...@roberthalf.com]
Sent: Monday, January 13, 2014 1:01 PM
To: user@hive.apache.org; Prashant Kumar - ERS, HCL Tech
Subject: RE: One information about the Hive
Hi Vikas
Welcome to
7;"
Hope this helps
Hive on !!!
sanjay
id,seq,lastname,firstname,songname
From: Vikas Parashar [para.vi...@gmail.com]
Sent: Sunday, January 12, 2014 10:50 PM
To: Prashant Kumar - ERS, HCL Tech
Cc: user@hive.apache.org
Subject: Re: One information about t
;
>
>
> *From:* Vikas Parashar [mailto:para.vi...@gmail.com]
> *Sent:* Monday, January 13, 2014 11:07 AM
> *To:* user@hive.apache.org
> *Subject:* Re: One information about the Hive
>
>
>
> Prashant,
>
>
>
>
>
> I am new to Hive, I am reading the doc whi
Prashant,
> I am new to Hive, I am reading the doc which is available on Apache site
> and try to create a correlation between hadoop and Hive. so please help me
> to understand this:
>
> As per my understanding, all the files where unstructured data are stored
> in HDFS system across the hadoop
Hi,
I am new to Hive, I am reading the doc which is available on Apache site and
try to create a correlation between hadoop and Hive. so please help me to
understand this:
As per my understanding, all the files where unstructured data are stored in
HDFS system across the hadoop cluster. Now whe