phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Purtell <apurt...@apache.org>
Subject Re: How to implement custom datatypes
Date Wed, 28 May 2014 18:53:15 GMT
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 <fmorakzai@gmail.com> 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 <jamestaylor@apache.org>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 <fmorakzai@gmail.com>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)

Mime
View raw message