Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hadoop.apache.org
Received-SPF: pass (athena.apache.org: domain of dcarol@blitzbs.com designates
 209.85.212.179 as permitted sender)
Message-ID: <5416F270.7070005@blitzbs.com>
Date: Mon, 15 Sep 2014 16:06:40 +0200
From: Damien Carol <dcarol@blitzbs.com>
Organization: BLITZ B.S.
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: user@hadoop.apache.org
Subject: Re: Migrate hive metastore from mysql to oracle
References: <DA517018-BE01-4E08-913E-5A21448A6039@apple.com>
In-Reply-To: <DA517018-BE01-4E08-913E-5A21448A6039@apple.com>
Content-Type: multipart/mixed;
 boundary="------------020404060809090106000804"

This is a multi-part message in MIME format.
--------------020404060809090106000804
Content-Type: multipart/alternative;
 boundary="------------040304050503060103060308"


--------------040304050503060103060308
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

We use postgres for metastore. HIVE metastore only work with mysql. You 
need a patch.

Can you check this patch : https://issues.apache.org/jira/browse/HIVE-7689 ?

Also, could you use user@hive.apache.org <mailto:user@hive.apache.org> 
instead of this Hadoop One ?

Regards,

Damien CAROL

  * t�l : +33 (0)4 74 96 88 14
  * fax : +33 (0)4 74 96 31 88
  * email :dcarol@blitzbs.com <mailto:dcarol@blitzbs.com>

BLITZ BUSINESS SERVICE

Le 15/09/2014 10:55, Vikas Srivastava a �crit :
> Hi Folks,
>
> I have one requirement where we need to switch the hive-metastore database from mysql to oracle db, is there anyone who has performed this.
>
> any link and doc would be appreciated.
>
> thanks


--------------040304050503060103060308
Content-Type: multipart/related;
 boundary="------------030800080909020704000906"


--------------030800080909020704000906
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Hi,<br>
      <br>
      We use postgres for metastore. HIVE metastore only work with
      mysql. You need a patch.<br>
      <br>
      Can you check this patch :
      <a class="moz-txt-link-freetext" href="https://issues.apache.org/jira/browse/HIVE-7689">https://issues.apache.org/jira/browse/HIVE-7689</a> ?<br>
      <br>
      Also, could you use <a href="mailto:user@hive.apache.org"
        style="color: rgb(16, 126, 192); font-family: Helvetica, Arial,
        'Liberation Sans', FreeSans, sans-serif; font-size: 16px;
        font-style: normal; font-variant: normal; font-weight: normal;
        letter-spacing: normal; line-height: normal; orphans: auto;
        text-align: left; text-indent: 0px; text-transform: none;
        white-space: normal; widows: auto; word-spacing: 0px;
        -webkit-text-stroke-width: 0px;">user@hive.apache.org</a>
      instead of this Hadoop One ?<br>
      <br>
      Regards,<br>
      <br>
      <div class="moz-signature">
        <div style="font-family:Geneva,Helvetica,sans-serif;">
          <p style="font-weight:bold;font-size:12px;color:#333;margin: 0
            0 10px 0;">Damien CAROL</p>
          <ul style="list-style:none;margin:0;padding:0;">
            <li style="font-size:11px;margin:0;padding:0;"><span
                style="color:#999;">t&eacute;l :</span><span style="color:#333">&nbsp;+33
                (0)4 74 96 88 14</span></li>
            <li style="font-size:11px;margin:0;padding:0;"><span
                style="color:#999;">fax :</span><span style="color:#333">&nbsp;+33
                (0)4 74 96 31 88</span></li>
            <li style="font-size:11px;margin:0;padding:0;"><span
                style="color:#999;">email :</span><span
                style="color:#333">&nbsp;<a href="mailto:dcarol@blitzbs.com">dcarol@blitzbs.com</a></span></li>
          </ul>
          <p style="font-family:Geneva,Helvetica,sans-serif;font-size:
            18px;letter-spacing:2px;margin:10px 0 0 0;"><img
              src="cid:part3.00040106.09000102@blitzbs.com"
              style="vertical-align:middle;margin:-3px 5px 0 0"><span
              style="color:#105692;">BLITZ</span>&nbsp;<span
              style="color:#A7A9A9;">BUSINESS SERVICE</span></p>
        </div>
      </div>
      Le 15/09/2014 10:55, Vikas Srivastava a &eacute;crit&nbsp;:<br>
    </div>
    <blockquote
      cite="mid:DA517018-BE01-4E08-913E-5A21448A6039@apple.com"
      type="cite">
      <pre wrap="">Hi Folks,

