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

Hive CLI Omnibus Improvement ticket

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: CLI
    • Labels:
      None
    • Tags:
      CLI history tab completion readline jline

      Description

      Add the following features to the Hive CLI:

      • Command History
      • ReadLine support
        • HIVE-120: Add readline support/support for alt-based commands in the CLI
        • Java-ReadLine is LGPL, but it depends on GPL readline library. We probably need to use JLine instead.
      • Tab completion
        • HIVE-97: tab completion for hive cli
      • Embedded/Standalone CLI modes, and ability to connect to different Hive Server instances.
        • HIVE-818: Create a Hive CLI that connects to hive ThriftServer
      • .hiverc configuration file
      • Improved support for comments.
        • HIVE-430: Ability to comment desired for hive query files
      • Different output formats
        • HIVE-49: display column header on CLI
        • XML output format

      For additional inspiration we may want to look at the Postgres psql shell: http://www.postgresql.org/docs/8.1/static/app-psql.html

      Finally, it would be really cool if we implemented this in a generic fashion and spun it off as an apache-commons
      shell framework. It seems like most of the Apache Hadoop projects have their own shells, and I'm sure the same is true
      for non-Hadoop Apache projects as well.

        Attachments

        1. HIVE-987.1.patch
          1 kB
          John Sichi
        2. HIVE-987.2.patch
          0.6 kB
          John Sichi
        3. sqlline-1.0.8_eb.jar
          76 kB
          John Sichi

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                cwsteinbach Carl Steinbach
              • Votes:
                0 Vote for this issue
                Watchers:
                16 Start watching this issue

                Dates

                • Created:
                  Updated: