You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Alexander Malic (JIRA)" <ji...@apache.org> on 2018/06/28 08:47:00 UTC
[jira] [Updated] (DRILL-6550) Request for additional SQL functions
[ 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)