Hi Vinayak, If you have Mahout installed in a Hadoop cluster then you can stream the data from your MySQL server to HDFS using Sqoop ( http://sqoop.apache.org/docs/1.4.3/SqoopUserGuide.html) as suggested by Andrew.
Otherwise you can create a MySQLJDBC data model and directly use it from within Mahout: http://archive.cloudera.com/cdh4/cdh/4/mahout-0.7-cdh4.6.0/mahout-integration/org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html . -- Warunika On Wed, Jun 25, 2014 at 11:45 AM, Andrew Musselman < [email protected]> wrote: > Mahout can't read directly out of MySQL. > > First bring data into HDFS/Hive using something like Sqoop as per: > http://sqoop.apache.org > > > On Jun 24, 2014, at 11:04 PM, vinayakb malagatti < > [email protected]> wrote: > > > > i am using apache mahout and i want read the table contents form the db > > > > Thanks and Regards, > > Vinayak B > > > > > > > > On Wed, Jun 25, 2014 at 11:31 AM, venkata ramana < > > [email protected]> wrote: > > > >> Hi Vinayak, > >> > >> This is not mysql mailing list. Which operating system do you use ? > based > >> on your operating system (win/Linux/Fedora) you can down load mysql and > use > >> it. > >> > >> thanks, > >> Venkat > >> > >> > >> > >> On Wed, Jun 25, 2014 at 11:17 AM, vinayakb malagatti < > >> [email protected]> wrote: > >> > >>> hi, > >>> > >>> how to connect to MySql DB and read the table contents. > >>> Thanks and Regards, > >>> Vinayak B > >> >
