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...@gmail.com> wrote: > thanks got it > > On Tue, Mar 15, 2016 at 5:54 PM, Jack Krupansky <jack.krupan...@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.krupan...@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...@gmail.com> >>> wrote: >>> >>>> sorry like this >>>> insert into users (uid,loginIds) values ('111','{ 'emails' : '{' >>>> f...@baggins.com', 'bagg...@gmail.com'}','unverifiedEmails' : '{' >>>> f...@baggins.com', 'bagg...@gmail.com'}' }'); >>>> >>>> On Tue, Mar 15, 2016 at 5:01 PM, Jack Krupansky < >>>> jack.krupan...@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...@gmail.com >>>>> > wrote: >>>>> >>>>>> here is the CQL >>>>>> >>>>>> insert into users (uid,loginIds) values ('111',{ 'emails' : {' >>>>>> f...@baggins.com', 'bagg...@gmail.com'},'unverifiedEmails' : {' >>>>>> a...@baggins.com', 'c...@gmail.com'} }); >>>>>> >>>>>> >>>>>> On Tue, Mar 15, 2016 at 4:54 PM, Spencer Brown <lilspe...@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...@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 >