You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Hive QA (JIRA)" <ji...@apache.org> on 2016/09/08 07:04:20 UTC
[jira] [Commented] (HIVE-14715) Hive throws NumberFormatException
with query with Null value
[ https://issues.apache.org/jira/browse/HIVE-14715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15473029#comment-15473029 ]
Hive QA commented on HIVE-14715:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12827486/HIVE-14715.1.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 64 failed/errored test(s), 10531 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.org.apache.hadoop.hive.cli.TestCliDriver
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[acid_mapjoin]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ambiguitycheck]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_udf_udaf]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[count]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynpart_sort_optimization_acid]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby2_map]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby2_map_multi_distinct]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby2_map_skew]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby3_map]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby3_map_multi_distinct]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby3_map_skew]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_cube1]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_id2]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_id3]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets1]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets3]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets4]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets5]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets_limit]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_window]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_map_ppr]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_map_ppr_multi_distinct]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_rollup1]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_sort_11]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_sort_8]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[infer_bucket_sort_grouping_operators]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[limit_pushdown2]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[lineage2]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[nullgroup4]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[nullgroup4_multi_distinct]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[special_character_in_tabnames_1]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_count]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_join_part_col_char]
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[acid_bucket_pruning]
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[cbo_udf_udaf]
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[count]
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[vector_count]
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_3]
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[groupby_grouping_sets5]
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query18]
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query22]
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query28]
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query67]
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query70]
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query80]
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query94]
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query95]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[cbo_udf_udaf]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[count]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby2_map]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby2_map_multi_distinct]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby2_map_skew]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby3_map]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby3_map_multi_distinct]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby3_map_skew]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_cube1]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_grouping_id2]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_map_ppr]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_map_ppr_multi_distinct]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_rollup1]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[nullgroup4]
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[nullgroup4_multi_distinct]
org.apache.hive.jdbc.TestJdbcWithMiniHS2.testAddJarConstructorUnCaching
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-MASTER-Build/1131/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-MASTER-Build/1131/console
Test logs: http://ec2-204-236-174-241.us-west-1.compute.amazonaws.com/logs/PreCommit-HIVE-MASTER-Build-1131/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 64 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12827486 - PreCommit-HIVE-MASTER-Build
> 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
> Assignee: Yongzhi Chen
> Attachments: HIVE-14715.1.patch
>
>
> 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
> 'PM' AS cy,
> c1,
> NULL AS iused,
> NULL AS itp,
> s2,
> NULL AS cvg,
> NULL AS acavg,
> 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)