Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7085

Drill Statistics: analyze table cmd fails

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • 1.16.0
    • 1.16.0
    • None
    • None

    Description

      On the latest build we are seeing in the regression results that the analyze cmd is failing.

      This is the dir:

      [root@qa101-108 bin]# hadoop fs -ls /drill/testdat03-05 18:26 /drill/testdata/a/table_stats/data_with_0 Found 1 items -rwxr-xr-x 3 root root 487 2019-table_stats/data_with_0/0_0_0.parquet
      
      0: jdbc:drill:drillbit=10.10.101.108> set `planner.statistics.use`=true;
      +-------+----------------------------------+
      |  ok   |             summary              |
      +-------+----------------------------------+
      | true  | planner.statistics.use updated.  |
      +-------+----------------------------------+
      1 row selected (0.164 seconds)
      
      
      0: jdbc:drill:drillbit=10.10.101.108> analyze table `table_stats/data_with_0` compute statistics;
      +--------+----------------------------------------------------------------------------------+
      |   ok   |                                     summary                                      |
      +--------+----------------------------------------------------------------------------------+
      | false  | Table table_stats/data_with_0 is not supported by ANALYZE. Support is currently limited to directory-based Parquet tables. |
      +--------+----------------------------------------------------------------------------------+
      1 row selected (0.901 seconds)
      
      

      Attachments

        Issue Links

          Activity

            People

              gparai Gautam Parai
              anishareddy Anisha Reddy
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: