Mailing-List: contact user-help@giraph.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@giraph.apache.org
Received-SPF: pass (athena.apache.org: domain of claudio.martella@gmail.com
 designates 209.85.128.175 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAKTs02uj2Oju-oxVKwgh4OvBLKTrkgNLwtHk=vyKqHiRSKTw-A@mail.gmail.com>
References: 
 <CAKTs02uj2Oju-oxVKwgh4OvBLKTrkgNLwtHk=vyKqHiRSKTw-A@mail.gmail.com>
From: Claudio Martella <claudio.martella@gmail.com>
Date: Fri, 6 Sep 2013 09:42:35 +0200
Message-ID: 
 <CAFJOoJcwjsJLXEHUcndLzPbLe8iUnDC60MUkk4eFrRrWfUhn2g@mail.gmail.com>
Subject: Re: MySQL Table
To: "user@giraph.apache.org" <user@giraph.apache.org>
Content-Type: multipart/alternative; boundary=089e013a132acedb5704e5b22f1b

--089e013a132acedb5704e5b22f1b
Content-Type: text/plain; charset=ISO-8859-1

Hi Bu,

no, currently we do not have a DBInputFormat. We have an open issue with a
google summer of code student working on a GoraInputFormat, which supports
also reading from RDBMs through Gora. However, if/when it will get it, it
will not provide a rich semantic as DBInputFormat, e.g. you'll be able to
only provide scan-like/range queries, instead of ANY query like
DBInputFormat.

I think that creating an DB[Vertex|Edge]InputFormat starting from the
hadoop DBInputFormat should not be too hard and could prove to be a very
useful contribution. If you think about providing an implementation, I can
provide guidance.

Best,
Claudio


On Fri, Sep 6, 2013 at 1:45 AM, Bu Xiao <buxiao82@gmail.com> wrote:

> Hi Girapher,
>
>        I am currently working on algorithm that requires reading the
> vertices from MySQL table and not from HDFS. I thought that there has to be
> a way of reading data from SQL table since Giraph is built on top of
> Hadoop. But I do not seem to figure this part out. Do you have a class
> similar to the DBInputFormat in Hadoop? Thank you very much for your help.
>
>
>


-- 
   Claudio Martella
   claudio.martella@gmail.com

--089e013a132acedb5704e5b22f1b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Bu,<div><br></div><div>no, currently we do not have a D=
BInputFormat. We have an open issue with a google summer of code student wo=
rking on a GoraInputFormat, which supports also reading from RDBMs through =
Gora. However, if/when it will get it, it will not provide a rich semantic =
as DBInputFormat, e.g. you&#39;ll be able to only provide scan-like/range q=
ueries, instead of ANY query like DBInputFormat.</div>

<div><br></div><div>I think that creating an DB[Vertex|Edge]InputFormat sta=
rting from the hadoop DBInputFormat should not be too hard and could prove =
to be a very useful contribution. If you think about providing an implement=
ation, I can provide guidance.</div>

<div><br></div><div>Best,</div><div>Claudio</div></div><div class=3D"gmail_=
extra"><br><br><div class=3D"gmail_quote">On Fri, Sep 6, 2013 at 1:45 AM, B=
u Xiao <span dir=3D"ltr">&lt;<a href=3D"mailto:buxiao82@gmail.com" target=
=3D"_blank">buxiao82@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi Girapher,<div><br></div>=
<div>=A0 =A0 =A0 =A0I am currently working on algorithm that requires readi=
ng the vertices from MySQL table and not from HDFS. I thought that there ha=
s to be a way of reading data from SQL table since Giraph is built on top o=
f Hadoop. But I do not seem to figure this part out. Do you have a class si=
milar to the DBInputFormat in Hadoop? Thank you very much for your help.</d=
iv>


<div><br></div><div><br></div></div>
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br> =A0 =A0Clau=
dio Martella<br> =A0 =A0<a href=3D"mailto:claudio.martella@gmail.com" targe=
t=3D"_blank">claudio.martella@gmail.com</a>=A0 =A0
</div>

--089e013a132acedb5704e5b22f1b--