CODEWITHSUNDEEP
hadoophivehiveql
Vishnu Vardhan
Vishnu Vardhan

Reputation: 93

hive explain plan generation

As we know that explain followed by query in hive gives us the explain plan for that query as an output, is it possible to get the explain plan in any form of data structure instead of a text format?

Upvotes: 1

Views: 576

Answers (1)

Binary Nerd
Binary Nerd

Reputation: 13927

I think you can get the output as JSON using FORMATTED. You can try:

EXPLAIN FORMATTED query

This should give you the explain output in JSON format.

Upvotes: 1

Related Questions