I'm pretty sure it works with Mahout 0.9 as well. Assuming that you are using the Mahout single machine implementation, did you import "org.apache.mahout.cf.taste.impl.model.jdbc.MySQLJDBCDataModel"? If it is a compilation error, you should probably import proper libraries and update the pom.xml file.
If you are not that concerned about the performance of your program, then you can even use the ordinary Java MySQL connector. -- Warunika On Wed, Jun 25, 2014 at 12:01 PM, vinayakb malagatti < vinayakbmalaga...@gmail.com> wrote: > i am trying with the > "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 > " > > in 0.9 version but it is not working should i try with 0.7 version > > Thanks and Regards, > Vinayak B > > > > On Wed, Jun 25, 2014 at 11:51 AM, Warunika Ranaweera <warunik...@gmail.com > > > wrote: > > > 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 < > > andrew.mussel...@gmail.com> 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 < > > > vinayakbmalaga...@gmail.com> 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 < > > > > venkat.ecosyst...@gmail.com> 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 < > > > >> vinayakbmalaga...@gmail.com> wrote: > > > >> > > > >>> hi, > > > >>> > > > >>> how to connect to MySql DB and read the table contents. > > > >>> Thanks and Regards, > > > >>> Vinayak B > > > >> > > > > > >
