[jira] [Commented] (HIVE-686) add UDF substring_index

2015-05-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14561282#comment-14561282 ] Alexander Pivovarov commented on HIVE-686: -- prev builds - 4057, 4058 have 55 failed

[jira] [Commented] (HIVE-10704) Errors in Tez HashTableLoader when estimated table size is 0

2015-05-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14560431#comment-14560431 ] Alexander Pivovarov commented on HIVE-10704: Mostafa, can you check RB link?

[jira] [Updated] (HIVE-686) add UDF substring_index

2015-05-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-686: - Attachment: HIVE-686.1.patch patch #1 - derive substring_index from GenericUDF - add Junit

[jira] [Commented] (HIVE-10704) Errors in Tez HashTableLoader when estimated table size is 0

2015-05-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14560432#comment-14560432 ] Alexander Pivovarov commented on HIVE-10704: Mostafa, can you check RB link?

[jira] [Updated] (HIVE-686) add UDF substring_index

2015-05-29 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-686: - Attachment: HIVE-686.1.patch reattaching path #1 to rerun tests add UDF substring_index

[jira] [Commented] (HIVE-10841) [WHERE col is not null] does not work sometimes for queries with many JOIN statements

2015-05-29 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14565502#comment-14565502 ] Alexander Pivovarov commented on HIVE-10841: I tested one of my queries with

[jira] [Commented] (HIVE-10788) Change sort_array to support non-primitive types

2015-05-29 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14565780#comment-14565780 ] Alexander Pivovarov commented on HIVE-10788: +1 Change sort_array to support

[jira] [Commented] (HIVE-10841) [WHERE col is not null] does not work sometimes for queries with many JOIN statements

2015-05-30 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14566239#comment-14566239 ] Alexander Pivovarov commented on HIVE-10841: disabling

[jira] [Commented] (HIVE-686) add UDF substring_index

2015-05-30 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14566375#comment-14566375 ] Alexander Pivovarov commented on HIVE-686: -- Added the function description to the

[jira] [Assigned] (HIVE-10841) [WHERE col is not null] does not work sometimes for queries with many JOIN statements

2015-05-31 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov reassigned HIVE-10841: -- Assignee: Alexander Pivovarov [WHERE col is not null] does not work sometimes

[jira] [Updated] (HIVE-10841) [WHERE col is not null] does not work for large queries

2015-05-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10841: --- Description: The result from the following SELECT query is 3 rows but it should be 1

[jira] [Updated] (HIVE-10841) [WHERE col is not null] does not work for large queries

2015-05-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10841: --- Description: The result from the following SELECT query is 3 rows but it should be 1

[jira] [Updated] (HIVE-10841) [WHERE col is not null] does not work sometimes for queries with many JOIN statements

2015-05-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10841: --- Summary: [WHERE col is not null] does not work sometimes for queries with many JOIN

[jira] [Updated] (HIVE-10841) [WHERE col is not null] does not work for large queries

2015-05-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10841: --- Description: The result from the following SELECT query is 3 rows but it should be 1

[jira] [Commented] (HIVE-10748) Replace StringBuffer with StringBuilder where possible

2015-06-01 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14568290#comment-14568290 ] Alexander Pivovarov commented on HIVE-10748: Build 4130 has 3 failed tests. I

[jira] [Commented] (HIVE-11134) HS2 should log open session failure

2015-06-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11134?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14604359#comment-14604359 ] Alexander Pivovarov commented on HIVE-11134: +1 HS2 should log open session

[jira] [Updated] (HIVE-7150) FileInputStream is not closed in HiveConnection#getHttpClient()

2015-06-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-7150: -- Component/s: JDBC FileInputStream is not closed in HiveConnection#getHttpClient()

[jira] [Updated] (HIVE-7180) BufferedReader is not closed in MetaStoreSchemaInfo ctor

2015-06-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-7180: -- Attachment: HIVE-7180.4.patch patch #4 - using java 7 try-with-resources

[jira] [Updated] (HIVE-7150) FileInputStream is not closed in HiveConnection#getHttpClient()

2015-06-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-7150: -- Attachment: HIVE-7150.4.patch patch #4 - using try-with-resources FileInputStream is

[jira] [Updated] (HIVE-7180) BufferedReader is not closed in MetaStoreSchemaInfo ctor

2015-06-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-7180: -- Component/s: Metastore BufferedReader is not closed in MetaStoreSchemaInfo ctor

[jira] [Updated] (HIVE-7180) BufferedReader is not closed in MetaStoreSchemaInfo ctor

2015-06-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-7180: -- Labels: (was: patch) BufferedReader is not closed in MetaStoreSchemaInfo ctor

[jira] [Commented] (HIVE-9557) create UDF to measure strings similarity using Cosine Similarity algo

2015-06-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14604360#comment-14604360 ] Alexander Pivovarov commented on HIVE-9557: --- I can open the RB now. I noticed

[jira] [Commented] (HIVE-9557) create UDF to measure strings similarity using Cosine Similarity algo

2015-06-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14604346#comment-14604346 ] Alexander Pivovarov commented on HIVE-9557: --- The review request should be public.

