You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sedona.apache.org by 可为 <mw...@qq.com.INVALID> on 2022/09/01 01:11:56 UTC
回复： how to set partition and index when I use spatial SQL
Thanks a lot for your reply !
In "https://sedona.apache.org/api/sql/Parameter/#explanation", I found the following words. "Advanced users only!". I don't known what's that mean. Do I need to pay or donate to use this feature？
sedona.join.indexbuildside (Advanced users only!)
The side which Sedona builds spatial indices on
Default: left
Possible values: left, right
------------------ 原始邮件 ------------------
发件人: "Jia Yu"<jiayu198910@gmail.com>;
发送时间: 2022年9月1日(星期四) 上午7:27
收件人: "dev"<dev@sedona.apache.org>; "可为"<mwhei@qq.com>;
主题: Re: how to set partition and index when I use spatial SQL
Hi,
1. Non-spatial attributes in SpatialRDD are stored in the userData field of geometries. In a spatial join query result, the non-spatial attributes are stored in the userData of each geometry. You can access them using a Map or MapPair function. See: https://sedona.apache.org/tutorial/rdd/#read-other-attributes-in-an-spatialrdd
2. In SpatialSQL API, the index and spatial partitioning are automatically done on the fly. You can set some parameters here: https://sedona.apache.org/api/sql/Parameter/#explanation
Thanks,
Jia
On Wed, Aug 31, 2022 at 7:06 AM 可为 <mwhei@qq.com.invalid> wrote:
Hello everybody,
&nbsp; &nbsp; &nbsp; I found the&nbsp; RDD's result of the spatial&nbsp; join&nbsp; query did not&nbsp; have&nbsp; non-spatial&nbsp; attributes .&nbsp; So I use&nbsp; spatial&nbsp; SQL.&nbsp; But&nbsp;&nbsp;
how to&nbsp; set partition and&nbsp; index when I use&nbsp; spatial&nbsp; SQL? Could you&nbsp; please&nbsp; give any&nbsp; suggestions?&nbsp; Thank&nbsp; you very&nbsp; much.
Or&nbsp; is there some&nbsp; ways&nbsp; to&nbsp; make&nbsp; the&nbsp; spatial&nbsp; join&nbsp; query&nbsp; has&nbsp; non-spatial&nbsp; attributes?
Re: how to set partition and index when I use spatial SQL
Posted by Jia Yu <ji...@apache.org>.
No, everything in Sedona is free. What it means is that don't change it
unless you know how these parameters work. Most users do not need to change
these parameters.
On Wed, Aug 31, 2022 at 6:11 PM 可为 <mw...@qq.com> wrote:
> Thanks a lot for your reply !
> In "https://sedona.apache.org/api/sql/Parameter/#explanation", I found
> the following words. "*Advanced users only!". *I don't known what's
> that mean. Do I need to pay or donate to use this feature？
>
> - sedona.join.indexbuildside *(Advanced users only!)*
> - The side which Sedona builds spatial indices on
> - Default: left
> - Possible values: left, right
>
>
>
> ------------------ 原始邮件 ------------------
> *发件人:* "Jia Yu"<ji...@gmail.com>;
> *发送时间:* 2022年9月1日(星期四) 上午7:27
> *收件人:* "dev"<de...@sedona.apache.org>; "可为"<mw...@qq.com>;
> *主题:* Re: how to set partition and index when I use spatial SQL
>
> Hi,
>
> 1. Non-spatial attributes in SpatialRDD are stored in the userData field
> of geometries. In a spatial join query result, the non-spatial attributes
> are stored in the userData of each geometry. You can access them using a
> Map or MapPair function. See:
> https://sedona.apache.org/tutorial/rdd/#read-other-attributes-in-an-spatialrdd
>
> 2. In SpatialSQL API, the index and spatial partitioning are automatically
> done on the fly. You can set some parameters here:
> https://sedona.apache.org/api/sql/Parameter/#explanation
>
> Thanks,
> Jia
>
>
>
> On Wed, Aug 31, 2022 at 7:06 AM 可为 <mw...@qq.com.invalid> wrote:
>
>> Hello everybody,
>> I found the RDD's result of the spatial
>> join query did not have non-spatial attributes
>> . So I use spatial SQL. But
>> how to set partition and index when I use spatial
>> SQL? Could you please give any suggestions?
>> Thank you very much.
>>
>>
>>
>> Or is there some ways to make the
>> spatial join query has non-spatial attributes?
>
>