[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15932149#comment-15932149
]
Carter Shanklin commented on HIVE-15979:
Added these, removing label (if I can...)
> 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
> Labels: TODOC2.2
> Fix For: 2.2.0
>
> 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, HIVE-15979.7.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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15931589#comment-15931589
]
Lefty Leverenz commented on HIVE-15979:
---
Doc note: These new functions should be documented, with version information,
in the UDF wikidoc.
* [Hive Operators and UDFs -- String Functions |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-StringFunctions]
Added a TODOC2.2 label.
> 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
> Labels: TODOC2.2
> Fix For: 2.2.0
>
> 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, HIVE-15979.7.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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15929494#comment-15929494
]
Teddy Choi commented on HIVE-15979:
---
[~ashutoshc], thank you!
> 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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15926756#comment-15926756
]
Ashutosh Chauhan commented on HIVE-15979:
-
You may want to add {{-- SORT_BEFORE_DIFF}} at the top of query files to avoid
this ordering issue in tests.
> 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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15925427#comment-15925427
]
Teddy Choi commented on HIVE-15979:
---
Fixed all failures. Thank you, [~ashutoshc].
> 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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15905686#comment-15905686
]
Hive QA commented on HIVE-15979:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12855530/HIVE-15979.5.patch
{color:green}SUCCESS:{color} +1 due to 4 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 7 failed/errored test(s), 10340 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ba_table_udfs]
(batchId=23)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[load_binary_data]
(batchId=46)
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/4075/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/4075/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-4075/
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: 7 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12855530 - 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
>
>
> 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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15891783#comment-15891783
]
Ashutosh Chauhan commented on HIVE-15979:
-
+1 pending tests
> 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
>
>
> 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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15891526#comment-15891526
]
Hive QA commented on HIVE-15979:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12855530/HIVE-15979.5.patch
{color:red}ERROR:{color} -1 due to build exiting with an error
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3885/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3885/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3885/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Tests exited with: NonZeroExitCodeException
Command 'bash /data/hiveptest/working/scratch/source-prep.sh' failed with exit
status 1 and output '+ date '+%Y-%m-%d %T.%3N'
2017-03-02 02:42:04.038
+ [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]]
+ export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ export
PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+
PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+ export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m '
+ ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m '
+ export 'MAVEN_OPTS=-Xmx1g '
+ MAVEN_OPTS='-Xmx1g '
+ cd /data/hiveptest/working/
+ tee /data/hiveptest/logs/PreCommit-HIVE-Build-3885/source-prep.txt
+ [[ false == \t\r\u\e ]]
+ mkdir -p maven ivy
+ [[ git = \s\v\n ]]
+ [[ git = \g\i\t ]]
+ [[ -z master ]]
+ [[ -d apache-github-source-source ]]
+ [[ ! -d apache-github-source-source/.git ]]
+ [[ ! -d apache-github-source-source ]]
+ date '+%Y-%m-%d %T.%3N'
2017-03-02 02:42:04.040
+ cd apache-github-source-source
+ git fetch origin
+ git reset --hard HEAD
HEAD is now at e759bba HIVE-16045 : Print progress bar along with operation log
(Anishek Agarwal via Thejas Nair)
+ git clean -f -d
Removing
ql/src/java/org/apache/hadoop/hive/ql/exec/vector/expressions/OctetLength.java
Removing
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFCharacterLength.java
Removing ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFLength.java
Removing
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFOctetLength.java
Removing ql/src/test/queries/clientpositive/udf_character_length.q
Removing ql/src/test/queries/clientpositive/udf_octet_length.q
Removing ql/src/test/queries/clientpositive/vector_udf_character_length.q
Removing ql/src/test/queries/clientpositive/vector_udf_octet_length.q
Removing ql/src/test/results/clientpositive/udf_character_length.q.out
Removing ql/src/test/results/clientpositive/udf_octet_length.q.out
Removing ql/src/test/results/clientpositive/vector_udf_character_length.q.out
Removing ql/src/test/results/clientpositive/vector_udf_octet_length.q.out
+ git checkout master
Already on 'master'
Your branch is up-to-date with 'origin/master'.
+ git reset --hard origin/master
HEAD is now at e759bba HIVE-16045 : Print progress bar along with operation log
(Anishek Agarwal via Thejas Nair)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2017-03-02 02:42:04.990
+ patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh
+ patchFilePath=/data/hiveptest/working/scratch/build.patch
+ [[ -f /data/hiveptest/working/scratch/build.patch ]]
+ chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh
+ /data/hiveptest/working/scratch/smart-apply-patch.sh
/data/hiveptest/working/scratch/build.patch
Going to apply patch with: patch -p0
patching file ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/exec/vector/expressions/OctetLength.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/Vectorizer.java
patching file ql/src/java/org/apache/hadoop/hive/ql/udf/UDFLength.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFCharacterLength.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFLength.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFOctetLength.java
patching file ql/src/test/queries/clientpositive/udf_character_length.q
patching file ql/src/test/queries/clientpositive/udf_octet_length.q
patching file ql/src/test/queries/clientpositive/vector_udf_character_length.q
patching file ql/src/test/queries/clientpositive/vector_udf_octet_length.q
patching file ql/src/test/results/clientpositive/show_functions.q.out
patching file ql/src/test/results/clientpositive/udf_character_length.q.out
patching file ql/src/test/results/clientpositive/udf_length.q.out
patching file ql/src/test/results/clientpositive/udf_octet_length.q.out
patching file
ql/src/test/results/clientpositive/vector_udf_character_length.q.out
patching file
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15891501#comment-15891501
]
Hive QA commented on HIVE-15979:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12855527/HIVE-15979.4.patch
{color:red}ERROR:{color} -1 due to build exiting with an error
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3884/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3884/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3884/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Tests exited with: NonZeroExitCodeException
Command 'bash /data/hiveptest/working/scratch/source-prep.sh' failed with exit
status 1 and output '+ date '+%Y-%m-%d %T.%3N'
2017-03-02 02:28:43.547
+ [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]]
+ export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ export
PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+
PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+ export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m '
+ ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m '
+ export 'MAVEN_OPTS=-Xmx1g '
+ MAVEN_OPTS='-Xmx1g '
+ cd /data/hiveptest/working/
+ tee /data/hiveptest/logs/PreCommit-HIVE-Build-3884/source-prep.txt
+ [[ false == \t\r\u\e ]]
+ mkdir -p maven ivy
+ [[ git = \s\v\n ]]
+ [[ git = \g\i\t ]]
+ [[ -z master ]]
+ [[ -d apache-github-source-source ]]
+ [[ ! -d apache-github-source-source/.git ]]
+ [[ ! -d apache-github-source-source ]]
+ date '+%Y-%m-%d %T.%3N'
2017-03-02 02:28:43.550
+ cd apache-github-source-source
+ git fetch origin
+ git reset --hard HEAD
HEAD is now at e759bba HIVE-16045 : Print progress bar along with operation log
(Anishek Agarwal via Thejas Nair)
+ git clean -f -d
+ git checkout master
Already on 'master'
Your branch is up-to-date with 'origin/master'.
+ git reset --hard origin/master
HEAD is now at e759bba HIVE-16045 : Print progress bar along with operation log
(Anishek Agarwal via Thejas Nair)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2017-03-02 02:28:44.459
+ patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh
+ patchFilePath=/data/hiveptest/working/scratch/build.patch
+ [[ -f /data/hiveptest/working/scratch/build.patch ]]
+ chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh
+ /data/hiveptest/working/scratch/smart-apply-patch.sh
/data/hiveptest/working/scratch/build.patch
Going to apply patch with: patch -p0
patching file ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/exec/vector/expressions/OctetLength.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/Vectorizer.java
patching file ql/src/java/org/apache/hadoop/hive/ql/udf/UDFLength.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFCharacterLength.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFLength.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFOctetLength.java
patching file ql/src/test/queries/clientpositive/udf_character_length.q
patching file ql/src/test/queries/clientpositive/udf_octet_length.q
patching file ql/src/test/queries/clientpositive/vector_udf_character_length.q
patching file ql/src/test/queries/clientpositive/vector_udf_octet_length.q
patching file ql/src/test/results/clientpositive/show_functions.q.out
patching file ql/src/test/results/clientpositive/udf_character_length.q.out
patching file ql/src/test/results/clientpositive/udf_length.q.out
patching file ql/src/test/results/clientpositive/udf_octet_length.q.out
patching file
ql/src/test/results/clientpositive/vector_udf_character_length.q.out
patching file ql/src/test/results/clientpositive/vector_udf_octet_length.q.out
+ [[ maven == \m\a\v\e\n ]]
+ rm -rf /data/hiveptest/working/maven/org/apache/hive
+ mvn -B clean install -DskipTests -T 4 -q
-Dmaven.repo.local=/data/hiveptest/working/maven
ANTLR Parser Generator Version 3.5.2
Output file
/data/hiveptest/working/apache-github-source-source/metastore/target/generated-sources/antlr3/org/apache/hadoop/hive/metastore/parser/FilterParser.java
does not exist: must build
/data/hiveptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/parser/Filter.g
org/apache/hadoop/hive/metastore/parser/Filter.g
DataNucleus Enhancer (version 4.1.6) for API "JDO"
DataNucleus Enhancer : Classpath
>> /usr/share/maven/boot/plexus-classworlds-2.x.jar
ENHANCED (Persistable) : org.apache.hadoop.hive.metastore.model.MDatabase
ENHANCED (Persistable) :
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15891436#comment-15891436
]
Hive QA commented on HIVE-15979:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12855505/HIVE-15979.3.patch
{color:red}ERROR:{color} -1 due to build exiting with an error
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3880/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3880/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3880/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Tests exited with: NonZeroExitCodeException
Command 'bash /data/hiveptest/working/scratch/source-prep.sh' failed with exit
status 1 and output '+ date '+%Y-%m-%d %T.%3N'
2017-03-02 01:41:41.470
+ [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]]
+ export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ export
PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+
PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+ export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m '
+ ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m '
+ export 'MAVEN_OPTS=-Xmx1g '
+ MAVEN_OPTS='-Xmx1g '
+ cd /data/hiveptest/working/
+ tee /data/hiveptest/logs/PreCommit-HIVE-Build-3880/source-prep.txt
+ [[ false == \t\r\u\e ]]
+ mkdir -p maven ivy
+ [[ git = \s\v\n ]]
+ [[ git = \g\i\t ]]
+ [[ -z master ]]
+ [[ -d apache-github-source-source ]]
+ [[ ! -d apache-github-source-source/.git ]]
+ [[ ! -d apache-github-source-source ]]
+ date '+%Y-%m-%d %T.%3N'
2017-03-02 01:41:41.472
+ cd apache-github-source-source
+ git fetch origin
+ git reset --hard HEAD
HEAD is now at ba8de30 HIVE-14459: TestBeeLineDriver - migration and re-enable
(Peter Vary via Zoltan Haindrich reviewed by Vihang Karajgaonkar)
+ git clean -f -d
+ git checkout master
Already on 'master'
Your branch is up-to-date with 'origin/master'.
+ git reset --hard origin/master
HEAD is now at ba8de30 HIVE-14459: TestBeeLineDriver - migration and re-enable
(Peter Vary via Zoltan Haindrich reviewed by Vihang Karajgaonkar)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2017-03-02 01:41:42.366
+ patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh
+ patchFilePath=/data/hiveptest/working/scratch/build.patch
+ [[ -f /data/hiveptest/working/scratch/build.patch ]]
+ chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh
+ /data/hiveptest/working/scratch/smart-apply-patch.sh
/data/hiveptest/working/scratch/build.patch
Going to apply patch with: patch -p0
patching file
llap-server/src/java/org/apache/hadoop/hive/llap/io/api/impl/LlapIoImpl.java
patching file
llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/OrcAcidColumnVectorProducer.java
patching file
llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/OrcAcidEncodedDataConsumer.java
patching file ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/exec/vector/expressions/OctetLength.java
patching file ql/src/java/org/apache/hadoop/hive/ql/io/orc/OrcInputFormat.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/io/orc/OrcRawRecordMerger.java
patching file ql/src/java/org/apache/hadoop/hive/ql/io/orc/OrcSplit.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/io/orc/VectorizedOrcAcidRowBatchReader.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/Vectorizer.java
patching file ql/src/java/org/apache/hadoop/hive/ql/plan/MapWork.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/udf/GenericUDFCharacterLength.java
patching file
ql/src/java/org/apache/hadoop/hive/ql/udf/GenericUDFOctetLength.java
patching file ql/src/java/org/apache/hadoop/hive/ql/udf/UDFLength.java
patching file
ql/src/test/org/apache/hadoop/hive/ql/io/orc/TestVectorizedOrcAcidRowBatchReader.java
patching file ql/src/test/queries/clientpositive/llap_acid.q
patching file ql/src/test/queries/clientpositive/udf_character_length.q
patching file ql/src/test/queries/clientpositive/udf_octet_length.q
patching file ql/src/test/queries/clientpositive/vector_udf_character_length.q
patching file ql/src/test/queries/clientpositive/vector_udf_octet_length.q
patching file ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out
patching file
ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out
Hunk #2 succeeded at 200 (offset 1 line).
Hunk #3 succeeded at 386 (offset -2 lines).
Hunk #4 succeeded at 479 (offset -1 lines).
Hunk #5 succeeded at 675 (offset -3 lines).
Hunk #6 succeeded at 770 (offset -2 lines).
Hunk #7 succeeded at 894 (offset -1 lines).
Hunk #8 succeeded at 1087
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15891438#comment-15891438
]
Ashutosh Chauhan commented on HIVE-15979:
-
I think you generated the patch incorrectly. Has irrelevant changes.
> 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
>
>
> 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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15890497#comment-15890497
]
Hive QA commented on HIVE-15979:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12855394/HIVE-15979.2.patch
{color:green}SUCCESS:{color} +1 due to 5 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 8 failed/errored test(s), 10328 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ba_table_udfs]
(batchId=23)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[load_binary_data]
(batchId=46)
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.TestCliDriver.testCliDriver[vector_udf_string_to_boolean]
(batchId=48)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_text_vec_table]
(batchId=148)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3871/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3871/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3871/
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: 8 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12855394 - 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
>
>
> 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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15890383#comment-15890383
]
Teddy Choi commented on HIVE-15979:
---
[~ashutoshc], I applied all of your feedbacks. Thank you!
> 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
>
>
> 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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15888930#comment-15888930
]
Ashutosh Chauhan commented on HIVE-15979:
-
* Standard has CHARACTER_LENGTH and CHAR_LENGTH as synonyms, can you please add
that as well?
* Please use GenericUDF interface instead of UDF. UDF interface is deprecated
and meant to be removed.
* Please add tests for NULL values. Should return NULL for both functions.
> 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
>
>
> 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)
[jira] [Commented] (HIVE-15979) Support character_length and octet_length
[
https://issues.apache.org/jira/browse/HIVE-15979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15884749#comment-15884749
]
Hive QA commented on HIVE-15979:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12854763/HIVE-15979.1.patch
{color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 10254 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14]
(batchId=223)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23]
(batchId=223)
org.apache.hadoop.hive.cli.TestSparkCliDriver.org.apache.hadoop.hive.cli.TestSparkCliDriver
(batchId=101)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3795/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3795/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3795/
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: 3 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12854763 - 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
>
>
> 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)
