You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Alexander Pivovarov (JIRA)" <ji...@apache.org> on 2015/02/01 07:24:34 UTC
[jira] [Updated] (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:all-tabpanel ]
Alexander Pivovarov updated HIVE-9530:
--------------------------------------
Description:
{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}
was:
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 ;
> 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)