[DRILL-4919] Fix select count(1) / count(*) on csv with header

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.8.0
• Fix Version/s: 1.10.0
• Component/s: Functions - Drill
• Labels: ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: F Méthot
• Reviewer: Krystal
• Created: 30/Sep/16 12:59
• Updated: 05/Jan/18 13:08
• Resolved: 14/Jan/17 01:52

Description

This happens since 1.8

Dataset (I used extended char for display purpose) test.csvh:

a,b,c,d\n
1,2,3,4\n
5,6,7,8\n

Storage config:
"csvh":

{ "type": "text", "extensions" : [ "csvh" ], "extractHeader": true, "delimiter": "," }

select count(1) from dfs.`test.csvh`

Error: UNSUPPORTED_OPERATION ERROR: With extractHeader enabled, only header names are supported
coumn name columns
column index
Fragment 0:0

Issue Links

• is related to: DRILL-4648 select count(*) on csv file fails with UNSUPPORTED_OPERATION
• links to: GitHub Pull Request #714