Re: [Postgres-xc-developers] [HACKERS] [PG-XC] how to pass a value(String) from coordinator node to all data nodes

[Aris S. <ari...@gm...>]

> All the FDW statements are blocked
> Anyway, please understand we need somebody to write a code to enable FDW at coordinator level and test it.
> Do you have any other idea to do the same thing without FDW?

FDW statements only blocked in coordinator.
So we can create fwd table manually in every data nodes (before join
them in XC cluster), and then join them in XC cluster.

Please correct me if I'm wrong.

On 11/5/14, 鈴木 幸市 <ko...@in...> wrote:
> Thank you Demai;
>
> Unfortunately, XC does not support FDW at present.   All the FDW statements
> are blocked.   It is not an architecture issue but an issue of development
> and testing.   Now that XC support materialized view stored in datanodes, I
> hope planner can handle FDW correctly.   Anyway, please understand we need
> somebody to write a code to enable FDW at coordinator level and test it.
>
> Do you have any other idea to do the same thing without FDW?
>
> Regards;
> ---
> Koichi Suzuki
>
> 2014/11/05 3:47、Demai Ni <ni...@gm...<mailto:ni...@gm...>> のメール：
>
> hi, Koichi,
>
> thanks for your response. I am trying to connect to a hdfs system, and
> reading hdfs files through FDW. Assuming I have 10 files mapping to one
> foreign table, and have 3 datanode on PG-XC, I'd like coordinator node to do
> some simple scheduling so that each dataNode of PG-XC will read roughtly
> same amount of data. That is why I'd like to hook a value(a String will be
> fine) that generated by coordinator node, and visible to every data node.
>
> Demai
>
> Demai;
>
> Anyway, could you describe your point more specifically?   What would
> you do this in vanilla postgresql?  This will help to find how to do
> it in XC.
>
> Regards;
> ---
> Koichi Suzuki
>
>>> hi, hackers,
>>>
>>> I am looking for a simple way to pass a value(ideally a hashtable, and
>>> use a
>>> string for easy implementation for now), that is generated by
>>> coordinator
>>> node, and pass it to all data nodes. Plans may be one approach, I am
>>> just
>>> wondering whether there is a simpler hook?
>>>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...<mailto:Pos...@li...>
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>