1
show table columns.
hive>set hive.cli.print.header=true;
2
Enable select results on vertical style, you must enable hive.cli.print.headerfirst!
hive>set hive.cli.print.row.to.vertical=true;
3
Setting how many rows on showing each region each time.
hive>set hive.cli.print.row.to.vertical.num=1;
4
Show table detail alignment.
hive>describe pretty tablename;
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">
</pre><pre code_snippet_id="258176" snippet_file_name="blog_20140326_4_4900369" class="plain" name="code">