[ https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15926287#comment-15926287 ]
Hive QA commented on HIVE-15979: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12858816/HIVE-15979.6.patch {color:green}SUCCESS:{color} +1 due to 4 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 10352 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_character_length] (batchId=36) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_octet_length] (batchId=30) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_udf_character_length] (batchId=75) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_udf_octet_length] (batchId=2) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr] (batchId=141) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/4149/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/4149/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-4149/ 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: 5 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12858816 - PreCommit-HIVE-Build > Support character_length and octet_length > ----------------------------------------- > > Key: HIVE-15979 > URL: https://issues.apache.org/jira/browse/HIVE-15979 > Project: Hive > Issue Type: Sub-task > Components: SQL > Reporter: Carter Shanklin > Assignee: Teddy Choi > Attachments: HIVE-15979.1.patch, HIVE-15979.2.patch, > HIVE-15979.3.patch, HIVE-15979.4.patch, HIVE-15979.5.patch, HIVE-15979.6.patch > > > SQL defines standard ways to get number of characters and octets. SQL > reference: section 6.28. Example: > vagrant=# select character_length('欲速则不达'); > character_length > ------------------ > 5 > (1 row) > vagrant=# select octet_length('欲速则不达'); > octet_length > -------------- > 15 > (1 row) -- This message was sent by Atlassian JIRA (v6.3.15#6346)