[
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)
