hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sarma Tangirala <tvssarma.ome...@gmail.com>
Subject Row Counts From Multiple Tables
Date Sun, 28 Dec 2014 09:53:12 GMT
Hello,

I tried searching for this in the mailing list archive but could not find
an answer. I want to get the row counts from multiple tables, something
along the lines of

    select count(t1.first_column), count(t2.first_column) from t1, t2;

But this query as is does not work.

Apologies if this has been explained before.

Thanks
Sarma


-- 
0 1 0
0 0 1
1 1 1

Mime
View raw message