This is what I think; Hive internally distributes the data. If you have set up Hive on single core it will fetch the query results from that core. If you have multi-core system on which you have setup the Hive, it will search all the cores for the query submitted and results would be compiled together for final output. The query would remain the same no matter whther you have a single core or multiple cores or a cluster of machines.
Please correct me if I am going the wrong way. Best, Heramb On Thu, Sep 20, 2012 at 11:34 PM, Madana_Babu <madana_b...@infosys.com>wrote: > Hi all, > > I have the following sql query that I am executing on a machine with single > core. I want to know how can I execute the same sqery on a maching that is > running with 4 cores. Please provide me the code. > > NEW_TABLE <- rhive.query("SELECT A, B, COUNT(C) FROM TABLE_A WHERE > A>='01-01-2012'") > > Also let me know how can I leverage only 2 / 3 cores of the machine. > > Regards, > Madana > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/SQL-query-with-Multicore-option-on-R-linux-tp4643771.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.