Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4417 Umbrella: Faster Metadata Queries
  3. DRILL-3623

Limit 0 should avoid execution when querying a known schema

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.1.0
    • 1.7.0
    • Storage - Hive
    • MapR cluster

    Description

      Running a select * from hive.table limit 0 does not return (hangs).
      Select * from hive.table limit 1 works fine

      Hive table is about 6GB with 330 files with parquet using snappy compression.
      Data types are int, bigint, string and double.

      Querying directory with parquet files through the DFS plugin works fine
      select * from dfs.root.`/user/hive/warehouse/database/table` limit 0;

      Attachments

        Issue Links

          Activity

            People

              sudheeshkatkam Sudheesh Katkam
              aengelbrecht Andries Engelbrecht
              Krystal Krystal
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: