Hive isn't really a replacement for mysql. Please read about hive and big data. The use cases for hive are quite different as compared to the use cass for mysql. Mysql is for real time ad-hoc queries, like showing some information on a webpage or search results. MySQL is a relational database, supports ACID properties, hive doesn't .MySQL tables perform well for upto millions of rows, hive is generally used for much much more than that.
Hive is generally used for batch processing on a huge amount(Terabytes, even Petabytes) of data. This data has to be already present in HDFS in hive table format. Hive is based on hadoop and runs mapreduce jobs to process the query. Remember by saying you want to switch from mysql to hive...you actually mean you are moving from RDBMS to Big Data Technology. This is not a small change and requires changes right from ingestion of data to querying it. But before you do that, please make sure if Hive is actually the tool you want to use and If you are okay with latency and the absence of all the features that a RDBMS provides and hive doesn't. This is On Tue, Apr 15, 2014 at 11:33 PM, Prasan Samtani <prasan.samt...@hulu.com>wrote: > Hi Jeremy, > > The suggestions given are for precisely the use case you described. A > warning: It's not going to be a matter of simple substitution. > > --Prasan > ________________________________________ > From: Jeremy [jk...@kickbackpoints.com] > Sent: Tuesday, April 15, 2014 10:58 AM > To: user@hive.apache.org; rav...@microsoft.com; sundi...@gmail.com > Subject: Re: In need of desperate help and willing to pay for consulting > work > > Just in case there is confusion I have an API that needs to talk to > hive. At the moment it is using mysql > > > Thanks for the reply’s > > On 04/15/2014 11:41 AM, Ravi Mummulla (BIG DATA) wrote: > > Use Templeton rest API to hive server 2. > > > > Thanks. > > > > -----Original Message----- > > From: "Jeremy" <jk...@kickbackpoints.com> > > Sent: 4/15/2014 10:39 AM > > To: "user@hive.apache.org" <user@hive.apache.org> > > Subject: In need of desperate help and willing to pay for consulting work > > > > What do I need to do to send a php command from a php api to query the > > hive server? I am just trying to replace mysql with hive. > > > > This should be as simple as 1 2 3 .... > > But for months I have not been able to find this answer. It has to be > > out there because many people are still using PHP. Why would it be so > > hard to have PHP talk to hive to query for data. It should be an easy > > swap out of mysql to hive. > > > > Can any one help with this issue? If people can not understand the issue > > just email me back and let me know how I can clarify. > > >