I have one requirement where we need to switch the hive-metastore database from mysql to oracle db, is there anyone who has performed this.

any link and doc would be appreciated.

thanks
</pre>
    </blockquote>
    <br>
  </body>
</html>

--------------030800080909020704000906
Content-Type: image/png;
 name="gcedjbch.png"
Content-Transfer-Encoding: base64
Content-ID: <part3.00040106.09000102@blitzbs.com>
Content-Disposition: inline;
 filename="gcedjbch.png"

iVBORw0KGgoAAAANSUhEUgAAAC8AAAArCAYAAADottG6AAAAGXRFWHRTb2Z0d2FyZQBBZG9i
ZSBJbWFnZVJlYWR5ccllPAAAAplJREFUeNrsWD1u2zAUJilbTgK4ddoDRDdwbmD3BNGcJZ6s
sT5ABg/Z64zWkmTJ7N7AuYF6gjp7C8hAf9IkEvso04FhUyIjUoKK6gE0DOpR/N6n90ciVEst
tfwzgrXfMJyewO8o+U8jhJ9+hvjpR4BpFMJMwEZ0e7GsHvjhtAe/8515GjMjEH5cwgaUzSy4
IUx3DsZ8qS74DSPIwzeEoz/bT0K+bsZG3i9TLPj1Jg/fEXn+laWyNuLmNduTMgKL7r1HceMg
S8WFcW2dnn+FcVYp8IkBrUNESVOm5nAjrioFHmGC4tY7Ve0BGHBSHfBMLBvF9htVbdcM+OH0
CMZHI+7TbEPyVMoTfVPMT2B0TLkPtdsqmg64zls98Kt06BoN3mZbVfU462FDkXUVmQtyvsM/
v7PDvrUPxeu3iuvc5QM/nJ5JrGeVcpwY6HtLydcbb/px3DxAlhx8R4f5QeZT32M9irxP8T3G
3gce9Ksvae1puw3JYKurEvGvEt+7fCEkcZ2WFvNEJ88KDWYuwlJrugE3vJdRqbi5A7avCLjH
+3l3a37BY+FSsGqUvJ/YWumXSIJRtat0U/qUCeh8ErB/z9inxJIX5dPzozzgZ4Y8fcSN3E3B
xFYqVnnBh4YMGAgzFSZhMW6zytsTQ+DTgj8oyufX1dUE+53ywZtkX+z3YZHMm2TfuMjBr9gf
G9hrhwB2PVI08+uyruWfvA/abo4d2bLo9uJO/xjoe581oAsNx49LJ8+6ss+wwoKHaZzVgixk
XW0Z4ENRxpLcDjD9Y9m1YKME4P2Ug8pIMHfNkgOAvld5eaNgVxmLAhVY7210rSEHPVEF/eJ2
hgpQd6uKBmnHQn4jEGy406yoK3Dz907AOowuqqWWWv4v+SvAAEOE1lCEh8AnAAAAAElFTkSu
QmCC
--------------030800080909020704000906--

--------------040304050503060103060308--

--------------020404060809090106000804
Content-Type: text/x-vcard; charset=utf-8;
 name="dcarol.vcf"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="dcarol.vcf"

bnVsbA==
--------------020404060809090106000804--