It's similar to Postgres:
http://www.postgresql.org/docs/9.1/static/arrays.html
But we only support a very limited subset of functionality right now:
- declaration of an ARRAY in CREATE ddl statement
- UPSERT of an entire array
- SELECT of an entire array
- SELECT of an element using my_array[one_based_position] notation
- a built-in function for the length of the array: ARRAY_LENGTH(my_array)
Ram - would you mind adding a one pager on our array support? You can write
it in markdown and Mujtaba can probably help you get it linked into the
site.
Thanks,
James
On Tue, Feb 25, 2014 at 9:06 AM, Mark Kerzner <mark@elephantscale.com>wrote:
> James,
>
> could you point me to the documentation for SQL ARRAY?
>
> Thank you,
> Mark
>
>
> On Mon, Feb 24, 2014 at 2:15 PM, James Taylor <jamestaylor@apache.org>wrote:
>
>> In 3.0, we support the SQL ARRAY construct which sounds similar.
>>
>> Thanks,
>> James
>>
>>
>> On Mon, Feb 24, 2014 at 11:57 AM, Mark Kerzner <mark@elephantscale.com>wrote:
>>
>>>
>>>
>>>
>>> On Mon, Feb 24, 2014 at 1:50 PM, Mark Kerzner <mark@elephantscale.com>wrote:
>>>
>>>> Hi,
>>>>
>>>> in Cassandra CQL you can do things like
>>>>
>>>> CREATE TABLE users (
>>>> email list <varchar>
>>>> ...
>>>> );
>>>>
>>>> Is there a similar construct on Phoenix?
>>>>
>>>> Thank you,
>>>> Mark
>>>>
>>>
>>>
>>
>
|