Got it

The desc Table Cannot Be Fully Displayed Due to Overlong

Latest reply: Dec 16, 2021 03:36:04 733 1 12 0 0

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.


  • x
  • convention:

olive.zhao
Admin Created Dec 16, 2021 03:36:04

Thanks for your sharing!
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.