hive查询where join,在Hive中使用where子句编写一个嵌套的select语句

I have a requirement to do a nested select within a where clause in a Hive query. A sample code snippet would be as follows;

select *

from TableA

where TA_timestamp > (select timestmp from TableB where id="hourDim")

Is this possible or am I doing something wrong here, because I am getting an error while running the above script ?!

To further elaborate on what I am trying to do, there is a cassandra keyspace that I publish statistics with a timestamp. Periodically (hourly for example) this stats will be summarized using hive, once summarized that data will be stored separately with the corresponding hour. So when the query runs for the second time (and consecutive runs) the query should only run on the new data (i.e. - timestamp > previous_execution_timestamp). I am trying to do that by storing the latest executed timestamp in a separate hive table, and then use that value to filter out the raw stats.

Can this be achieved this using hive ?!

解决方案

However, often you can use a JOIN statement instead to get to the same result:

https://karmasphere.com/hive-queries-on-table-data#join_syntax

For example, this query:

SELECT a.KEY, a.value

FROM a

WHERE a.KEY IN

(SELECT b.KEY FROM B);

can be rewritten to:

SELECT a.KEY, a.val

FROM a LEFT SEMI JOIN b ON (a.KEY = b.KEY)