Display the SQL definition of a hive view
hadoop, hive
Solution
Use `show create table`.
Read the hive manual for more detail.
Problem
How to display the view definition of a hive view in its SQL form. Most relational databases supports commands like `SHOW CREATE VIEW viewname;`