[DRILL-1623] COUNT (*) query with a filter does not work over partitioned data in text and json formats

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.7.0
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 31/Oct/14 20:55
• Updated: 16/Feb/17 16:49
• Resolved: 31/Oct/14 21:05

Description

git.commit.id.abbrev=6dca24a

The below 2 queries fail. The underlying data is partitioned and is one level deep.

Text Query :

select count(*) from lineitem_text where dir0=1993;

Query failed: Failure while running fragment. Readers needs at least a column to read. [499ab624-616a-409a-a93c-c1dc9a0d31b1]

Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)

Json Query :

select count(*) from orders_json where dir0=1993

Query failed: Failure while running fragment. json record reader requires at least a column [dc7cfa54-6d6f-4bf3-a0f2-38da9e58ace9]

Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)

When I tested this against parquet and hive they seem to be having no issues.

Attached the data, logs and plans for the above 2 queries

Issue Links

• duplicates: DRILL-1417 Query against directory of JSON files no longer works in 0.5