Re:Re: Question of SQL join on nested field of right table

2020-03-25 Thread izual
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

Re: Question of SQL join on nested field of right table

2020-03-25 Thread Jark Wu
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

Question of SQL join on nested field of right table

2020-03-25 Thread izual
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"