You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by ChrisSandison <gi...@git.apache.org> on 2017/11/14 18:12:48 UTC

[GitHub] drill pull request #1034: Adding asGeoJSON function

GitHub user ChrisSandison opened a pull request:

    https://github.com/apache/drill/pull/1034

    Adding asGeoJSON function

    Fixes #5960

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/ChrisSandison/drill DRILL-5960

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/drill/pull/1034.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1034
    
----
commit a34cad50e942408220bfc575ec10df89d64c57e5
Author: chris <ch...@thinkdataworks.com>
Date:   2017-11-14T14:28:36Z

    Adding asGeoJSON function
    
    Fixes #5960

----


---

[GitHub] drill issue #1034: DRILL-5960: Adding asGeoJSON function

Posted by arina-ielchiieva <gi...@git.apache.org>.
Github user arina-ielchiieva commented on the issue:

    https://github.com/apache/drill/pull/1034
  
    Looks good, please squash the commits into one with commit message: `DRILL-5960: Added asGeoJSON function`.


---

[GitHub] drill pull request #1034: DRILL-5960: Adding asGeoJSON function

Posted by arina-ielchiieva <gi...@git.apache.org>.
Github user arina-ielchiieva commented on a diff in the pull request:

    https://github.com/apache/drill/pull/1034#discussion_r151713040
  
    --- Diff: contrib/gis/src/main/java/org/apache/drill/exec/expr/fn/impl/gis/STAsGeoJson.java ---
    @@ -0,0 +1,63 @@
    +/*
    + * Licensed to the Apache Software Foundation (ASF) under one
    + * or more contributor license agreements.  See the NOTICE file
    + * distributed with this work for additional information
    + * regarding copyright ownership.  The ASF licenses this file
    + * to you under the Apache License, Version 2.0 (the
    + * "License"); you may not use this file except in compliance
    + * with the License.  You may obtain a copy of the License at
    + *
    + * http://www.apache.org/licenses/LICENSE-2.0
    + *
    + * Unless required by applicable law or agreed to in writing, software
    + * distributed under the License is distributed on an "AS IS" BASIS,
    + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    + * See the License for the specific language governing permissions and
    + * limitations under the License.
    + */
    +
    +/*
    + * Wrapper for ESRI ST_AsGeoJson function to convert geometry to valid geojson
    + */
    +package org.apache.drill.exec.expr.fn.impl.gis;
    +
    +import javax.inject.Inject;
    +
    +import org.apache.drill.exec.expr.DrillSimpleFunc;
    +import org.apache.drill.exec.expr.annotations.FunctionTemplate;
    +import org.apache.drill.exec.expr.annotations.Output;
    +import org.apache.drill.exec.expr.annotations.Param;
    +import org.apache.drill.exec.expr.holders.VarBinaryHolder;
    +import org.apache.drill.exec.expr.holders.VarCharHolder;
    +
    +import io.netty.buffer.DrillBuf;
    +
    +@FunctionTemplate(name = "st_as_geo_json", scope = FunctionTemplate.FunctionScope.SIMPLE,
    --- End diff --
    
    @ChrisSandison since you have changed function names here and did not not in unit tests below, they will fail. Please note, functions are cached when Drill is built so to make sure your changes took affect you need to build drill first and then run unit tests).
    
    It seems I saw comment that suggested to keep function name as with compliance with previously created functions like (`st_astext`) which at some point makes sense. It looked in Calcite and they have geographical functions with the same naming convention as well, so I guess we should revert the previous name. 


---

[GitHub] drill pull request #1034: DRILL-5960: Adding asGeoJSON function

Posted by ChrisSandison <gi...@git.apache.org>.
Github user ChrisSandison commented on a diff in the pull request:

    https://github.com/apache/drill/pull/1034#discussion_r152008246
  
    --- Diff: contrib/gis/src/main/java/org/apache/drill/exec/expr/fn/impl/gis/STAsGeoJson.java ---
    @@ -0,0 +1,63 @@
    +/*
    + * Licensed to the Apache Software Foundation (ASF) under one
    + * or more contributor license agreements.  See the NOTICE file
    + * distributed with this work for additional information
    + * regarding copyright ownership.  The ASF licenses this file
    + * to you under the Apache License, Version 2.0 (the
    + * "License"); you may not use this file except in compliance
    + * with the License.  You may obtain a copy of the License at
    + *
    + * http://www.apache.org/licenses/LICENSE-2.0
    + *
    + * Unless required by applicable law or agreed to in writing, software
    + * distributed under the License is distributed on an "AS IS" BASIS,
    + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    + * See the License for the specific language governing permissions and
    + * limitations under the License.
    + */
    +
    +/*
    + * Wrapper for ESRI ST_AsGeoJson function to convert geometry to valid geojson
    + */
    +package org.apache.drill.exec.expr.fn.impl.gis;
    +
    +import javax.inject.Inject;
    +
    +import org.apache.drill.exec.expr.DrillSimpleFunc;
    +import org.apache.drill.exec.expr.annotations.FunctionTemplate;
    +import org.apache.drill.exec.expr.annotations.Output;
    +import org.apache.drill.exec.expr.annotations.Param;
    +import org.apache.drill.exec.expr.holders.VarBinaryHolder;
    +import org.apache.drill.exec.expr.holders.VarCharHolder;
    +
    +import io.netty.buffer.DrillBuf;
    +
    +@FunctionTemplate(name = "st_as_geo_json", scope = FunctionTemplate.FunctionScope.SIMPLE,
    --- End diff --
    
    @arina-ielchiieva Ah, gotcha. I've been running `mvn install -e -rf :drill-gis` after changes to save on time. I'll run clean builds from now on


---

[GitHub] drill pull request #1034: DRILL-5960: Adding asGeoJSON function

Posted by asfgit <gi...@git.apache.org>.
Github user asfgit closed the pull request at:

    https://github.com/apache/drill/pull/1034


---

[GitHub] drill issue #1034: DRILL-5960: Adding asGeoJSON function

Posted by arina-ielchiieva <gi...@git.apache.org>.
Github user arina-ielchiieva commented on the issue:

    https://github.com/apache/drill/pull/1034
  
    +1


---