Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6550

Request for additional SQL functions

    XMLWordPrintableJSON

    Details

    • Type: Wish
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Functions - Drill
    • Labels:
      None

      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

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              amalic Alexander Malic
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: