Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3215

Describe table from hive storage does not connect to "default" database

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.0.0
    • 1.1.0
    • Storage - Hive
    • None

    Description

      From sqlline, I connect to a hive storage without specifying a database and issued a "describe <table>" command. Drill returned an empty result.

      0: jdbc:drill:schema=dfs.root> use hive;
      ----------------------------------------+

      ok summary

      ----------------------------------------+

      true Default schema changed to [hive]

      ----------------------------------------+
      1 row selected (0.149 seconds)
      0: jdbc:drill:schema=dfs.root> show tables;
      -------------------------------+

      TABLE_SCHEMA TABLE_NAME

      -------------------------------+

      hive.default timestamp_table
      hive.default varchar_table
      hive.default voter_hive
      hive.default voter_hive_p

      -------------------------------+

      0: jdbc:drill:schema=dfs.root> describe voter_hive;
      --

       

      --
      --

      I need to specify the database in the describe command for it to work:
      0: jdbc:drill:schema=dfs.root> describe `hive.default`.voter_hive;
      --------------------------------------

      COLUMN_NAME DATA_TYPE IS_NULLABLE

      --------------------------------------

      voter_id SMALLINT YES
      name VARCHAR YES
      age TINYINT YES
      registration VARCHAR YES
      contributions DECIMAL YES
      voterzone INTEGER YES
      create_time TIMESTAMP YES

      --------------------------------------

      Attachments

        Activity

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

          People

            vkorukanti Venki Korukanti
            knguyen Krystal
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment