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

Hive QA commented on HIVE-23176:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12999569/HIVE-23176.1.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 37 failed/errored test(s), 18207 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[materialized_view_create_rewrite]
 (batchId=308)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ambiguous_col] 
(batchId=56)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_10] (batchId=49)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_12] (batchId=1)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_13] (batchId=85)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_14] (batchId=20)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_1] (batchId=98)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_1_newdb] 
(batchId=13)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_2] (batchId=101)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_3] (batchId=63)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_4] (batchId=31)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_5] (batchId=34)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_6] (batchId=30)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_7] (batchId=50)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_8] (batchId=8)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_9] (batchId=92)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_disablecbo_1] 
(batchId=59)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_disablecbo_2] 
(batchId=51)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_disablecbo_3] 
(batchId=41)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_disablecbo_4] 
(batchId=7)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_mv] (batchId=94)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_reserved] 
(batchId=30)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[show_tablestatus] 
(batchId=90)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_index] (batchId=42)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_pos_alias] 
(batchId=60)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[vector_offset_limit]
 (batchId=163)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[current_date_timestamp]
 (batchId=181)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[materialized_view_create_rewrite]
 (batchId=167)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[materialized_view_create_rewrite_4]
 (batchId=171)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[materialized_view_create_rewrite_dummy]
 (batchId=183)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[materialized_view_create_rewrite_time_window]
 (batchId=170)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[results_cache_with_masking]
 (batchId=188)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schq_materialized]
 (batchId=185)
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[materialized_view_no_cbo_rewrite_2]
 (batchId=107)
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[materialized_view_no_supported_op_rewrite_2]
 (batchId=108)
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[strict_pruning_2]
 (batchId=108)
org.apache.hadoop.hive.ql.parse.TestReplicationSemanticAnalyzer$ReplDump.parseDbPattern
 (batchId=336)
{noformat}

Test results: 
https://builds.apache.org/job/PreCommit-HIVE-Build/21569/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/21569/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-21569/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 37 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12999569 - PreCommit-HIVE-Build

> Remove SELECT REGEX Column Feature
> ----------------------------------
>
>                 Key: HIVE-23176
>                 URL: https://issues.apache.org/jira/browse/HIVE-23176
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: David Mollitor
>            Assignee: David Mollitor
>            Priority: Major
>         Attachments: HIVE-23176.1.patch
>
>
> Remove the Hive feature: REGEX Column.
>  
> Hive has this interesting feature for doing REGEX to SELECT multiple columns. 
>  This needs to go.  It is not SQL standard and as currently implemented, it 
> is impossible to determine if a column identifier is a REGEX or the actual 
> name of the column.  If a column name is enclosed in back ticks then any 
> UTF-8 character is a valid table name.
>  
> [https://dev.mysql.com/doc/refman/8.0/en/identifiers.html]
> [https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to