Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3216

Provide an option to fail a query if casting fails

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • Impala 2.4.0
    • None
    • Backend
    • None

    Description

      Currently, Impala returns null for an casting expression if it fails somewhere.

      [21000] > select cast('aa' as tinyint);
      Query: select cast('aa' as tinyint)
      +-----------------------+
      | cast('aa' as tinyint) |
      +-----------------------+
      | NULL                  |
      +-----------------------+
      Fetched 1 row(s) in 0.01s
      

      Please provide an option for users to choose whether to return null or fail the whole query if an casting fails.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Yibing Yibing Shi
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: