Can I use sql queries to get a table?

[EagleChen]

I can only get original tables by using table name in Source.

Can I use sql queries to fetch a table? One of the advantage of SQL queries is the join operation. From many tables, new tuples can be formed.

You can find an example here

[siddontang]

We use mysql row format binlog to sync mysql changed into other places, and we only care origin table changes. If no data changes, we cannot sync.

So we don't support select now.

[EagleChen]

Then can we specify parent / child relationship ?

Check here for the example.

[siddontang]

Maybe you can customize your own field mapping to support this feature, but I have not used hierarchical data mode in ES before, and I don't know whether it can be ok or not.

[EagleChen]

AFAIK, to use hierarchical data in the latest ES, when inserting data, I need to use the following command

curl -XPUT  host:port/index/type?parent=some_parent_id

When using bulk api, I need to set _parent in the index part.

More information can be found here.

But there is no configuration in "river.toml" file for this purpose.

I'm wondering whether you can support this scenario.
Thanks!

[siddontang]

Seem a hard work, and now I don't have enough time to do this, sorry for that.
And at first, I must know how to use parent-child mapping :-)

[EagleChen]

OK. I understand.
Thanks.