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

Add support for specific column statistics to ANALYZE TABLE command

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 4.0.0-alpha-2
    • None
    • Parser, Statistics
    • None

    Description

      Currently column statistics for table/partitions can be computed in an all-or-nothing fashion by the "ANALYZE TABLE $tableName COMPUTE STATISTICS FOR COLUMNS" command.

      We propose to improve granularity and support the request to compute a single kind of statistics, BIT_VECTOR for instance.

      The new syntax could beĀ "ANALYZE TABLE $tableName COMPUTE $statsKind STATISTICS FOR COLUMNS".

      In the case of BIT_VECTOR this would translate into "ANALYZE TABLE $tableName COMPUTE BIT_VECTOR STATISTICS FOR COLUMNS".

      The change would require to extend the parser and the statistics computation logic.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              asolimando Alessandro Solimando
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: