Cassandra stored JSON array parsing in tableau

Question

I am working with tableau and need to parse JSON array which has stored in Apache Cassandra. I could able make connect tableau with Cassandra through spark as described here. I have succeeded to parse JSON object by using jsonpath, but I don't get a solution to parse JSON array.

Please see the sample structure of my data

[{ "name": "Obama" },{ "name": "Barak" }]

Any suggestion please, thanks in advance.

Jamsheer · Accepted Answer · 2017-12-02 03:33:54Z

0

Please refer this link to get solution for this.

I have applied bellow solution from the reference

SELECT 
    get_json_object(concat(concat('{"root":', jt.value), '}'), '$.root')
FROM jt;

answered Dec 2, 2017 at 3:33

Jamsheer

3,7734 gold badges32 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cassandra stored JSON array parsing in tableau

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related