Cassandra Deep Data

Five Stars

Cassandra Deep Data

I need to extract deep/nested data from Cassandra. There are sets or lists of data within the 'columns'. Please see below.

 

housedata_column[

    {

    houseaddress:4242

    housecolor:red

    housespecs:{

        type:craftsman

        sqft:2000

        roof:composite}

    }

]

 

How do I extract this data into columns for each?

Five Stars

Re: Cassandra Deep Data

bump

Five Stars

Re: Cassandra Deep Data

bump

Moderator

Re: Cassandra Deep Data

Hello,

What does your expected result look like?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Cassandra Deep Data


@xdshiwrote:

Hello,

What does your expected result look like?

Best regards

Sabrina


Data in columns, or some usable format. E.g.:

 

table HOUSEDATA
HOUSEADDRESS HOUSECOLOR
4242         red

table HOUSESPECS
TYPE          SQFT       ROOF
craftsman     2000       composite

Or something similar. I just need to get the actual data in some form I can use.

 

Any help or suggestions appreciated.

Nine Stars

Re: Cassandra Deep Data

Input data same as you specified or any other format/changes?

 

Regards,

Veeru Boppudi
Five Stars

Re: Cassandra Deep Data


@vboppudiwrote:

Input data same as you specified or any other format/changes?

 

Regards,


I probably shouldn't have broken it in above example. Input data is in the form:

[{houseaddress:4242,housecolor:red,housespecs:{type:craftsman,sqft:2000,roof_set:{colors:{'2,4'},type:{'4'},other{'2','4'}}}}]

Nested lists of differing formats, no common and unique delimiting character. Attempted tNormalize, tExtractJsonFields, tExtractRegex, with varying degrees of success. Contacted Talend support, tier 1 unable to help, escalated to tier 2, awaiting reply. Will post solution. Unique situation moving from Cassandra to Oracle.