[jira] [Commented] (HIVE-10644) create SHA2 UDF
[ https://issues.apache.org/jira/browse/HIVE-10644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14551908#comment-14551908 ] Alexander Pivovarov commented on HIVE-10644: Added the function description to Misc Functions https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-Misc.Functions > create SHA2 UDF > --- > > Key: HIVE-10644 > URL: https://issues.apache.org/jira/browse/HIVE-10644 > Project: Hive > Issue Type: Improvement > Components: UDF >Reporter: Alexander Pivovarov >Assignee: Alexander Pivovarov > Fix For: 1.3.0 > > Attachments: HIVE-10644.1.patch, HIVE-10644.2.patch, > HIVE-10644.3.patch > > > Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and > SHA-512). The first argument is the cleartext string to be hashed. The second > argument indicates the desired bit length of the result, which must have a > value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If either > argument is NULL or the hash length is not one of the permitted values, the > return value is NULL. > MySQL also has SHA2 function > https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html#function_sha2 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10644) create SHA2 UDF
[ https://issues.apache.org/jira/browse/HIVE-10644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14551896#comment-14551896 ] Alexander Pivovarov commented on HIVE-10644: Rebased and committed to master. Thank you Jason for your review! > create SHA2 UDF > --- > > Key: HIVE-10644 > URL: https://issues.apache.org/jira/browse/HIVE-10644 > Project: Hive > Issue Type: Improvement > Components: UDF >Reporter: Alexander Pivovarov >Assignee: Alexander Pivovarov > Attachments: HIVE-10644.1.patch, HIVE-10644.2.patch, > HIVE-10644.3.patch > > > Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and > SHA-512). The first argument is the cleartext string to be hashed. The second > argument indicates the desired bit length of the result, which must have a > value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If either > argument is NULL or the hash length is not one of the permitted values, the > return value is NULL. > MySQL also has SHA2 function > https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html#function_sha2 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10644) create SHA2 UDF
[
https://issues.apache.org/jira/browse/HIVE-10644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14549753#comment-14549753
]
Hive QA commented on HIVE-10644:
{color:red}Overall{color}: -1 no tests executed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12733651/HIVE-10644.3.patch
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3937/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3937/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3937/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Tests exited with: NonZeroExitCodeException
Command 'bash /data/hive-ptest/working/scratch/source-prep.sh' failed with exit
status 1 and output '+ [[ -n /usr/java/jdk1.7.0_45-cloudera ]]
+ export JAVA_HOME=/usr/java/jdk1.7.0_45-cloudera
+ JAVA_HOME=/usr/java/jdk1.7.0_45-cloudera
+ export
PATH=/usr/java/jdk1.7.0_45-cloudera/bin/:/usr/java/jdk1.7.0_45-cloudera/bin:/usr/local/apache-maven-3.0.5/bin:/usr/local/apache-maven-3.0.5/bin:/usr/java/jdk1.7.0_45-cloudera/bin:/usr/local/apache-ant-1.9.1/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/hiveptest/bin
+
PATH=/usr/java/jdk1.7.0_45-cloudera/bin/:/usr/java/jdk1.7.0_45-cloudera/bin:/usr/local/apache-maven-3.0.5/bin:/usr/local/apache-maven-3.0.5/bin:/usr/java/jdk1.7.0_45-cloudera/bin:/usr/local/apache-ant-1.9.1/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/hiveptest/bin
+ export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m '
+ ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m '
+ export 'M2_OPTS=-Xmx1g -XX:MaxPermSize=256m -Dhttp.proxyHost=localhost
-Dhttp.proxyPort=3128'
+ M2_OPTS='-Xmx1g -XX:MaxPermSize=256m -Dhttp.proxyHost=localhost
-Dhttp.proxyPort=3128'
+ cd /data/hive-ptest/working/
+ tee /data/hive-ptest/logs/PreCommit-HIVE-TRUNK-Build-3937/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 ]]
+ cd apache-github-source-source
+ git fetch origin
+ git reset --hard HEAD
HEAD is now at 46b4cc9 HIVE-10675 : Provide option to skip Accumulo related
Hive tests in itests directory (Hari Subramaniyan, reviewed by Sushanth Sowmyan)
+ git clean -f -d
+ git checkout master
Already on 'master'
+ git reset --hard origin/master
HEAD is now at 46b4cc9 HIVE-10675 : Provide option to skip Accumulo related
Hive tests in itests directory (Hari Subramaniyan, reviewed by Sushanth Sowmyan)
+ git merge --ff-only origin/master
Already up-to-date.
+ git gc
+ patchCommandPath=/data/hive-ptest/working/scratch/smart-apply-patch.sh
+ patchFilePath=/data/hive-ptest/working/scratch/build.patch
+ [[ -f /data/hive-ptest/working/scratch/build.patch ]]
+ chmod +x /data/hive-ptest/working/scratch/smart-apply-patch.sh
+ /data/hive-ptest/working/scratch/smart-apply-patch.sh
/data/hive-ptest/working/scratch/build.patch
The patch does not appear to apply with p0, p1, or p2
+ exit 1
'
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12733651 - PreCommit-HIVE-TRUNK-Build
> create SHA2 UDF
> ---
>
> Key: HIVE-10644
> URL: https://issues.apache.org/jira/browse/HIVE-10644
> Project: Hive
> Issue Type: Improvement
> Components: UDF
>Reporter: Alexander Pivovarov
>Assignee: Alexander Pivovarov
> Attachments: HIVE-10644.1.patch, HIVE-10644.2.patch,
> HIVE-10644.3.patch
>
>
> Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and
> SHA-512). The first argument is the cleartext string to be hashed. The second
> argument indicates the desired bit length of the result, which must have a
> value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If either
> argument is NULL or the hash length is not one of the permitted values, the
> return value is NULL.
> MySQL also has SHA2 function
> https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html#function_sha2
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-10644) create SHA2 UDF
[ https://issues.apache.org/jira/browse/HIVE-10644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14549596#comment-14549596 ] Jason Dere commented on HIVE-10644: --- +1 > create SHA2 UDF > --- > > Key: HIVE-10644 > URL: https://issues.apache.org/jira/browse/HIVE-10644 > Project: Hive > Issue Type: Improvement > Components: UDF >Reporter: Alexander Pivovarov >Assignee: Alexander Pivovarov > Attachments: HIVE-10644.1.patch, HIVE-10644.2.patch, > HIVE-10644.3.patch > > > Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and > SHA-512). The first argument is the cleartext string to be hashed. The second > argument indicates the desired bit length of the result, which must have a > value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If either > argument is NULL or the hash length is not one of the permitted values, the > return value is NULL. > MySQL also has SHA2 function > https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html#function_sha2 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10644) create SHA2 UDF
[
https://issues.apache.org/jira/browse/HIVE-10644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14542339#comment-14542339
]
Hive QA commented on HIVE-10644:
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12732488/HIVE-10644.2.patch
{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 8934 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udaf_percentile_approx_23
org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver_encryption_insert_partition_static
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3878/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3878/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3878/
Messages:
{noformat}
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: 2 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12732488 - PreCommit-HIVE-TRUNK-Build
> create SHA2 UDF
> ---
>
> Key: HIVE-10644
> URL: https://issues.apache.org/jira/browse/HIVE-10644
> Project: Hive
> Issue Type: Improvement
> Components: UDF
>Reporter: Alexander Pivovarov
>Assignee: Alexander Pivovarov
> Attachments: HIVE-10644.1.patch, HIVE-10644.2.patch
>
>
> Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and
> SHA-512). The first argument is the cleartext string to be hashed. The second
> argument indicates the desired bit length of the result, which must have a
> value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If either
> argument is NULL or the hash length is not one of the permitted values, the
> return value is NULL.
> MySQL also has SHA2 function
> https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html#function_sha2
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-10644) create SHA2 UDF
[
https://issues.apache.org/jira/browse/HIVE-10644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14536466#comment-14536466
]
Hive QA commented on HIVE-10644:
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12731349/HIVE-10644.1.patch
{color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 8933 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver_encryption_insert_partition_static
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3826/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3826/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3826/
Messages:
{noformat}
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: 1 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12731349 - PreCommit-HIVE-TRUNK-Build
> create SHA2 UDF
> ---
>
> Key: HIVE-10644
> URL: https://issues.apache.org/jira/browse/HIVE-10644
> Project: Hive
> Issue Type: Improvement
> Components: UDF
>Reporter: Alexander Pivovarov
>Assignee: Alexander Pivovarov
> Attachments: HIVE-10644.1.patch
>
>
> Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and
> SHA-512). The first argument is the cleartext string to be hashed. The second
> argument indicates the desired bit length of the result, which must have a
> value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If either
> argument is NULL or the hash length is not one of the permitted values, the
> return value is NULL.
> MySQL also has SHA2 function
> https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html#function_sha2
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-10644) create SHA2 UDF
[ https://issues.apache.org/jira/browse/HIVE-10644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14533652#comment-14533652 ] Alexander Pivovarov commented on HIVE-10644: SHA-224 was added to Java in release 8 (JEP-130) http://openjdk.java.net/jeps/130 Probably, we can support only 256, 384 and 512 length for now. > create SHA2 UDF > --- > > Key: HIVE-10644 > URL: https://issues.apache.org/jira/browse/HIVE-10644 > Project: Hive > Issue Type: Improvement > Components: UDF >Reporter: Alexander Pivovarov >Assignee: Alexander Pivovarov > > Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and > SHA-512). The first argument is the cleartext string to be hashed. The second > argument indicates the desired bit length of the result, which must have a > value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If either > argument is NULL or the hash length is not one of the permitted values, the > return value is NULL. > MySQL also has SHA2 function > https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html#function_sha2 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
