[
https://issues.apache.org/jira/browse/DRILL-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexander Malic updated DRILL-6550:
-----------------------------------
Description:
Following functions would make life with Drill easier
Function: *FILENAME()*
Description:
* FILENAME() outputs 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
was:
Following functions would make life with Drill easier
Function: *FILENAME()*
Description:
* FILENAME() outputs the name of the current file in case of wildcards for
paths
Function: *ROWNUM*
* 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
> Request for additional SQL functions
> ------------------------------------
>
> Key: DRILL-6550
> URL: https://issues.apache.org/jira/browse/DRILL-6550
> Project: Apache Drill
> Issue Type: Wish
> Components: Functions - Drill
> Reporter: Alexander Malic
> Priority: Minor
>
> Following functions would make life with Drill easier
> Function: *FILENAME()*
> Description:
> * FILENAME() outputs 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
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
