[jira] [Commented] (DRILL-5960) Add function STAsGeoJSON to extend GIS support
[ https://issues.apache.org/jira/browse/DRILL-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16263507#comment-16263507 ] ASF GitHub Bot commented on DRILL-5960: --- Github user asfgit closed the pull request at: https://github.com/apache/drill/pull/1034 > Add function STAsGeoJSON to extend GIS support > -- > > Key: DRILL-5960 > URL: https://issues.apache.org/jira/browse/DRILL-5960 > Project: Apache Drill > Issue Type: Improvement > Components: Functions - Drill >Affects Versions: 1.11.0 >Reporter: Chris Sandison >Assignee: Chris Sandison >Priority: Minor > Labels: doc-impacting, ready-to-commit > Fix For: 1.12.0 > > Original Estimate: 3h > Remaining Estimate: 3h > > Add function as wrapper to ESRI's `asGeoJson` functionality. > Implementation is very similar to STAsText -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (DRILL-5960) Add function STAsGeoJSON to extend GIS support
[ https://issues.apache.org/jira/browse/DRILL-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16260556#comment-16260556 ] ASF GitHub Bot commented on DRILL-5960: --- Github user arina-ielchiieva commented on the issue: https://github.com/apache/drill/pull/1034 +1 > Add function STAsGeoJSON to extend GIS support > -- > > Key: DRILL-5960 > URL: https://issues.apache.org/jira/browse/DRILL-5960 > Project: Apache Drill > Issue Type: Improvement > Components: Functions - Drill >Affects Versions: 1.11.0 >Reporter: Chris Sandison >Assignee: Chris Sandison >Priority: Minor > Labels: doc-impacting, ready-to-commit > Fix For: 1.12.0 > > Original Estimate: 3h > Remaining Estimate: 3h > > Add function as wrapper to ESRI's `asGeoJson` functionality. > Implementation is very similar to STAsText -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (DRILL-5960) Add function STAsGeoJSON to extend GIS support
[ https://issues.apache.org/jira/browse/DRILL-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16259404#comment-16259404 ] ASF GitHub Bot commented on DRILL-5960: --- 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`. > Add function STAsGeoJSON to extend GIS support > -- > > Key: DRILL-5960 > URL: https://issues.apache.org/jira/browse/DRILL-5960 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill >Reporter: Chris Sandison >Assignee: Chris Sandison >Priority: Minor > Labels: features, newbie > Original Estimate: 3h > Remaining Estimate: 3h > > Add function as wrapper to ESRI's `asGeoJson` functionality. > Implementation is very similar to STAsText -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (DRILL-5960) Add function STAsGeoJSON to extend GIS support
[ https://issues.apache.org/jira/browse/DRILL-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16259302#comment-16259302 ] ASF GitHub Bot commented on DRILL-5960: --- 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 > Add function STAsGeoJSON to extend GIS support > -- > > Key: DRILL-5960 > URL: https://issues.apache.org/jira/browse/DRILL-5960 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill >Reporter: Chris Sandison >Assignee: Chris Sandison >Priority: Minor > Labels: features, newbie > Original Estimate: 3h > Remaining Estimate: 3h > > Add function as wrapper to ESRI's `asGeoJson` functionality. > Implementation is very similar to STAsText -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (DRILL-5960) Add function STAsGeoJSON to extend GIS support
[ https://issues.apache.org/jira/browse/DRILL-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16257119#comment-16257119 ] ASF GitHub Bot commented on DRILL-5960: --- 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. > Add function STAsGeoJSON to extend GIS support > -- > > Key: DRILL-5960 > URL: https://issues.apache.org/jira/browse/DRILL-5960 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill >Reporter: Chris Sandison >Assignee: Chris Sandison >Priority: Minor > Labels: features, newbie > Original Estimate: 3h > Remaining Estimate: 3h > > Add function as wrapper to ESRI's `asGeoJson` functionality. > Implementation is very similar to STAsText -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (DRILL-5960) Add function STAsGeoJSON to extend GIS support
[ https://issues.apache.org/jira/browse/DRILL-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16251897#comment-16251897 ] Chris Sandison commented on DRILL-5960: --- [~cgivre] https://github.com/apache/drill/pull/1034 > Add function STAsGeoJSON to extend GIS support > -- > > Key: DRILL-5960 > URL: https://issues.apache.org/jira/browse/DRILL-5960 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill >Reporter: Chris Sandison >Priority: Minor > Labels: features, newbie > Original Estimate: 3h > Remaining Estimate: 3h > > Add function as wrapper to ESRI's `asGeoJson` functionality. > Implementation is very similar to STAsText -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (DRILL-5960) Add function STAsGeoJSON to extend GIS support
[ https://issues.apache.org/jira/browse/DRILL-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16251582#comment-16251582 ] Chris Sandison commented on DRILL-5960: --- [~cgivre] Hey Charles, yes I have on in the works now. I've seen that PR, and it should be complimentary to what is being submitted. I will comment here with the PR once it's done > Add function STAsGeoJSON to extend GIS support > -- > > Key: DRILL-5960 > URL: https://issues.apache.org/jira/browse/DRILL-5960 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill >Reporter: Chris Sandison >Priority: Minor > Labels: features, newbie > Original Estimate: 3h > Remaining Estimate: 3h > > Add function as wrapper to ESRI's `asGeoJson` functionality. > Implementation is very similar to STAsText -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (DRILL-5960) Add function STAsGeoJSON to extend GIS support
[ https://issues.apache.org/jira/browse/DRILL-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16250026#comment-16250026 ] Charles Givre commented on DRILL-5960: -- Hi [~ChrisSandison] Will you be submitting a PR for this? I'm reviewing another one (https://github.com/apache/drill/pull/258) which implements a lot of GIS functionality. I'm hoping to get these into v 1.12 and if you can get this submitted, I'd be happy to review it. > Add function STAsGeoJSON to extend GIS support > -- > > Key: DRILL-5960 > URL: https://issues.apache.org/jira/browse/DRILL-5960 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill >Reporter: Chris Sandison >Priority: Minor > Labels: features, newbie > Original Estimate: 3h > Remaining Estimate: 3h > > Add function as wrapper to ESRI's `asGeoJson` functionality. > Implementation is very similar to STAsText -- This message was sent by Atlassian JIRA (v6.4.14#64029)
