cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Krupansky <jack.krupan...@gmail.com>
Subject Re:
Date Tue, 15 Mar 2016 16:16:09 GMT
Be sure to post your final (working) insert for others to learn from!

-- Jack Krupansky

On Tue, Mar 15, 2016 at 11:56 AM, Rami Badran <ramibadran.82@gmail.com>
wrote:

> thanks got it
>
> On Tue, Mar 15, 2016 at 5:54 PM, Jack Krupansky <jack.krupansky@gmail.com>
> wrote:
>
>> There's a UDT example in the doc, showing that  you don't put quotes
>> around the UDT key names:
>> https://docs.datastax.com/en/cql/3.3/cql/cql_using/useInsertUDT.html
>>
>>
>> -- Jack Krupansky
>>
>> On Tue, Mar 15, 2016 at 11:52 AM, Jack Krupansky <
>> jack.krupansky@gmail.com> wrote:
>>
>>> In any case, please post any diagnostic message/exception that you may
>>> be getting.
>>>
>>> -- Jack Krupansky
>>>
>>> On Tue, Mar 15, 2016 at 11:13 AM, Rami Badran <ramibadran.82@gmail.com>
>>> wrote:
>>>
>>>> sorry like this
>>>> insert into users (uid,loginIds) values ('111','{ 'emails'  : '{'
>>>> f@baggins.com', 'baggins@gmail.com'}','unverifiedEmails' : '{'
>>>> f@baggins.com', 'baggins@gmail.com'}' }');
>>>>
>>>> On Tue, Mar 15, 2016 at 5:01 PM, Jack Krupansky <
>>>> jack.krupansky@gmail.com> wrote:
>>>>
>>>>> No quotes around the UDT key names. (Or use double quotes.)
>>>>>
>>>>> -- Jack Krupansky
>>>>>
>>>>> On Tue, Mar 15, 2016 at 10:56 AM, Rami Badran <ramibadran.82@gmail.com
>>>>> > wrote:
>>>>>
>>>>>> here is the CQL
>>>>>>
>>>>>> insert into users (uid,loginIds) values ('111',{ 'emails'  : {'
>>>>>> f@baggins.com', 'baggins@gmail.com'},'unverifiedEmails' : {'
>>>>>> a@baggins.com', 'c@gmail.com'} });
>>>>>>
>>>>>>
>>>>>> On Tue, Mar 15, 2016 at 4:54 PM, Spencer Brown <lilspenny@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Should be loginIds map<text, frozen <loginIds>>,
with s at the end
>>>>>>> of the loginId in the map definition.
>>>>>>>
>>>>>>> On Tue, Mar 15, 2016 at 10:38 AM, Rami Badran <
>>>>>>> ramibadran.82@gmail.com> wrote:
>>>>>>>
>>>>>>>> Hi
>>>>>>>>
>>>>>>>> i have the following cassandra schema structure:
>>>>>>>>
>>>>>>>> CREATE TABLE users (
>>>>>>>> uid TEXT,
>>>>>>>> loginIds map<text, frozen <loginId>>,
>>>>>>>> primary key (uid)
>>>>>>>> );
>>>>>>>>
>>>>>>>> CREATE TYPE loginId (
>>>>>>>> emails set<text>,
>>>>>>>> unverifiedEmails set<text>,
>>>>>>>>  );
>>>>>>>>
>>>>>>>> and i tried to insert record to my table,but i have problem
with
>>>>>>>> loginIds attribute,
>>>>>>>> could you please advice how i can insert record
>>>>>>>>
>>>>>>>> --
>>>>>>>>
>>>>>>>> Regards
>>>>>>>> Rami Badran
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>> Regards
>>>>>> Rami Badran
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Regards
>>>> Rami Badran
>>>>
>>>
>>>
>>
>
>
> --
>
> Regards
> Rami Badran
>

Mime
View raw message