[DRILL-6550] Request for additional SQL functions

• Type: Wish
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Alexander Malic
• Created: 28/Jun/18 08:28
• Updated: 28/Jun/18 09:05

Description

Following functions would make life with Drill easier

Function: FILENAME()

Description:

• FILENAME() returns the name of the current file in case of wildcards for paths

 

Function: ROWNUM

Description:

• ROWNUM returns the ROW_NUMBER of the result in each result-set. This is helpful for parsing files which don't contain an unique identifier

Workaround:

• select row_number() over (partition by 1) as ROWNUM from