Existing table a, for example, the lookup table data of some latest partition in a as select * from a where clause partition=; If the value of the partition needs from the query result table b, the select * from where a partition=(select partition from b); This statement can be executed in mysql, but it will go wrong in the hive, if there is a great god make a solution

CodePudding user response:

With an intermediate variable,
And you can also join