Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
  b=K9rtmpe9R1DuAV2mIqGHBL4BnNup8MSpMQI2lo6kvlMGr/YijPN0fAxsHY1rzuOgU20tzKRdnKY4Rl0PKXYaEwjaNAJv4NafQVfO82jN3vNEhqWQqnWJdSp7t8YAyBufvPt1oYjIYg0xPa7NDZvpy6y3yPiDegWRfTMt6kHg3ro=;
Message-ID: <541945.93319.qm@web121220.mail.ne1.yahoo.com>
Date: Mon, 21 Feb 2011 06:53:58 -0800 (PST)
From: Bejoy Ks <bejoy_ks@yahoo.com>
Subject: Database/Schema , INTERVAL and SQL IN  usages in Hive
To: user@hive.apache.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1325106477-1298300038=:93319"

--0-1325106477-1298300038=:93319
Content-Type: text/plain; charset=us-ascii

Hi Experts
     I'm using hive for a few projects and i found it a great tool in hadoop to 
process end to end structured data. Unfortunately I'm facing a few challenges 
out here as follows

Availability of database/schemas in Hive
I'm having multiple projects running in hive each having fairly large number of 
tables. With this much tables all together it is  looking a bit  messed up. Is 
there any option of creating database/schema in Hive so that I can maintain the 
tables in different databases/schemas corresponding to each project.

Using INTERVAL 
    I need to replicate a job running in Teradata edw into hive, i'm facing a 
challenge out here.Not able to identify a similar usage corresponding to 
Interval in teradata within hive. Here is the snippet where I'm facing the issue
 *** where 1.seq_id = r4.seq_id and r4.mc_datetime >= (r1.rc_datetime + INTERVAL 
'05' HOUR)
In this query how do i replicate the last part in hive ie (r1.rc_datetime + 
INTERVAL '05' HOUR) , where it is adding 5 hours to the obtained time stamp 
rc_datetime.
*The where condition is part of a very large query involving multiple table 
joins.


Using IN 
    How do we replicate the SQL IN function in hive
ie *** where R1.seq_id = r4.seq_id and r1.PROCCESS_PHASE IN ( 'Production', 
'Stage' , 'QA', 'Development')
the last part of the query is where i'm facing the challenge r1.PROCCESS_PHASE 
IN ( 'Production', 'Stage' , 'QA', 'Development')
*The where condition is part of a very large query involving multiple table 
joins.

Please advise.

Regards
Bejoy KS


--0-1325106477-1298300038=:93319
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Hi Experts<br>&nbsp;&nbsp;&nbsp;&nbsp; I'm using hive for a few projects and i found it a great tool in hadoop to process end to end structured data. Unfortunately I'm facing a few challenges out here as follows<br><br><span style="font-weight: bold;">Availability of database/schemas in Hive</span><br>I'm having multiple projects running in hive each having fairly large number of tables. With this much tables all together it is&nbsp; looking a bit&nbsp; messed up. Is there any option of creating database/schema in Hive so that I can maintain the tables in different databases/schemas corresponding to each project.<br><br><span style="font-weight: bold;">Using INTERVAL </span><br>&nbsp;&nbsp;&nbsp; I need to replicate a job running in Teradata edw into hive, i'm facing a challenge out here.Not
 able to identify a similar usage corresponding to Interval in teradata within hive. Here is the snippet where I'm facing the issue<br>&nbsp;*** where 1.seq_id = r4.seq_id and r4.mc_datetime &gt;= (r1.rc_datetime + INTERVAL '05' HOUR)<br>In this query how do i replicate the last part in hive ie (r1.rc_datetime + INTERVAL '05' HOUR) , where it is adding 5 hours to the obtained time stamp rc_datetime.<br>*The where condition is part of a very large query involving multiple table joins.<br><br><br><span style="font-weight: bold;">Using IN </span><br>&nbsp;&nbsp;&nbsp; How do we replicate the SQL IN function in hive<br>ie *** where R1.seq_id = r4.seq_id and r1.PROCCESS_PHASE IN ( 'Production', 'Stage' , 'QA', 'Development')<br>the last part of the query is where i'm facing the challenge r1.PROCCESS_PHASE IN ( 'Production', 'Stage' , 'QA', 'Development')<br>*The where condition is part of a very large query involving multiple table joins.<br><br>Please
 advise.<br><br>Regards<br>Bejoy KS<br><br><br><br><br><br><br></div>
</div><br>

      </body></html>
--0-1325106477-1298300038=:93319--