[jira] [Updated] (HIVE-11103) Add banker's rounding BROUND UDF

2015-06-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-11103: --- Attachment: HIVE-11103.1.patch attaching patch #1 again Add banker's rounding

[jira] [Commented] (HIVE-7180) BufferedReader is not closed in MetaStoreSchemaInfo ctor

2015-06-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14604536#comment-14604536 ] Alexander Pivovarov commented on HIVE-7180: --- The errors are unrelated. Previous

[jira] [Commented] (HIVE-10723) better logging/etc. for stuck metastore

2015-05-22 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14555636#comment-14555636 ] Alexander Pivovarov commented on HIVE-10723: Sergey Looks like 3 tasks are

[jira] [Updated] (HIVE-686) add UDF substring_index

2015-05-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-686: - Description: SUBSTRING_INDEX(str,delim,count) Returns the substring from string str before

[jira] [Updated] (HIVE-686) add UDF substring_index

2015-05-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-686: - Description: SUBSTRING_INDEX(str,delim,count) Returns the substring from string str before

[jira] [Assigned] (HIVE-686) add UDF substring_index

2015-05-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov reassigned HIVE-686: Assignee: Alexander Pivovarov (was: Larry Ogrodnek) add UDF substring_index

[jira] [Commented] (HIVE-10427) collect_list() and collect_set() should accept struct types as argument

2015-05-21 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14554784#comment-14554784 ] Alexander Pivovarov commented on HIVE-10427: I recommend to add non-primitive

[jira] [Commented] (HIVE-10711) Tez HashTableLoader attempts to allocate more memory than available when HIVECONVERTJOINNOCONDITIONALTASKTHRESHOLD exceeds process max mem

2015-05-21 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1485#comment-1485 ] Alexander Pivovarov commented on HIVE-10711: 1. should we put the following

[jira] [Commented] (HIVE-10704) Errors in Tez HashTableLoader when estimated table size is 0

2015-05-21 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1498#comment-1498 ] Alexander Pivovarov commented on HIVE-10704: Can you update RB? {code} $ rbt

[jira] [Commented] (HIVE-10427) collect_list() and collect_set() should accept struct types as argument

2015-05-21 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14554767#comment-14554767 ] Alexander Pivovarov commented on HIVE-10427: Should we open separate Jira for

[jira] [Commented] (HIVE-10711) Tez HashTableLoader attempts to allocate more memory than available when HIVECONVERTJOINNOCONDITIONALTASKTHRESHOLD exceeds process max mem

2015-05-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14559729#comment-14559729 ] Alexander Pivovarov commented on HIVE-10711: Mostafa, lets wait 24 hours

[jira] [Commented] (HIVE-10711) Tez HashTableLoader attempts to allocate more memory than available when HIVECONVERTJOINNOCONDITIONALTASKTHRESHOLD exceeds process max mem

2015-05-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14559667#comment-14559667 ] Alexander Pivovarov commented on HIVE-10711: +1 Tez HashTableLoader attempts

[jira] [Reopened] (HIVE-9557) create UDF to measure strings similarity using Cosine Similarity algo

2015-07-07 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov reopened HIVE-9557: --- I take it create UDF to measure strings similarity using Cosine Similarity algo

[jira] [Updated] (HIVE-11593) Add aes_encrypt and aes_decrypt UDFs

2015-08-18 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-11593: --- Description: AES (Advanced Encryption Standard) algorithm. Oracle JRE supports

[jira] [Updated] (HIVE-11593) Add aes_encrypt and aes_decrypt UDFs

2015-08-18 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-11593: --- Attachment: HIVE-11593.1.patch patch #1 Add aes_encrypt and aes_decrypt UDFs

[jira] [Resolved] (HIVE-1262) Add security/checksum UDFs sha,crc32,md5,aes_encrypt, and aes_decrypt

2015-08-18 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov resolved HIVE-1262. --- Resolution: Duplicate Add security/checksum UDFs sha,crc32,md5,aes_encrypt, and

[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF

2015-08-13 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14695730#comment-14695730 ] Alexander Pivovarov commented on HIVE-11103: Committed to master and branch-1.

[jira] [Commented] (HIVE-10276) Implement date_format(timestamp, fmt) UDF

2015-08-14 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697363#comment-14697363 ] Alexander Pivovarov commented on HIVE-10276: Hive documentation for

[jira] [Commented] (HIVE-10485) Create md5 UDF

2015-08-14 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14698117#comment-14698117 ] Alexander Pivovarov commented on HIVE-10485: Ruslan, try

[jira] [Updated] (HIVE-11103) Add banker's rounding BROUND UDF

2015-08-10 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-11103: --- Attachment: HIVE-11103.4.patch patch #4: - added BRoubs udf to Vectorizer - added

[jira] [Commented] (HIVE-11143) Tests udf_from_utc_timestamp.q/udf_to_utc_timestamp.q do not work with updated Java timezone information

2015-07-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14643033#comment-14643033 ] Alexander Pivovarov commented on HIVE-11143: +1 Tests

[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF

2015-07-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14643001#comment-14643001 ] Alexander Pivovarov commented on HIVE-11103: I do not think 2 tests failure

[jira] [Updated] (HIVE-11103) Add banker's rounding BROUND UDF

2015-07-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-11103: --- Attachment: HIVE-11103.2.patch patch #2 - added vector_bround.q - added

[jira] [Commented] (HIVE-11593) Add aes_encrypt and aes_decrypt UDFs

2015-08-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14717087#comment-14717087 ] Alexander Pivovarov commented on HIVE-11593: The error is not related to the

[jira] [Updated] (HIVE-11593) Add aes_encrypt and aes_decrypt UDFs

2015-08-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-11593: --- Attachment: HIVE-11593.2.patch patch #2 - move Cipher.getInstance to initialize Add

[jira] [Commented] (HIVE-11593) Add aes_encrypt and aes_decrypt UDFs

2015-09-05 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14732169#comment-14732169 ] Alexander Pivovarov commented on HIVE-11593: Added functions descriptions to the wiki

[jira] [Commented] (HIVE-15746) Fix default delimiter2 in str_to_map UDF or in method description

2017-02-02 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15851014#comment-15851014 ] Alexander Pivovarov commented on HIVE-15746: str_to_map documentation was fixed as well

[jira] [Updated] (HIVE-15746) Fix default delimiter2 in str_to_map UDF or in method description

2017-02-02 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-15746: --- Affects Version/s: (was: 2.2.0) 2.1.1 Fix

[jira] [Updated] (HIVE-15746) Fix default delimiter2 in str_to_map UDF or in method description

2017-02-02 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-15746: --- Resolution: Fixed Status: Resolved (was: Patch Available) > Fix default

[jira] [Commented] (HIVE-9988) Evaluating UDF before query is run

2017-02-07 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15857435#comment-15857435 ] Alexander Pivovarov commented on HIVE-9988: --- You can assign the expression to variable before

[jira] [Resolved] (HIVE-2710) row_sequence UDF is not documented

2017-02-07 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov resolved HIVE-2710. --- Resolution: Won't Fix > row_sequence UDF is not documented >

[jira] [Commented] (HIVE-2710) row_sequence UDF is not documented

2017-02-07 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15857440#comment-15857440 ] Alexander Pivovarov commented on HIVE-2710: --- row_sequence UDF was moved to contrib package.

[jira] [Updated] (HIVE-6046) add UDF for converting date time from one presentation to another

2017-02-07 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-6046: -- Resolution: Duplicate Status: Resolved (was: Patch Available) > add UDF for

[jira] [Resolved] (HIVE-6214) Need a UDF to convert a Date String from any standard format to another. Should be able to provide the Date String, current format and to the format into which it need to

2017-02-07 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov resolved HIVE-6214. --- Resolution: Duplicate > Need a UDF to convert a Date String from any standard format

[jira] [Commented] (HIVE-3558) UDF LEFT(string,position) to HIVE

2017-02-07 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15857451#comment-15857451 ] Alexander Pivovarov commented on HIVE-3558: --- You can use substr to get LEFT and RIGHT {code} //

[jira] [Resolved] (HIVE-3558) UDF LEFT(string,position) to HIVE

2017-02-07 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov resolved HIVE-3558. --- Resolution: Won't Fix > UDF LEFT(string,position) to HIVE >

[jira] [Comment Edited] (HIVE-6009) Add from_unixtime UDF that has controllable Timezone

2017-02-07 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15857460#comment-15857460 ] Alexander Pivovarov edited comment on HIVE-6009 at 2/8/17 5:57 AM: --- you

[jira] [Commented] (HIVE-6009) Add from_unixtime UDF that has controllable Timezone

2017-02-07 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15857460#comment-15857460 ] Alexander Pivovarov commented on HIVE-6009: --- you can convert bigint to UTC timestamp and then

[jira] [Updated] (HIVE-11593) Add aes_encrypt and aes_decrypt UDFs

2017-01-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-11593: --- Affects Version/s: (was: 2.2.0) > Add aes_encrypt and aes_decrypt UDFs >

[jira] [Updated] (HIVE-15746) Fix default delimiter2 in str_to_map UDF or in method description

2017-01-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-15746: --- Affects Version/s: 2.2.0 > Fix default delimiter2 in str_to_map UDF or in method

[jira] [Updated] (HIVE-11593) Add aes_encrypt and aes_decrypt UDFs

2017-01-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-11593: --- Affects Version/s: 2.2.0 > Add aes_encrypt and aes_decrypt UDFs >

[jira] [Updated] (HIVE-15746) Fix default delimiter2 in str_to_map UDF or in method description

2017-01-28 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-15746: --- Status: Patch Available (was: Open) > Fix default delimiter2 in str_to_map UDF or in

[jira] [Updated] (HIVE-15746) Fix default delimiter2 in str_to_map UDF or in method description

2017-01-28 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-15746: --- Attachment: HIVE-15746.1.patch I changed default delimiter2 value to ":" in UDF

<    1   2   3   4