Cool. Then go ahead :) Just in case you need something in realtime, you can have a look at Impala.(I know nobody likes to get preached, but just in case ;) ).
Best Regards, Tariq +91-9741563634 https://mtariq.jux.com/ On Mon, Dec 24, 2012 at 7:00 PM, Ibrahim Yakti <iya...@souq.com> wrote: > Thanks Mohammad, No, we do not have any plans to replace our RDBMS with > Hive. Hadoop/Hive will be used as Data Warehouse & batch processing > computing, as I said we want to use Hive for analytical queries. > > > -- > Ibrahim > > > On Mon, Dec 24, 2012 at 4:19 PM, Mohammad Tariq <donta...@gmail.com>wrote: > >> Hello Ibrahim, >> >> A quick questio. Are you planning to replace your SQL DB with Hive? >> If that is the case, I would not suggest to do that. Both are meant for >> entirely different purposes. Hive is for batch processing and not for real >> time system. So if you are requirements involve real time things, you need >> to think before moving ahead. >> >> Yes, Sqoop is 'the' tool. It is primarily meant for this purpose. >> >> HTH >> >> Best Regards, >> Tariq >> +91-9741563634 >> https://mtariq.jux.com/ >> >> >> On Mon, Dec 24, 2012 at 6:38 PM, Ibrahim Yakti <iya...@souq.com> wrote: >> >>> Hi All, >>> >>> We are new to hadoop and hive, we are trying to use hive to >>> run analytical queries and we are using sqoop to import data into hive, in >>> our RDBMS the data updated very frequently and this needs to be reflected >>> to hive. Hive does not support update/delete but there are many workarounds >>> to do this task. >>> >>> What's in our mind is importing all the tables into hive as is, then we >>> build the required tables for reporting. >>> >>> My questions are: >>> >>> 1. What is the best way to reflect MySQL updates into Hive with >>> minimal resources? >>> 2. Is sqoop the right tool to do the ETL? >>> 3. Is Hive the right tool to do this kind of queries or we should >>> search for alternatives? >>> >>> Any hint will be useful, thanks in advanced. >>> >>> -- >>> Ibrahim >>> >> >> >