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

ParseException, failed to recognize quoted identifier when re-parsing the re-written query

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Patch Available
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Parser
    • Labels:
      None
    • Environment:

      hive 2.1.1

      Description

      select `user` from team;

      If we have a table `team`, and one of its column has been masked out with `****` with column level authorization. The above query will fail with error "SemanticException org.apache.hadoop.hive.ql.parse.ParseException: line 1:9 Failed to recognize predicate 'user'. Failed rule: 'identifier' in expression specification"

      The root cause is that after re-written the ast, the back quote has been lost.

       

        Attachments

        1. HIVE-20497.7.patch
          4 kB
          zhuwei
        2. HIVE-20497.6.patch
          4 kB
          zhuwei
        3. HIVE-20497.5.patch
          4 kB
          zhuwei
        4. HIVE-20497.4.patch
          4 kB
          zhuwei
        5. HIVE-20497.3.patch
          3 kB
          zhuwei
        6. HIVE-20497.2.patch
          3 kB
          zhuwei
        7. HIVE-20497.1.patch
          1 kB
          zhuwei

          Issue Links

            Activity

              People

              • Assignee:
                qunyan zhuwei
                Reporter:
                qunyan zhuwei
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: