You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Miklos Csanady (JIRA)" <ji...@apache.org> on 2016/09/20 14:46:20 UTC
[jira] [Commented] (HIVE-9530) constant * column is null
interpreted as constant * boolean
[ https://issues.apache.org/jira/browse/HIVE-9530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15506778#comment-15506778 ]
Miklos Csanady commented on HIVE-9530:
--------------------------------------
Use brackets to prevent this error.
Your command it is interpreted like this:
{code}
select c1 from tversion where 1 * ( cnull is null );
{code}
You should use this instead:
{code}
select c1 from tversion where ( 1 * cnnull ) is null;
OK
+-----+
| c1 |
+-----+
+-----+
{code}
> constant * column is null interpreted as constant * boolean
> -----------------------------------------------------------
>
> Key: HIVE-9530
> URL: https://issues.apache.org/jira/browse/HIVE-9530
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 0.14.0
> Reporter: N Campbell
> Priority: Minor
>
> {code}
> select c1 from tversion where 1 * cnnull is null
> FAILED: SemanticException [Error 10014]: Line 1:30 Wrong arguments 'cnnull': No matching method for class org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPMultiply with (int, boolean)
> create table if not exists TVERSION (
> RNUM int,
> C1 int,
> CVER char(6),
> CNNULL int,
> CCNULL char(1)
> )
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
> STORED AS TEXTFILE ;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)