Yes, I am trying to do this too, just as your advice. It shall work.
Thank u.
At 2020-03-25 19:16:21, "Jark Wu" wrote:
Hi,
This is because temporal table join doesn't support join on a nested join.
In blink planner, a temporal table join will be translated into lookup join
which will
Hi,
This is because temporal table join doesn't support join on a nested join.
In blink planner, a temporal table join will be translated into lookup join
which will use the equality condition fields as the lookup keys.
However, nested fields can't be lookup keys for now.
Is that possible to have
Hi, Community:
I defined a dim table(tblDim) with schema :
root
|-- dim_nested_fields: ROW<`id` INT, `product_name` STRING>
and the part of SQL is : JOIN ... ON leftTable.`nested_field`.id =
tblDim.`dim_nested_fields`.id.
which will throw an exception like:
Exception in thread "main" o