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.1.patch
          1 kB
          zhuwei
        2. HIVE-20497.2.patch
          3 kB
          zhuwei
        3. HIVE-20497.3.patch
          3 kB
          zhuwei
        4. HIVE-20497.4.patch
          4 kB
          zhuwei
        5. HIVE-20497.5.patch
          4 kB
          zhuwei
        6. HIVE-20497.6.patch
          4 kB
          zhuwei
        7. HIVE-20497.7.patch
          4 kB
          zhuwei

          Activity

            People

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

              Dates

              • Created:
                Updated: