Apache Drill
  1. Apache Drill
  2. DRILL-1141

ISNUMERIC should be implemented as a SQL function

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 0.1.0-m1
    • Fix Version/s: 0.7.0
    • Component/s: Functions - Drill
    • Labels:
      None
    • Environment:

      every environment

      Description

      Hi,

      would be great to have a ISNUMERIC function in SQL because if you want to run a count on self-described data there should be an option to check wether the field is numeric and therefore countable.

      if you have a CSV for example and the first line or some other lines (such as in a pagebreak when importing) include the fieldnames and therefore text-characters.

      Would be great if a query such as: SELECT count(columns[0]) as number FROM dfs.`bla` WHERE ISNUMERIC(columns[0])=1

      Thanks

      1. DRILL-1141-v2.patch
        10 kB
        Yash Sharma
      2. DRILL-1141-rebased.patch
        9 kB
        Yash Sharma

        Activity

        Fabian Wilckens created issue -
        Fabian Wilckens made changes -
        Field Original Value New Value
        Priority Major [ 3 ] Minor [ 4 ]
        Fabian Wilckens made changes -
        Description Hi,

        would be great to have a ISNUMERIC function in SQL because if you want to run a count on self-described data there should be an option to check wether the field is numeric and therefore countable.

        Thanks
        Hi,

        would be great to have a ISNUMERIC function in SQL because if you want to run a count on self-described data there should be an option to check wether the field is numeric and therefore countable.

        if you have a CSV for example and the first line or some other lines (such as in a pagebreak when importing) include the fieldnames and therefore text-characters.

        Would be great if a query such as: SELECT count(columns[0]) as number FROM dfs.`bla` WHERE ISNUMERIC(columns[0])=1

        Thanks
        Jacques Nadeau made changes -
        Fix Version/s 0.5.0 [ 12324880 ]
        Yash Sharma made changes -
        Assignee Yash Sharma [ yash360@gmail.com ]
        Yash Sharma made changes -
        Attachment DRILL-1141.patch [ 12659961 ]
        Yash Sharma made changes -
        Assignee Yash Sharma [ yash360@gmail.com ] Mehant Baid [ mehant ]
        Mehant Baid made changes -
        Assignee Mehant Baid [ mehant ] Yash Sharma [ yash360@gmail.com ]
        Yash Sharma made changes -
        Attachment DRILL-1141-v2.patch [ 12660343 ]
        Yash Sharma made changes -
        Attachment DRILL-1141-v2.patch [ 12660343 ]
        Yash Sharma made changes -
        Attachment DRILL-1141-v2.patch [ 12660352 ]
        Yash Sharma made changes -
        Assignee Yash Sharma [ yash360@gmail.com ] Mehant Baid [ mehant ]
        Yash Sharma made changes -
        Attachment DRILL-1141.patch [ 12659961 ]
        Yash Sharma made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Assignee Mehant Baid [ mehant ] DrillCommitter [ drillcommitter ]
        Jacques Nadeau made changes -
        Fix Version/s 0.6.0 [ 12327472 ]
        Fix Version/s 0.5.0 [ 12324880 ]
        Steven Phillips made changes -
        Fix Version/s 0.7.0 [ 12327473 ]
        Fix Version/s 0.6.0 [ 12327472 ]
        Mehant Baid made changes -
        Status Patch Available [ 10002 ] Open [ 1 ]
        Mehant Baid made changes -
        Assignee DrillCommitter [ drillcommitter ] Yash Sharma [ yash360@gmail.com ]
        Yash Sharma made changes -
        Attachment DRILL-1141-rebased.patch [ 12681096 ]
        Yash Sharma made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Yash Sharma made changes -
        Assignee Yash Sharma [ yash360@gmail.com ] Mehant Baid [ mehant ]
        Mehant Baid made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12875304 ] Drill workflow [ 12934792 ]

          People

          • Assignee:
            Mehant Baid
            Reporter:
            Fabian Wilckens
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development