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

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.0
    • Fix Version/s: 1.1.0
    • Component/s: Storage - Hive
    • Labels:
      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

            People

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

              Dates

              • Created:
                Updated:
                Resolved: