[ https://issues.apache.org/jira/browse/HIVE-13697?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15283736#comment-15283736 ]
Hive QA commented on HIVE-13697: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12803696/HIVE-13697.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 53 failed/errored test(s), 9911 tests executed *Failed tests:* {noformat} TestColumn - did not produce a TEST-*.xml file TestCookieSigner - did not produce a TEST-*.xml file TestHBaseAggrStatsCacheIntegration - did not produce a TEST-*.xml file TestHS2HttpServer - did not produce a TEST-*.xml file TestHWISessionManager - did not produce a TEST-*.xml file TestHiveSQLException - did not produce a TEST-*.xml file TestLdapAtnProviderWithMiniDS - did not produce a TEST-*.xml file TestLdapAuthenticationProviderImpl - did not produce a TEST-*.xml file TestMiniLlapCliDriver - did not produce a TEST-*.xml file TestMiniTezCliDriver-join1.q-mapjoin_decimal.q-union5.q-and-12-more - did not produce a TEST-*.xml file TestMiniTezCliDriver-script_pipe.q-vector_decimal_aggregate.q-vector_data_types.q-and-12-more - did not produce a TEST-*.xml file TestMiniTezCliDriver-vector_distinct_2.q-tez_joins_explain.q-cte_mat_1.q-and-12-more - did not produce a TEST-*.xml file TestMiniTezCliDriver-vectorized_parquet.q-insert_values_non_partitioned.q-schema_evol_orc_nonvec_mapwork_part.q-and-12-more - did not produce a TEST-*.xml file TestPlainSaslHelper - did not produce a TEST-*.xml file TestPluggableHiveSessionImpl - did not produce a TEST-*.xml file TestRetryingThriftCLIServiceClient - did not produce a TEST-*.xml file TestServerOptionsProcessor - did not produce a TEST-*.xml file TestSessionGlobalInitFile - did not produce a TEST-*.xml file TestSessionHooks - did not produce a TEST-*.xml file TestSessionManagerMetrics - did not produce a TEST-*.xml file TestSparkCliDriver-avro_joins.q-join36.q-join1.q-and-12-more - did not produce a TEST-*.xml file TestSparkCliDriver-order.q-auto_join18_multi_distinct.q-union2.q-and-12-more - did not produce a TEST-*.xml file org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_ivyDownload org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_index_bitmap3 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_custom_input_output_format org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_groupby2 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_groupby6_map_skew org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_input14 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_merge2 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_sample8 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_stats15 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_stats6 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union_lateralview org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_vector_between_in org.apache.hadoop.hive.llap.tez.TestConverters.testFragmentSpecToTaskSpec org.apache.hadoop.hive.llap.tezplugins.TestLlapTaskCommunicator.testFinishableStateUpdateFailure org.apache.hadoop.hive.llap.tezplugins.TestLlapTaskSchedulerService.testDelayedLocalityNodeCommErrorImmediateAllocation org.apache.hadoop.hive.metastore.TestAuthzApiEmbedAuthorizerInRemote.org.apache.hadoop.hive.metastore.TestAuthzApiEmbedAuthorizerInRemote org.apache.hadoop.hive.metastore.TestMetaStoreEndFunctionListener.testEndFunctionListener org.apache.hadoop.hive.metastore.TestPartitionNameWhitelistValidation.testAddPartitionWithValidPartVal org.apache.hadoop.hive.metastore.TestPartitionNameWhitelistValidation.testAppendPartitionWithCommas org.apache.hadoop.hive.metastore.TestPartitionNameWhitelistValidation.testAppendPartitionWithUnicode org.apache.hadoop.hive.metastore.TestPartitionNameWhitelistValidation.testAppendPartitionWithValidCharacters org.apache.hadoop.hive.ql.exec.tez.TestDynamicPartitionPruner.testSingleSourceMultipleFiltersOrdering1 org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testHeartbeater org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testLockTimeout org.apache.hadoop.hive.ql.security.TestStorageBasedMetastoreAuthorizationProvider.testSimplePrivileges org.apache.hadoop.hive.thrift.TestHadoopAuthBridge23.testDelegationTokenSharedStore org.apache.hadoop.hive.thrift.TestHadoopAuthBridge23.testMetastoreProxyUser org.apache.hadoop.hive.thrift.TestHadoopAuthBridge23.testSaslWithHiveMetaStore org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler org.apache.hive.jdbc.TestSSL.testSSLFetchHttp org.apache.hive.service.cli.session.TestHiveSessionImpl.testLeakOperationHandle {noformat} Test results: http://ec2-54-177-240-2.us-west-1.compute.amazonaws.com/job/PreCommit-HIVE-MASTER-Build/272/testReport Console output: http://ec2-54-177-240-2.us-west-1.compute.amazonaws.com/job/PreCommit-HIVE-MASTER-Build/272/console Test logs: http://ec2-50-18-27-0.us-west-1.compute.amazonaws.com/logs/PreCommit-HIVE-MASTER-Build-272/ 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: 53 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12803696 - PreCommit-HIVE-MASTER-Build > ListBucketing feature does not support uppercase string. > -------------------------------------------------------- > > Key: HIVE-13697 > URL: https://issues.apache.org/jira/browse/HIVE-13697 > Project: Hive > Issue Type: Bug > Components: Database/Schema > Affects Versions: 1.2.1 > Environment: 1.2.1 > Reporter: Hao Zhu > Assignee: Oleksiy Sayankin > Priority: Critical > Attachments: HIVE-13697.1.patch > > > This is the feature: > https://cwiki.apache.org/confluence/display/Hive/ListBucketing > 1. Good example: > {code} > CREATE TABLE testskew (id INT, a STRING) > SKEWED BY (a) ON ('abc', 'xyz') STORED AS DIRECTORIES; > set hive.mapred.supports.subdirectories=true; > set mapred.input.dir.recursive=true; > INSERT OVERWRITE TABLE testskew > SELECT 123,'abc' FROM dual > union all > SELECT 123,'xyz' FROM dual > union all > SELECT 123,'others' FROM dual; > {code} > {code} > # hadoop fs -ls /user/hive/warehouse/testskew > Found 3 items > drwxrwxrwx - mapr mapr 1 2016-05-05 14:56 > /user/hive/warehouse/testskew/HIVE_DEFAULT_LIST_BUCKETING_DIR_NAME > drwxrwxrwx - mapr mapr 1 2016-05-05 14:56 > /user/hive/warehouse/testskew/a=abc > drwxrwxrwx - mapr mapr 1 2016-05-05 14:56 > /user/hive/warehouse/testskew/a=xyz > {code} > This is good, because both "abc" and "xyz" directories got created. > 2. Bad example -- This is the issue > {code} > CREATE TABLE testskew2 (id INT, a STRING) > SKEWED BY (a) ON ('aus', 'US') STORED AS DIRECTORIES; > set hive.mapred.supports.subdirectories=true; > set mapred.input.dir.recursive=true; > INSERT OVERWRITE TABLE testskew2 > SELECT 123, 'aus' FROM dual > union all > SELECT 123, 'US' FROM dual > union all > SELECT 123, 'others' FROM dual; > {code} > You can see, only "aus" directory got created... > {code} > # hadoop fs -ls /user/hive/warehouse/testskew2 > Found 2 items > drwxrwxrwx - mapr mapr 1 2016-05-05 15:11 > /user/hive/warehouse/testskew2/HIVE_DEFAULT_LIST_BUCKETING_DIR_NAME > drwxrwxrwx - mapr mapr 1 2016-05-05 15:11 > /user/hive/warehouse/testskew2/a=aus > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)