Cassandra Deep Data

[Anonymous]

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?

[Anonymous]

bump

[Anonymous]

bump

[Anonymous]

Hello,

What does your expected result look like?

Best regards

Sabrina

[Anonymous]

---

@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.

[vboppudi]

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

Regards,

[Anonymous]

---

@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.

[Anonymous]

@TWOF  Did you get any reply on this., I am also in similar situation, I want to parse a Map data type from cassandra and load into MSSQL.

Thanks in advance for help!