Hi, Is there a straightforward way to execute a query on rows from multiple tables in Hive? Specifically, let's say that we have 2 tables A and B with exactly the same schema. Is it possible for me to execute a query on all the rows of A and B? If not, what could be the best way to alter the table-hdfs metastore mapping to enable this?
Thanks! Sameer -- Sameer Agarwal Algorithms, Machines, People Lab | OSNT Group Electrical Engineering and Computer Science, UC Berkeley http://www.cs.berkeley.edu/~sameerag