Yes looks like PIVOT would definitely work but that ticket appears to be 4 years old so I won't hold my breath on it 😉   In the mean time, I'll continue to use HIVE which provides this functionality with a simple dictionary like syntax (not quite PIVOT, but works and is intuitive for python programmers)   `select name, props["age"], props["fav_animal"] from table;`       ... View more

SELECT * does not trigger MR job, while SELECT struct_col.field will, which means the jar is probably available on HS2 host, but not available on the NM hosts. As Naveen mentioned, the class is in hive-hcatalog-xxx.jar, so you can put this jar into Hive AUX directory on HS2 host and then it should be distributed to the cluster while query is running in MR mode. Regarding JsonSerDe in C6.1, Naveen is right and it has been confirmed. ... View more