The desc Table Cannot Be Fully Displayed Due to Overlong

Applicable Versions

V100R002C30SPC60*

V100R002C50SPC20*

V100R002C60SPC20*

V100R002C60U10,V100R002C60U10SPC00*

V100R002C60U20,V100R002C60U20SPC00*

V100R002C70SPC20*

Solution

1. Set maxWidth=20000 as follows during startup:

   [root@192-168-1-18 logs]# beeline --maxWidth=2000scan complete in 3ms
   Connecting to
   ……
   Beeline version 1.1.0 by Apache Hive

2. Expansion: Run the beeline -help command to view client display settings as follows.

     -u <database url>             the JDBC URL to connect to
   -n <username>               the username to connect as
   -p <password>               the password to connect as
   -d <driver class>              the driver class to use
   -i <init file>                  script file for initialization
   -e <query>                  query that should be executed
   -f <exec file>                 script file that should be executed
   --hiveconf property=value       Use value for given property
   --color=[true/false]             control whether color is used for display
   --showHeader=[true/false]       show column names in query results
   --headerInterval=ROWS;         the interval between which heades are displayed
   --fastConnect=[true/false]       skip building table/column list for tab-completion
   --autoCommit=[true/false]       enable/disable automatic transaction commit
   --verbose=[true/false]           show verbose error messages and debug info
   --showWarnings=[true/false]     display connection warnings
   --showNestedErrs=[true/false]    display nested errors
   --numberFormat=[pattern]        format numbers using DecimalFormat pattern
   --force=[true/false]              continue running script even after errors
   --maxWidth=MAXWIDTH          the maximum width of the terminal
   --maxColumnWidth=MAXCOLWIDTH    the maximum width to use when displaying columns
   --silent=[true/false]           be more silent
   --autosave=[true/false]         automatically save preferences
   --outputformat=[table/vertical/csv2/tsv2/dsv/csv/tsv]  format mode for result display
   Note that csv, and tsv are deprecated - use csv2, tsv2 instead
   --truncateTable=[true/false]    truncate table column when it exceeds length
   --delimiterForDSV=DELIMITER     specify the delimiter for delimiter-separated values output format (default: |)
   --isolation=LEVEL               set the transaction isolation level
   --nullemptystring=[true/false]  set to true to get historic behavior of printing null as empty string
   --socketTimeOut=n               socket connection timeout interval, in second. The default value is 300.