You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/05/14 20:53:16 UTC

[jira] [Created] (DRILL-742) TO_NUMBER functions fail with "UnsupportedOperationException" error

Krystal created DRILL-742:
-----------------------------

             Summary: TO_NUMBER functions fail with "UnsupportedOperationException" error
                 Key: DRILL-742
                 URL: https://issues.apache.org/jira/browse/DRILL-742
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Krystal


Below are some examples of to_number functions that failed to execute:

select to_number('987,966', '999999') from voter where voter_id=10;
select to_number('98.966', '99.999') from voter where voter_id=10;
select to_number('$2,900.00', 'L9G999D99') from voter where voter_id=10;
select to_number('00123456789', '00999999999') from voter where voter_id=10;
select to_number('$2,900.00', 'L9G999D99') from voter where voter_id=10;



--
This message was sent by Atlassian JIRA
(v6.2#6252)