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_babu@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]]


