[ https://issues.apache.org/jira/browse/IMPALA-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-1921. ----------------------------------- Resolution: Not A Bug I think the current behaviour is reasonable, I don't think there's a reason to be overly permissive here and drop data silently. > Cast string->*int with a decimal place always returns NULL > ---------------------------------------------------------- > > Key: IMPALA-1921 > URL: https://issues.apache.org/jira/browse/IMPALA-1921 > Project: IMPALA > Issue Type: Bug > Components: Backend > Affects Versions: Impala 2.0 > Environment: Server version: impalad version 2.0.0-cdh5 RELEASE > (build ecf30af0b4d6e56ea80297df2189367ada6b7da7) > Reporter: gpolaert > Priority: Minor > Labels: sql-language > > cast ('-1.0' as int|bigint) should not return NULL but -1. > Issue: > {code} > Query: select cast("-1.0" as int) > +---------------------+ > | cast('-1.0' as int) | > +---------------------+ > | NULL | > +---------------------+ > {code} > Workaround: > {code} > Query: select cast(cast ("-1.0" as double) as int) > +-------------------------------------+ > | cast(cast('-1.0' as double) as int) | > +-------------------------------------+ > | -1 | > +-------------------------------------+ > Fetched 1 row(s) in 0.01s > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org