[jira] [Commented] (HIVE-9953) fix NPE in WindowingTableFunction

2015-03-16 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14364133#comment-14364133 ] Alexander Pivovarov commented on HIVE-9953: --- Done fix NPE in

[jira] [Commented] (HIVE-9480) Build UDF TRUNC to implement FIRST_DAY as compared with LAST_DAY

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

[jira] [Commented] (HIVE-9857) Create Factorial UDF

2015-03-16 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14363585#comment-14363585 ] Alexander Pivovarov commented on HIVE-9857: --- The function description was added

[jira] [Commented] (HIVE-9953) fix NPE in WindowingTableFunction

2015-03-16 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14363620#comment-14363620 ] Alexander Pivovarov commented on HIVE-9953: --- yes. This is the mail thread on it

[jira] [Commented] (HIVE-9858) Create cbrt (cube root) UDF

2015-03-16 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14363611#comment-14363611 ] Alexander Pivovarov commented on HIVE-9858: --- The function description was added

[jira] [Resolved] (HIVE-9992) Operator Precedence is incorrect. bitwise XOR should be after minus/plus

2015-03-17 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov resolved HIVE-9992. --- Resolution: Not a Problem I checked MySQL doc again. Bitwise XOR ^ has higher

[jira] [Updated] (HIVE-9859) Create bitwise left/right shift UDFs

2015-03-17 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9859: -- Summary: Create bitwise left/right shift UDFs (was: Create bitwise shift left/right

[jira] [Updated] (HIVE-9992) Operator Precedence is incorrect. bitwise XOR should be after minus/plus

2015-03-17 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9992: -- Summary: Operator Precedence is incorrect. bitwise XOR should be after minus/plus (was:

[jira] [Updated] (HIVE-9992) Operator Precedence is incorrect. bitwise XOR should be after minus/plus

2015-03-17 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9992: -- Description: bitwise XOR ^ has higher precedence than -/+ in hive But in java bitwise

[jira] [Updated] (HIVE-9859) Create bitwise left/right shift UDFs

2015-03-19 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9859: -- Attachment: HIVE-9859.2.patch patch #2 I changed bitwise shift operators to -, -, -

[jira] [Updated] (HIVE-1575) get_json_object does not support JSON array at the root level

2015-03-22 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-1575: -- Attachment: HIVE-1575.3.patch patch #3 get_json_object does not support JSON array at

[jira] [Updated] (HIVE-9859) Create bitwise left/right shift UDFs

2015-03-20 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9859: -- Attachment: HIVE-9859.3.patch patch #3. fixed show_functions.q.out Create bitwise

[jira] [Updated] (HIVE-9947) ScriptOperator replaceAll uses unescaped dot and result is not assigned

2015-03-16 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9947: -- Attachment: HIVE-9947.3.patch removed replaceAll line ScriptOperator replaceAll uses

[jira] [Updated] (HIVE-9678) create timediff UDF

2015-03-09 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9678: -- Attachment: HIVE-9678.4.patch patch #4 again create timediff UDF ---

[jira] [Updated] (HIVE-9858) Create cbrt (cube root) UDF

2015-03-09 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9858: -- Attachment: HIVE-9858.1.patch patch #1 again Create cbrt (cube root) UDF

[jira] [Updated] (HIVE-9858) Create cbrt (cube root) UDF

2015-03-09 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9858: -- Attachment: HIVE-9858.2.patch patch #2 - fixed show_functions.q.out Create cbrt (cube

[jira] [Updated] (HIVE-9857) Create Factorial UDF

2015-03-11 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9857: -- Attachment: HIVE-9857.3.patch patch #3 - removed dependency on commons-math3 because no

[jira] [Updated] (HIVE-9930) fix QueryPlan.makeQueryId time format

2015-03-11 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9930: -- Attachment: HIVE-9930.1.patch patch #1 fix QueryPlan.makeQueryId time format

[jira] [Updated] (HIVE-9932) DDLTask.conf hides base class Task.conf

2015-03-11 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9932: -- Attachment: HIVE-9932.1.patch patch #1 DDLTask.conf hides base class Task.conf

[jira] [Updated] (HIVE-9857) Create Factorial UDF

2015-03-05 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9857: -- Attachment: HIVE-9857.1.patch patch #1 Create Factorial UDF

[jira] [Updated] (HIVE-9678) create timediff UDF

2015-03-06 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9678: -- Description: MySQL has very useful function timediff. We should have it in Hive {code}

[jira] [Updated] (HIVE-9678) create timediff UDF

2015-03-06 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9678: -- Attachment: HIVE-9678.4.patch patch #4 - switched to new GenericUDF methods to get

[jira] [Updated] (HIVE-9947) ScriptOperator replaceAll uses unescaped dot and result is not assigned

2015-03-13 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9947: -- Attachment: HIVE-9947.2.patch patch #2 - fixed transform_acid.q.out the test output has

[jira] [Updated] (HIVE-9857) Create Factorial UDF

2015-03-10 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9857: -- Attachment: HIVE-9857.2.patch patch #2 - fix typo Create Factorial UDF

[jira] [Updated] (HIVE-9949) remove not used parameters from String.format

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9949: -- Attachment: HIVE-9949.1.patch patch #1 remove not used parameters from String.format

[jira] [Updated] (HIVE-9950) fix rehash in CuckooSetBytes and CuckooSetLong

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9950: -- Attachment: HIVE-9950.1.patch patch #1 fix rehash in CuckooSetBytes and CuckooSetLong

[jira] [Updated] (HIVE-9955) TestVectorizedRowBatchCtx compares byte[] using equals() method

2015-03-13 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9955: -- Description: Found several issues 1. TestVectorizedRowBatchCtx creates RuntimeException

[jira] [Updated] (HIVE-9955) TestVectorizedRowBatchCtx compares byte[] using equals() method

2015-03-13 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9955: -- Description: 1. creates RuntimeException but does not throw it 2.

[jira] [Updated] (HIVE-9948) SparkUtilities.getFileName passes File.separator to String.split() method

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9948: -- Attachment: HIVE-9948.1.patch patch #1 SparkUtilities.getFileName passes

[jira] [Updated] (HIVE-9953) fix NPE in WindowingTableFunction

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9953: -- Attachment: HIVE-9953.1.patch patch #1 fix NPE in WindowingTableFunction

[jira] [Updated] (HIVE-9953) fix NPE in WindowingTableFunction

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9953: -- Component/s: UDF fix NPE in WindowingTableFunction -

[jira] [Updated] (HIVE-9955) TestVectorizedRowBatchCtx compares byte[] using equals() method

2015-03-13 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9955: -- Description: Found several issues with TestVectorizedRowBatchCtx: 1. compares byte[]

[jira] [Updated] (HIVE-9954) UDFJson uses the == operator to compare Strings

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9954: -- Attachment: HIVE-9954.1.patch patch #1 UDFJson uses the == operator to compare Strings

[jira] [Updated] (HIVE-9944) convert array to string properly in log messages

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9944: -- Description: DemuxOperator and ListBucketingPruner concatenate String with array[] and

[jira] [Updated] (HIVE-9944) Convert array[] to string properly in log messages

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9944: -- Description: DemuxOperator (181) and ListBucketingPruner (194, 219, 361) concatenate

[jira] [Updated] (HIVE-9944) Convert array[] to string properly in log messages

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9944: -- Attachment: HIVE-9944.1.patch patch #1 Convert array[] to string properly in log

[jira] [Updated] (HIVE-9945) FunctionTask.conf hides Task.conf field

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9945: -- Attachment: HIVE-9945.1.patch patch #1 FunctionTask.conf hides Task.conf field

[jira] [Updated] (HIVE-9947) ScriptOperator replaceAll uses unescaped dot and result is not assigned

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9947: -- Description: {code} //now b.replaceAll(., _); // should be b = b.replace('.', '_');

[jira] [Updated] (HIVE-9947) ScriptOperator replaceAll uses unescaped dot and result is not assigned

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9947: -- Description: ScriptOperator line 155 {code} //now b.replaceAll(., _); // should be b =

[jira] [Updated] (HIVE-9947) ScriptOperator replaceAll uses unescaped dot and result is not assigned

2015-03-12 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9947: -- Attachment: HIVE-9947.1.patch patch #1 ScriptOperator replaceAll uses unescaped dot

[jira] [Updated] (HIVE-9936) fix potential NPE in DefaultUDAFEvaluatorResolver

2015-03-11 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9936: -- Description: In some cases DefaultUDAFEvaluatorResolver calls new

[jira] [Updated] (HIVE-9936) fix potential NPE in DefaultUDAFEvaluatorResolver

2015-03-11 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9936: -- Attachment: HIVE-9936.1.patch patch #1 fix potential NPE in

[jira] [Updated] (HIVE-9518) Implement MONTHS_BETWEEN aligned with Oracle one

2015-03-25 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9518: -- Attachment: HIVE-9518.5.patch patch #5 refactored the code Implement MONTHS_BETWEEN

[jira] [Updated] (HIVE-1575) get_json_object does not support JSON array at the root level

2015-03-25 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-1575: -- Attachment: HIVE-1575.5.patch patch #5. fixed 2 issues with initial json path validation

[jira] [Updated] (HIVE-10159) HashTableSinkDesc and MapJoinDesc keyTblDesc can be replaced by JoinDesc.keyTableDesc

2015-03-31 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10159: --- Attachment: HIVE-10159.1.patch patch #1 HashTableSinkDesc and MapJoinDesc

[jira] [Updated] (HIVE-10159) HashTableSinkDesc and MapJoinDesc keyTblDesc can be replaced by JoinDesc.keyTableDesc

2015-03-30 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10159: --- Summary: HashTableSinkDesc and MapJoinDesc keyTblDesc can be replaced by

[jira] [Assigned] (HIVE-3378) UDF to obtain the numeric day of an year from date or timestamp in HIVE.

2015-03-31 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov reassigned HIVE-3378: - Assignee: Alexander Pivovarov UDF to obtain the numeric day of an year

[jira] [Resolved] (HIVE-10096) Investigate the random failure of TestCliDriver.testCliDriver_udaf_percentile_approx_23

2015-03-31 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov resolved HIVE-10096. Resolution: Duplicate dup of HIVE-10059 Investigate the random failure of

[jira] [Updated] (HIVE-10168) make groupby3_map.q more stable

2015-03-31 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10168: --- Issue Type: Improvement (was: Bug) make groupby3_map.q more stable

[jira] [Updated] (HIVE-10168) make groupby3_map.q more stable

2015-03-31 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10168: --- Attachment: HIVE-10168.1.patch patch #1 make groupby3_map.q more stable

[jira] [Updated] (HIVE-10178) DateWritable incorrectly calculates daysSinceEpoch for negative Unix time

2015-04-01 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10178: --- Attachment: HIVE-10178.02.patch patch #02. - replaced Math.floor with ((millisUtc -

[jira] [Updated] (HIVE-10178) DateWritable incorrectly calculates daysSinceEpoch for negative Unix time

2015-04-01 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10178: --- Attachment: HIVE-10178.01.patch patch #1 DateWritable incorrectly calculates

[jira] [Updated] (HIVE-10159) HashTableSinkDesc and MapJoinDesc keyTblDesc can be replaced by JoinDesc.keyTableDesc

2015-03-31 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10159: --- Attachment: HIVE-10159.1.patch TestCliDriver mapjoin_decimal.q and

[jira] [Updated] (HIVE-9518) Implement MONTHS_BETWEEN aligned with Oracle one

2015-03-31 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9518: -- Attachment: HIVE-9518.9.patch The function should support both short date and full

[jira] [Updated] (HIVE-9518) Implement MONTHS_BETWEEN aligned with Oracle one

2015-03-31 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9518: -- Attachment: HIVE-9518.10.patch patch #10 - added SEC_IN_31_DAYS constant for clarity

[jira] [Commented] (HIVE-2576) HiveDataSource doesn't get a proper connection

2015-02-28 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14341413#comment-14341413 ] Alexander Pivovarov commented on HIVE-2576: --- I do not think this patch helps. It

[jira] [Commented] (HIVE-9518) Implement MONTHS_BETWEEN aligned with Oracle one

2015-03-02 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14343682#comment-14343682 ] Alexander Pivovarov commented on HIVE-9518: --- I did it on Feb. 27, 2015, 7:38 p.m.

[jira] [Updated] (HIVE-9809) Fix FindBugs found bugs in hive-exec

2015-02-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9809: -- Attachment: HIVE-9809.2.patch patch #2 - removed changes in *Desc and *Operator classes

[jira] [Updated] (HIVE-9817) fix DateFormat pattern in hive-exec

2015-02-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9817: -- Description: some classes use mm for month and hh for hours it should be MM and HH fix

[jira] [Updated] (HIVE-9817) fix DateFormat pattern in hive-exec

2015-02-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9817: -- Attachment: HIVE-9817.1.patch patch #1 fix DateFormat pattern in hive-exec

[jira] [Resolved] (HIVE-9809) Fix FindBugs found bugs in hive-exec

2015-02-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov resolved HIVE-9809. --- Resolution: Fixed Fix FindBugs found bugs in hive-exec

[jira] [Updated] (HIVE-9809) Fix FindBugs found bugs in hive-exec

2015-02-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9809: -- Attachment: HIVE-9809.1.patch patch #1 Fix FindBugs found bugs in hive-exec

[jira] [Updated] (HIVE-9857) Create Factorial UDF

2015-03-04 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9857: -- Description: Function signature: factorial(int a): bigint For example 5!= 5*4*3*2*1=120

[jira] [Updated] (HIVE-9858) Create cbrt (cube root) UDF

2015-03-04 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9858: -- Component/s: UDF Create cbrt (cube root) UDF ---

[jira] [Updated] (HIVE-9864) Refactor get_json_object udf to use Jayway JsonPath

2015-03-04 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9864: -- Summary: Refactor get_json_object udf to use Jayway JsonPath (was: Refactor

[jira] [Updated] (HIVE-9744) Move common arguments validation and value extraction code to GenericUDF

2015-02-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9744: -- Attachment: HIVE-9744.2.patch patch #2 Move common arguments validation and value

[jira] [Updated] (HIVE-9738) create SOUNDEX udf

2015-02-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9738: -- Attachment: HIVE-9738.2.patch patch #2 create SOUNDEX udf --

[jira] [Updated] (HIVE-9791) insert into table throws NPE

2015-02-25 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9791: -- Affects Version/s: 1.2.0 insert into table throws NPE

[jira] [Commented] (HIVE-9791) insert into table throws NPE

2015-02-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14339635#comment-14339635 ] Alexander Pivovarov commented on HIVE-9791: --- probably need to fix smth in

[jira] [Updated] (HIVE-9518) Implement MONTHS_BETWEEN aligned with Oracle one

2015-03-27 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9518: -- Attachment: HIVE-9518.8.patch 2 improvements in GenericUDF.getTimestampValue() related

[jira] [Updated] (HIVE-9518) Implement MONTHS_BETWEEN aligned with Oracle one

2015-03-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9518: -- Attachment: HIVE-9518.7.patch patch #7. UDF considers the difference in time components

[jira] [Updated] (HIVE-9518) Implement MONTHS_BETWEEN aligned with Oracle one

2015-03-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9518: -- Description: This is used to track work to build Oracle like months_between. Here's

[jira] [Resolved] (HIVE-10055) Upgrade Jackson version to the latest stable version

2015-03-23 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov resolved HIVE-10055. Resolution: Won't Fix 2.4.5 API is very different from 1.9.2. We actually can use

[jira] [Commented] (HIVE-9956) use BigDecimal.valueOf instead of new in TestFileDump

2015-03-18 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14367945#comment-14367945 ] Alexander Pivovarov commented on HIVE-9956: --- I think both failed tests have no

[jira] [Updated] (HIVE-9858) Create cbrt (cube root) UDF

2015-03-05 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9858: -- Attachment: HIVE-9858.1.patch patch #1 Create cbrt (cube root) UDF

[jira] [Updated] (HIVE-9518) Implement MONTHS_BETWEEN aligned with Oracle one

2015-03-26 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9518: -- Attachment: HIVE-9518.6.patch patch #6. replaced javaStringObjectInspector with

[jira] [Commented] (HIVE-9518) Implement MONTHS_BETWEEN aligned with Oracle one

2015-03-23 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14376464#comment-14376464 ] Alexander Pivovarov commented on HIVE-9518: --- Hi [~jdere] I know you implemented

[jira] [Updated] (HIVE-9864) Create UDF jsonpath which support full JsonPath syntax

2015-03-23 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9864: -- Summary: Create UDF jsonpath which support full JsonPath syntax (was: Refactor

[jira] [Updated] (HIVE-9864) Create UDF jsonpath which support full JsonPath syntax

2015-03-23 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-9864: -- Description: Existing udf get_json_object supports limited We can use Jayway JsonPath

[jira] [Commented] (HIVE-9859) Create bitwise left/right shift UDFs

2015-03-23 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14376631#comment-14376631 ] Alexander Pivovarov commented on HIVE-9859: --- Sure, if no reply from Harish by Wed

[jira] [Updated] (HIVE-10059) Make udaf_percentile_approx_23.q test more stable

2015-03-23 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10059?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10059: --- Attachment: HIVE-10059.1.patch patch #1 Make udaf_percentile_approx_23.q test more

[jira] [Updated] (HIVE-10159) HashTableSinkDesc and MapJoinDesc keyTblDesc can be replaced by JoinDesc.keyTableDesc

2015-04-02 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10159: --- Attachment: HIVE-10159.1.patch Looks like smb were fixed. re-attaching patch #1

[jira] [Assigned] (HIVE-2327) Optimize REGEX UDFs with constant parameter information

2015-04-02 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov reassigned HIVE-2327: - Assignee: Alexander Pivovarov Optimize REGEX UDFs with constant parameter

[jira] [Commented] (HIVE-3299) Create UDF DAYNAME(date)

2015-04-10 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14490806#comment-14490806 ] Alexander Pivovarov commented on HIVE-3299: --- Test results look good. Failed tests

[jira] [Updated] (HIVE-3404) Create quarter UDF

2015-04-25 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-3404: -- Attachment: HIVE-3404.3.patch patch #3 - add VOID_GROUP to checkArgGroups - add null

[jira] [Updated] (HIVE-3404) Create quarter UDF

2015-04-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-3404: -- Attachment: HIVE-3404.2.patch patch #2. extends GenericUDF Create quarter UDF

[jira] [Updated] (HIVE-3404) Create quarter UDF

2015-04-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-3404: -- Summary: Create quarter UDF (was: UDF to obtain the quarter of an year if a date or

[jira] [Updated] (HIVE-3404) Create quarter UDF

2015-04-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-3404: -- Description: The function QUARTER(date) would return the quarter from a string / date /

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

2015-04-25 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10485: --- Description: MD5(str) Calculates an MD5 128-bit checksum for the string. The value is

[jira] [Updated] (HIVE-3404) Create quarter UDF

2015-04-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-3404: -- Attachment: HIVE-3404.2.patch Create quarter UDF --

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

2015-04-25 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10485: --- Description: MD5(str) Calculates an MD5 128-bit checksum for the string. The value is

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

2015-04-25 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10485: --- Description: MD5(str) Calculates an MD5 128-bit checksum for UTF-8 string. The value

[jira] [Commented] (HIVE-9645) Constant folding case NULL equality

2015-04-25 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14512312#comment-14512312 ] Alexander Pivovarov commented on HIVE-9645: --- Why VOID added to obtainIntConverter

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

2015-04-25 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10485: --- Attachment: HIVE-10485.1.patch patch #1 Create md5 UDF --

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

2015-04-22 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14507869#comment-14507869 ] Alexander Pivovarov commented on HIVE-10276: The function description was

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

2015-04-22 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-10276: --- Labels: (was: TODOC1.2) Implement date_format(timestamp, fmt) UDF

[jira] [Assigned] (HIVE-3404) UDF to obtain the quarter of an year if a date or timestamp is given .

2015-04-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov reassigned HIVE-3404: - Assignee: Alexander Pivovarov UDF to obtain the quarter of an year if a date or

[jira] [Updated] (HIVE-3404) UDF to obtain the quarter of an year if a date or timestamp is given .

2015-04-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander Pivovarov updated HIVE-3404: -- Description: Hive current releases lacks a function which returns the quarter of an year

[jira] [Commented] (HIVE-3404) UDF to obtain the quarter of an year if a date or timestamp is given .

2015-04-24 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14511625#comment-14511625 ] Alexander Pivovarov commented on HIVE-3404: --- The following expression can be used

[jira] [Commented] (HIVE-10488) cast DATE as TIMESTAMP returns incorrect values

2015-04-30 Thread Alexander Pivovarov (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14521089#comment-14521089 ] Alexander Pivovarov commented on HIVE-10488: looks like Orc table contains int

  1   2   3   4   >