Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-295

impala not populating hive metadata correctly for create table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 0.7
    • Impala 1.0
    • None
    • None

    Description

      Running the following:

      hive> create table hive_tab (c1 int);
      impala> create table impala_tab (c1 int);
      

      The hive metatstore shows this:

      mysql> select * from TBLS where tbl_id > 693;
      --------+-------------+-------+------------------+--------+-----------+-------+------------+---------------+--------------------+--------------------+----------------+
       TBL_ID | CREATE_TIME | DB_ID | LAST_ACCESS_TIME | OWNER  | RETENTION | SD_ID |  TBL_NAME  |   TBL_TYPE    | VIEW_EXPANDED_TEXT | VIEW_ORIGINAL_TEXT | LINK_TARGET_ID |
      --------+-------------+-------+------------------+--------+-----------+-------+------------+---------------+--------------------+--------------------+----------------+
       697    |  1366414997 | 31    |                0 | grahn  |         0 | 4922  | hive_tab   | MANAGED_TABLE | [NULL]             | [NULL]             | [NULL]         |
       698    |  1366415004 | 31    |                0 | [NULL] |         0 | 4923  | impala_tab | [NULL]        | [NULL]             | [NULL]             | [NULL]         |
      --------+-------------+-------+------------------+--------+-----------+-------+------------+---------------+--------------------+--------------------+----------------+
      

      Neither OWNER nor TBL_TYPE are populated by impala.

      Attachments

        Activity

          People

            lskuff Lenni Kuff
            grahn Greg Rahn
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: