Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1387

Local index is not use when the query like "select * from dataTable where c1 like 'abc%'".

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.1.0
    • Fix Version/s: 4.2.1
    • Labels:
      None
    • Environment:

      jdk1.6 linux

      Description

      According to the official doc: "Local indexes can be used even when the query isn't fully covered i.e. Phoenix automatically retrieve the columns not in the index through point gets against the data table."

      But the index did not be used when i executed query statement like "select * from dataTable where c1 like 'abc%'".
      Certainly 'c1' is indexed in local index.

        Attachments

        1. PHOENIX-1387.patch
          9 kB
          rajeshbabu

          Activity

            People

            • Assignee:
              rajesh23 rajeshbabu
              Reporter:
              jelly jelly Chen
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: