[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] [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] [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] [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-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-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] [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: --- Resolution: Fixed Status: Resolved (was: Patch Available) > Fix default

[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-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

[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-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] [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-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] [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-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] [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] [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] [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] [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=14604327#comment-14604327 ] Alexander Pivovarov commented on HIVE-9557: --- Hi Nishant, if I click on RB link 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] [Assigned] (HIVE-7150) FileInputStream is not closed in HiveConnection#getHttpClient()

2015-06-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov reassigned HIVE-7150: - Assignee: Alexander Pivovarov FileInputStream is not closed in

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

2015-06-26 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.3.patch patch #3 - close FileInputStream in 3 places in

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

2015-06-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov reassigned HIVE-7180: - Assignee: Alexander Pivovarov (was: skrho) BufferedReader is not closed in

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

2015-06-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14603939#comment-14603939 ] Alexander Pivovarov commented on HIVE-7180: --- I do not think we should change

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

2015-06-26 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.3.patch patch #3 - add finally block and close reader quietly

[jira] [Commented] (HIVE-7233) File hive-hwi-0.13.1 not found on lib folder

2015-06-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14603952#comment-14603952 ] Alexander Pivovarov commented on HIVE-7233: --- Lots of modern web project use

[jira] [Commented] (HIVE-7598) Potential null pointer dereference in MergeTask#closeJob()

2015-06-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14603959#comment-14603959 ] Alexander Pivovarov commented on HIVE-7598: --- isCompressed and tableInfo can not

[jira] [Updated] (HIVE-11116) Can not select data from table which points to remote hdfs location

2015-06-25 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-6: --- Description: I tried to create new table which points to remote hdfs location and

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

2015-06-25 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 patch #1 Add banker's rounding BROUND UDF

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

2015-06-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14600195#comment-14600195 ] Alexander Pivovarov commented on HIVE-9557: --- rename

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

2015-06-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14599737#comment-14599737 ] Alexander Pivovarov commented on HIVE-9557: --- Hi Nishant, Thank you for the

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

2015-06-17 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14590278#comment-14590278 ] Alexander Pivovarov commented on HIVE-10841: 1.0.1 was released on May 20. How

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

2015-06-17 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14590280#comment-14590280 ] Alexander Pivovarov commented on HIVE-10841: Yes, 1.0.2 is better [WHERE col

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

2015-06-16 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: --- Fix Version/s: 2.0.0 1.3.0 [WHERE col is not null] does not work

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

2015-06-16 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: --- Affects Version/s: 2.0.0 [WHERE col is not null] does not work sometimes for queries

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

2015-06-16 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14589081#comment-14589081 ] Alexander Pivovarov commented on HIVE-10841: Currently the patch is committed

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

2015-06-16 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: --- Affects Version/s: (was: 2.0.0) [WHERE col is not null] does not work sometimes

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

2015-06-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14583988#comment-14583988 ] Alexander Pivovarov commented on HIVE-10841: Laljo, could you cherry-pick the

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

2015-06-11 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14582813#comment-14582813 ] Alexander Pivovarov commented on HIVE-10704: +1 Errors in Tez

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

2015-06-10 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14581444#comment-14581444 ] Alexander Pivovarov commented on HIVE-10841: 5. Can you add RB link? [WHERE

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

2015-06-10 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14581443#comment-14581443 ] Alexander Pivovarov commented on HIVE-10841: 3. New integration test which

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

2015-06-10 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14581360#comment-14581360 ] Alexander Pivovarov commented on HIVE-10704: I put my comment on RB on May 30,

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

2015-06-10 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14581361#comment-14581361 ] Alexander Pivovarov commented on HIVE-10704: I put my comment on RB on May 30,

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

2015-06-09 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14579530#comment-14579530 ] Alexander Pivovarov commented on HIVE-10841: Sure, np. Btw, my apache id is

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

2015-06-08 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14578345#comment-14578345 ] Alexander Pivovarov commented on HIVE-10841: [~jpullokkaran], thank you for

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

2015-06-04 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10748: --- Fix Version/s: 2.0.0 Replace StringBuffer with StringBuilder where possible

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

2015-06-04 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14573363#comment-14573363 ] Alexander Pivovarov commented on HIVE-10427: +1 collect_list() and

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

2015-06-04 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14573342#comment-14573342 ] Alexander Pivovarov commented on HIVE-10841: Better to put code/sql/plan to

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

2015-06-03 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14571849#comment-14571849 ] Alexander Pivovarov commented on HIVE-10841: LOG info for the queries with

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

2015-06-03 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14570374#comment-14570374 ] Alexander Pivovarov commented on HIVE-10841: Thank you Laljo John for looking

[jira] [Updated] (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:all-tabpanel ] Alexander Pivovarov updated HIVE-10748: --- Attachment: HIVE-10748.2.patch patch #2: - rebased to the latest Replace

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

2015-06-01 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14568044#comment-14568044 ] Alexander Pivovarov commented on HIVE-10841: Changing the order of JOIN

[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] [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] [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] [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=14564297#comment-14564297 ] Alexander Pivovarov commented on HIVE-10841: if I set hive.optimize.ppd=false

[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=14564273#comment-14564273 ] Alexander Pivovarov commented on HIVE-10841: L tables also can be removed from

[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-10845) TezJobMonitor uses killedTaskCount instead of killedTaskAttemptCount

2015-05-28 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14563339#comment-14563339 ] Alexander Pivovarov commented on HIVE-10845: Siddharth, do you want to change

[jira] [Commented] (HIVE-10846) LLAP: preemption in AM due to failures / out of order scheduling

2015-05-28 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14563345#comment-14563345 ] Alexander Pivovarov commented on HIVE-10846: what branch? LLAP: preemption

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

2015-05-28 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-10841) [WHERE col is not null] does not work sometimes for queries with many JOIN statements

2015-05-28 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14564229#comment-14564229 ] Alexander Pivovarov commented on HIVE-10841: if we change is not null to is

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

2015-05-28 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14564213#comment-14564213 ] Alexander Pivovarov commented on HIVE-10841: if we look at hive-0.12 plan then

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

2015-05-28 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: --- Component/s: Query Planning [WHERE col is not null] does not work sometimes for

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

2015-05-28 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14564215#comment-14564215 ] Alexander Pivovarov commented on HIVE-10841: hive-0.12.0 plan {code} ABSTRACT

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

2015-05-28 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14564243#comment-14564243 ] Alexander Pivovarov commented on HIVE-10841: I found that JOIN FR can be

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

2015-05-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14561397#comment-14561397 ] Alexander Pivovarov commented on HIVE-10704: What is the negative side of

[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] [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-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?

  1   2   3   4   >