[DRILL-1141] ISNUMERIC should be implemented as a SQL function

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

Environment

every environment

• Assignee: Mehant Baid
• Reporter: Fabian Wilckens
• Created: 14/Jul/14 22:26
• Updated: 25/Nov/14 02:14
• Resolved: 25/Nov/14 02:14

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