You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Yongzhi Chen (JIRA)" <ji...@apache.org> on 2016/09/07 16:22:20 UTC
[jira] [Created] (HIVE-14715) Hive throws NumberFormatException
with query with Null value
Yongzhi Chen created HIVE-14715:
-----------------------------------
Summary: Hive throws NumberFormatException with query with Null value
Key: HIVE-14715
URL: https://issues.apache.org/jira/browse/HIVE-14715
Project: Hive
Issue Type: Bug
Reporter: Yongzhi Chen
The java.lang.NumberFormatException will throw with following reproduce:
set hive.cbo.enable=false;
CREATE TABLE `paqtest`(
`c1` int,
`s1` string,
`s2` string,
`bn1` bigint)
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat';
insert into paqtest values (58, '', 'ABC', 0);
SELECT
'Pricing mismatch' AS category,
c1,
NULL AS itemtype_used,
NULL AS acq_itemtype,
s2,
NULL AS currency_used_avg,
NULL AS acq_items_avg,
sum(bn1) AS cca
FROM paqtest
WHERE (s1 IS NULL OR length(s1) = 0)
GROUP BY 'Pricing mismatch', c1, NULL, NULL, s2, NULL, NULL;
The stack like following:
java.lang.NumberFormatException: ABC
GroupByOperator.process(Object, int) line: 773
ExecReducer.reduce(Object, Iterator, OutputCollector, Reporter) line: 236
ReduceTask.runOldReducer(JobConf, TaskUmbilicalProtocol, TaskReporter, RawKeyValueIterator, RawComparator<INKEY>, Class<INKEY>, Class<INVALUE>) line: 444
ReduceTask.run(JobConf, TaskUmbilicalProtocol) line: 392
LocalJobRunner$Job$ReduceTaskRunnable.run() line: 319
Executors$RunnableAdapter<T>.call() line: 471
It works fine when hive.cbo.enable = true
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)