I am not sure if I understand, but why this should not be possible using SQL in hive?
> On 02 Dec 2015, at 21:26, Frank Luo <j...@merkleinc.com> wrote: > > Didn’t get any response, so trying one more time. I cannot believe I am the > only one facing the problem. > > From: Frank Luo > Sent: Tuesday, December 01, 2015 10:40 PM > To: user@hive.apache.org > Subject: how to get counts as a byproduct of a query > > Very often I need to run a query against a table(s), then collect some > counts. I am wondering if there is a way to kill two birds by scanning the > table once. (I don’t mind to save the counts as a separate file or something > like that) > > For example, I got a table A and B. I need to do an inner join to get some > result. In the meaning time, I need to know the table counts for both A and > B. Is there a smart way to get join result as well as the counts by reading > the tables once? > > Thanks in advance. > This email and any attachments transmitted with it are intended for use by > the intended recipient(s) only. If you have received this email in error, > please notify the sender immediately and then delete it. If you are not the > intended recipient, you must not keep, use, disclose, copy or distribute this > email without the author’s prior permission. We take precautions to minimize > the risk of transmitting software viruses, but we advise you to perform your > own virus checks on any attachment to this message. We cannot accept > liability for any loss or damage caused by software viruses. The information > contained in this communication may be confidential and may be subject to the > attorney-client privilege.