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">
1968



被折叠的 条评论
为什么被折叠?



