Does Tableau support complex data type of hive columns and flatten it?

Question

I am trying to create a dashboard from the data present in the Hive. The catch is the column which I want to visualize is a nested JSON type. So will tableau able to parse and flatten the JSON column and list out all possible attributes? thanks!

Answer 1

• Unfortunately Tableau will not automatically flatten the JSON structure of the field for you, but you can manually do so.

• Here is an article that explains the use of Regex within Tableau to extract pertinent information from your JSON field.

• I realize this may not be the answer you were looking for, but hopefully, it gets you started down the right path.

• (In case it helps, Tableau does have a JSON connector in the event you are able to connect directly to your JSON as a datasource instead of embedded in your Hive connection as a complex field type.)