Help Center/ MapReduce Service/ Troubleshooting/ Using Hive/ desc Table Cannot Be Completely Displayed
Updated on 2022-09-14 GMT+08:00

desc Table Cannot Be Completely Displayed

Symptom

How do I make sure that the description is completely displayed when the desc table is too long?

Procedure

  1. When starting Beeline of Hive, set maxWidth to 20000.

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

  2. (Optional) Run the beeline -help command to view the client display settings.

      -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.