Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 646742004F1 for ; Wed, 30 Aug 2017 18:42:08 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 62E9416983A; Wed, 30 Aug 2017 16:42:08 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id A9849169837 for ; Wed, 30 Aug 2017 18:42:07 +0200 (CEST) Received: (qmail 16059 invoked by uid 500); 30 Aug 2017 16:42:06 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 16047 invoked by uid 99); 30 Aug 2017 16:42:06 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 Aug 2017 16:42:06 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id AC455182B69 for ; Wed, 30 Aug 2017 16:42:05 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -100.002 X-Spam-Level: X-Spam-Status: No, score=-100.002 tagged_above=-999 required=6.31 tests=[RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id Dliljjn36-Qi for ; Wed, 30 Aug 2017 16:42:03 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id A6CAD611C3 for ; Wed, 30 Aug 2017 16:42:03 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 23461E0217 for ; Wed, 30 Aug 2017 16:42:02 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 971682416B for ; Wed, 30 Aug 2017 16:42:00 +0000 (UTC) Date: Wed, 30 Aug 2017 16:42:00 +0000 (UTC) From: "Julian Hyde (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (PHOENIX-4142) GEOMETRY data type and OpenGIS functions MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 30 Aug 2017 16:42:08 -0000 Julian Hyde created PHOENIX-4142: ------------------------------------ Summary: GEOMETRY data type and OpenGIS functions Key: PHOENIX-4142 URL: https://issues.apache.org/jira/browse/PHOENIX-4142 Project: Phoenix Issue Type: Bug Reporter: Julian Hyde Add a GEOMETRY data type and core OpenGIS functions to Phoenix. This would allow Phoenix to execute spatial queries like those that PostGIS can execute. It would build upon the work done in Calcite in CALCITE-1968. The functions would need to be re-implemented (since a Calcite UDF is not a Phoenix UDF) but could use the same underlying library. A further step would be a spatial index - a sorted index on a Hilbert coordinate derived from latitude and longitude - and query rewrites to use it. See CALCITE-1861. -- This message was sent by Atlassian JIRA (v6.4.14#64029)