Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-6652

Beeline gives evasive error message for any unrecognized command line arguement

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments


    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.11.0, 0.12.0, 0.13.0
    • 0.14.0
    • None
    • None


      For any unrecognized command line argument, Beeline emits a warning message that's evasive and meaningless. For instance:

      beeline abc
      abc (No such file or directory)
      Beeline version 0.14.0-SNAPSHOT by Apache Hive
      beeline -hh
      -hh (No such file or directory)

      The error seeming suggests that Beeline accepts an argument as a file name. However, neither Beeline doc nor command line help indicates there is such an option.

      beeline --help
      Usage: java org.apache.hive.cli.beeline.BeeLine 
         -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&gt;               the driver class to use
         -e <query>                      query that should be executed
         -f <file>                       script file that should be executed
         --hiveconf property=value       Use value for given property
         --hivevar name=value            hive variable name and value
                                         This is Hive specific settings in which variables
                                         can be set at session level and referenced in Hive
                                         commands or queries.
         --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/csv/tsv]   format mode for result display
         --isolation=LEVEL               set the transaction isolation level
         --nullemptystring=[true/false]  set to true to get historic behavior of printing null as empty string
         --help                          display this message

      Further research shows that this is a residual from SQLLine from which Beeline is derived, which allows user to specify a property file based on which SQLLine can make a DB connection.

      While this might be useful, this isn't documented and has caused a lot of confusions. And it's the root cause for quite a few problems such as those described in HIVE-5677. HIVE-6173 had the same symptom, which uncovered another problem.

      Thus, I'd suggest we disable this option. If it's desirable to have this option, then we need at least corresponding documentation plus better error message.


        1. HIVE-6652.patch
          1 kB
          Xuefu Zhang

        Issue Links


          This comment will be Viewable by All Users Viewable by All Users


            xuefuz Xuefu Zhang Assign to me
            xuefuz Xuefu Zhang
            0 Vote for this issue
            5 Start watching this issue




                Issue deployment