hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13637) Fold CASE into NVL when CBO optimized the plan
Date Thu, 05 May 2016 19:33:12 GMT

    [ https://issues.apache.org/jira/browse/HIVE-13637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15272921#comment-15272921
] 

Jesus Camacho Rodriguez commented on HIVE-13637:
------------------------------------------------

{noformat}
Test Name	Duration	Age
 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_bucket3	26 sec	1
 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_bucket_map_join_tez2	1 min
27 sec	1
 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_orc_merge9	21 sec	1
 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_load_dyn_part2	1.4 sec	1
 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vectorization_15	1.1 sec	1
 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_optimize_nullscan	1.7 sec	1
 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vectorization_decimal_date
0.78 sec	1
 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_tez_union_multiinsert	1 min
38 sec	1
 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_groupby_sort_skew_1_23	1 min
49 sec	1
 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_stats20	1.6 sec	1
 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union_remove_13	0.92 sec	1
 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union_remove_19	0.83 sec	1
 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union_remove_21	0.72 sec	1
 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_join_reorder2	0.9 sec	1
 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_script_env_var1	0.77 sec	1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join32	6.5 sec	2
 org.apache.hadoop.hive.llap.tez.TestConverters.testFragmentSpecToTaskSpec	87 ms	2
 org.apache.hadoop.hive.metastore.TestHiveMetaStoreGetMetaConf.testGetMetaConfDefaultEmptyString
10 sec	2
 org.apache.hadoop.hive.metastore.TestHiveMetaStorePartitionSpecs.testAddPartitions	3 sec
2
 org.apache.hadoop.hive.llap.daemon.impl.TestTaskExecutorService.testPreemptionQueueComparator
5 sec	3
 org.apache.hadoop.hive.llap.tezplugins.TestLlapTaskSchedulerService.testDelayedLocalityNodeCommErrorImmediateAllocation
10 sec	4
 org.apache.hive.service.cli.session.TestHiveSessionImpl.testLeakOperationHandle	40 sec	6
 org.apache.hadoop.hive.llap.tezplugins.TestLlapTaskCommunicator.testFinishableStateUpdateFailure
4.1 sec	6
 org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver_encryption_select_read_only_encrypted_tbl
1 min 15 sec	15
 org.apache.hadoop.hive.metastore.TestHiveMetaStorePartitionSpecs.testFetchingPartitionsWithDifferentSchemas
3 sec	19
 org.apache.hadoop.hive.metastore.TestHiveMetaStoreGetMetaConf.testGetMetaConfDefault	11 sec
20
 org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver_encryption_insert_partition_static
2 min 11 sec	21
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_selectindate	21 sec	25
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_avrocountemptytbl	10 sec	25
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_order_null	35 sec	25
 org.apache.hive.hcatalog.api.repl.commands.TestCommands.org.apache.hive.hcatalog.api.repl.commands.TestCommands
20 sec	25
 org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver_encryption_join_with_different_encryption_keys
1 min 30 sec	25
 org.apache.hive.minikdc.TestHiveAuthFactory.testStartTokenManagerForMemoryTokenStore	2 sec
25
 org.apache.hive.minikdc.TestHiveAuthFactory.testStartTokenManagerForDBTokenStore	0.5 sec
25
 org.apache.hadoop.hive.metastore.TestHiveMetaStorePartitionSpecs.testGetPartitionSpecs_WithAndWithoutPartitionGrouping
3.3 sec	25
 org.apache.hive.minikdc.TestMiniHiveKdc.testLogin	2 min 23 sec	25
 org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_index_bitmap3	8.1 sec
25
 org.apache.hadoop.hive.cli.TestMinimrCliDriver.org.apache.hadoop.hive.cli.TestMinimrCliDriver
1 min 8 sec	25
{noformat}

> Fold CASE into NVL when CBO optimized the plan
> ----------------------------------------------
>
>                 Key: HIVE-13637
>                 URL: https://issues.apache.org/jira/browse/HIVE-13637
>             Project: Hive
>          Issue Type: Sub-task
>          Components: CBO
>    Affects Versions: 2.1.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-13637.02.patch, HIVE-13637.patch, HIVE-13637.patch
>
>
> After HIVE-13068 goes in, folding CASE into NVL got disabled when CBO has optimized the
plan, as it was done by ConstantPropagate in Hive. We need to enable it back.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message