That is a fascinating set of slides. How does the envisioned spatio-temporal algebra and syntax (or UDF) changes relate to SQL 2011 temporal concepts and syntax support? Or do they? Please see https://issues.apache.org/jira/browse/PHOENIX-967 .
On Tue, May 27, 2014 at 9:41 AM, faisal moeen <[email protected]> wrote: > Hi James, > > Some of my datatypes can use the existing sql types but most of them > require to have custom implementations. I plan to start with point & line. > Please find attached the explanation of some of the types. I prefer to have > its support at the server level because I also plan to implement a > spatio-temporal join later. In that case, the local join would be through a > co-processor so I will need the support of the types and operations at the > region servers. > > Regards > > > On Tue, May 27, 2014 at 6:30 PM, James Taylor <[email protected]>wrote: > >> Hi Faisal, >> That sounds very interesting. What will be the structure of your custom >> data type? Would you be able to get away with using the existing fixed >> binary type and interpret the value at the application level? Or perhaps an >> array of one of our primitive types? In general, each PDataType maps to a >> SQL type (http://docs.oracle.com/javase/6/docs/api/java/sql/Types.html). >> Thanks, >> James >> >> >> On Tue, May 27, 2014 at 9:04 AM, faisal moeen <[email protected]>wrote: >> >>> Hi, >>> >>> I am trying to implement custom spatio-temporal datatypes for Phoenix. >>> How can I do that? >>> >>> Until now I have added my custom datatype "MYDT" to PDataType and >>> specified it to have a sqltype=123. >>> I chose this number because I am not sure what to add here. I can create >>> a table with this but when I insert something, its type is shown as NULL. >>> >>> I am using HBase 0.94.18 with Phoenix 3.0. >>> >>> Any help is appreciated. >>> >>> Regards >>> >>> -- >>> >>> Regards >>> Faisal Moeen >>> >> >> > > > -- > > Regards > Faisal Moeen > -- Best regards, - Andy Problems worthy of attack prove their worth by hitting back. - Piet Hein (via Tom White)
