Description of the Hive Table Is Too Long to Be Completely Displayed
Symptom
How do I make sure that the description is completely displayed when the desc table is too long?
Procedure
- When starting Beeline of Hive, set maxWidth to 20000.[root@192-168-1-18 logs]# beeline --maxWidth=20000scan complete in 3msConnecting to...Beeline version 1.1.0 by Apache Hive
- (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 displayNote 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.
Parent topic: Using Hive
- Symptom
- Procedure