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

SHOW CREATE VIEW fails for view containing WHERE clause on an unsecure cluster

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 2.7.0
    • Impala 2.8.0
    • Frontend
    • None

    Description

      This is an unsecure cluster.(no kerberos , no sentry)

      1. SHOW CREATE VIEW on simple view works

      [x-unsecure-2.a.b.com:21000] > show create view vs2;
      Query: show create view vs2
      +---------------------------------+
      | result                          |
      +---------------------------------+
      | CREATE VIEW default.vs2 AS      |
      | SELECT * FROM default.sample_07 |
      +---------------------------------+
      

      2. But SHOW CREATE VIEW on view containing WHERE clause fails

      [x-unsecure-2.a.b.com:21000] > show create view vs1;
      Query: show create view vs1
      ERROR: AnalysisException: null
      CAUSED BY: IllegalStateException: null
      
      [x-unsecure-2.a.b.com:21000] > describe formatted vs1;
      Query: describe formatted vs1
      +------------------------------+------------------------------------------------------------------------------------+----------------------+
      | name                         | type                                                                               | comment              |
      +------------------------------+------------------------------------------------------------------------------------+----------------------+
      | # col_name                   | data_type                                                                          | comment              |
      |                              | NULL                                                                               | NULL                 |
      | code                         | STRING                                                                             | NULL                 |
      | description                  | STRING                                                                             | NULL                 |
      | total_emp                    | INT                                                                                | NULL                 |
      | salary                       | INT                                                                                | NULL                 |
      |                              | NULL                                                                               | NULL                 |
      | # Detailed Table Information | NULL                                                                               | NULL                 |
      | Database:                    | default                                                                            | NULL                 |
      | Owner:                       | root                                                                               | NULL                 |
      | CreateTime:                  | Fri Dec 02 13:39:01 PST 2016                                                       | NULL                 |
      | LastAccessTime:              | UNKNOWN                                                                            | NULL                 |
      | Protect Mode:                | None                                                                               | NULL                 |
      | Retention:                   | 0                                                                                  | NULL                 |
      | Table Type:                  | VIRTUAL_VIEW                                                                       | NULL                 |
      | Table Parameters:            | NULL                                                                               | NULL                 |
      |                              | transient_lastDdlTime                                                              | 1480714741           |
      |                              | NULL                                                                               | NULL                 |
      | # Storage Information        | NULL                                                                               | NULL                 |
      | SerDe Library:               |                                                                                    | NULL                 |
      | InputFormat:                 |                                                                                    | NULL                 |
      | OutputFormat:                |                                                                                    | NULL                 |
      | Compressed:                  | No                                                                                 | NULL                 |
      | Num Buckets:                 | 0                                                                                  | NULL                 |
      | Bucket Columns:              | []                                                                                 | NULL                 |
      | Sort Columns:                | []                                                                                 | NULL                 |
      |                              | NULL                                                                               | NULL                 |
      | # View Information           | NULL                                                                               | NULL                 |
      | View Original Text:          | SELECT * FROM default.sample_07 WHERE code IN (SELECT code FROM default.sample_07) | NULL                 |
      | View Expanded Text:          | SELECT * FROM default.sample_07 WHERE code IN (SELECT code FROM default.sample_07) | NULL                 |
      +------------------------------+------------------------------------------------------------------------------------+----------------------+
      

      Attachments

        Activity

          People

            dtsirogiannis Dimitris Tsirogiannis
            mala_ck Mala Chikka Kempanna
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: