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

Explain plan to output local index name if it is used

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 5.1.3
    • 5.2.0, 5.1.4
    • None
    • None
    • Hide
      Explain plan for the local index would output in the format of "${local_index}(${physical_table_name})" instead of "${physical_table_name}". Because providing only "${physical_table_name}" in the output is confusing for user to understand whether local index is used by the plan.
      Show
      Explain plan for the local index would output in the format of "${local_index}(${physical_table_name})" instead of "${physical_table_name}". Because providing only "${physical_table_name}" in the output is confusing for user to understand whether local index is used by the plan.

    Description

      When we create local index on the table, we use different column family to store the index data. When we use Explain plan for any query that uses local index, since the hbase table name remains same for the local index, we only output that table name. To provide more clarity, we should output local index name in the Explain plan output if the local index is to be used.

      When local index is used, we should output in the format "${local_index}(${physical_table_name})" instead of "${physical_table_name}".

      Attachments

        Activity

          People

            jingyu Jing Yu
            vjasani Viraj Jasani
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: