[jira] [Commented] (HIVE-4472) OR, NOT Filter logic can lose an array, and always takes time O(VectorizedRowBatch.DEFAULT_SIZE)

2013-05-16 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13659757#comment-13659757 ] Eric Hanson commented on HIVE-4472: --- I posted additional comments to review board. Patch

[jira] [Commented] (HIVE-4575) In place filtering in Not Filter doesn't handle nulls correctly.

2013-05-17 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13661029#comment-13661029 ] Eric Hanson commented on HIVE-4575: --- I'm not sure I understand the problem here. Can you

[jira] [Commented] (HIVE-4575) In place filtering in Not Filter doesn't handle nulls correctly.

2013-05-17 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13661083#comment-13661083 ] Eric Hanson commented on HIVE-4575: --- I did the following in SQL Server: create table t(a

[jira] [Commented] (HIVE-4548) Speed up vectorized LIKE filter for special cases abc%, %abc and %abc%

2013-05-17 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13661144#comment-13661144 ] Eric Hanson commented on HIVE-4548: --- Posted review. Looks good overall! Needs a few small

[jira] [Commented] (HIVE-4553) Column Column, and Column Scalar vectorized execution tests

2013-05-17 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13661150#comment-13661150 ] Eric Hanson commented on HIVE-4553: --- This looks good! Thanks Tony. I think it's ready to

[jira] [Commented] (HIVE-4534) IsNotNull and NotCol incorrectly handle nulls.

2013-05-17 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13661160#comment-13661160 ] Eric Hanson commented on HIVE-4534: --- Please put final patch on review board.

[jira] [Commented] (HIVE-4495) Implement vectorized string substr

2013-05-21 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13663551#comment-13663551 ] Eric Hanson commented on HIVE-4495: --- The latest patch appears functionally correct but

[jira] [Commented] (HIVE-4548) Speed up vectorized LIKE filter for special cases abc%, %abc and %abc%

2013-05-21 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13663607#comment-13663607 ] Eric Hanson commented on HIVE-4548: --- See my comments on Review Board. It looks good but I

[jira] [Commented] (HIVE-4579) Create a SARG interface for RecordReaders

2013-05-22 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13664321#comment-13664321 ] Eric Hanson commented on HIVE-4579: --- Consider adding Column IN (list-of-constants) as a

[jira] [Commented] (HIVE-4548) Speed up vectorized LIKE filter for special cases abc%, %abc and %abc%

2013-05-22 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13664336#comment-13664336 ] Eric Hanson commented on HIVE-4548: --- Can you confirm if there is a problem or not? E.g.

[jira] [Commented] (HIVE-4548) Speed up vectorized LIKE filter for special cases abc%, %abc and %abc%

2013-05-22 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13664572#comment-13664572 ] Eric Hanson commented on HIVE-4548: --- It appears that all the specific characters you are

[jira] [Created] (HIVE-4592) ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

2013-05-22 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4592: - Summary: ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results Key: HIVE-4592 URL: https://issues.apache.org/jira/browse/HIVE-4592

[jira] [Commented] (HIVE-4592) ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

2013-05-22 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13664761#comment-13664761 ] Eric Hanson commented on HIVE-4592: --- Found some other issues in null propagation as well.

[jira] [Work started] (HIVE-4592) ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

2013-05-22 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-4592 started by Eric Hanson. ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

[jira] [Updated] (HIVE-4592) ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

2013-05-23 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4592: -- Attachment: HIVE-4592.1.patch ColumnArithmeticColumn.txt template never sets output isNull to

[jira] [Commented] (HIVE-4592) ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

2013-05-23 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13665535#comment-13665535 ] Eric Hanson commented on HIVE-4592: --- Let me look at the other templates. I expect I will

[jira] [Commented] (HIVE-4592) ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

2013-05-23 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13665855#comment-13665855 ] Eric Hanson commented on HIVE-4592: --- Another issue is that output Long column vectors

[jira] [Commented] (HIVE-4592) ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

2013-05-23 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13665934#comment-13665934 ] Eric Hanson commented on HIVE-4592: --- Completed review and update of Col-Col, Col-Scalar,

[jira] [Updated] (HIVE-4592) ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

2013-05-23 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4592: -- Attachment: HIVE-4592.3.patch ColumnArithmeticColumn.txt template never sets output isNull to

[jira] [Updated] (HIVE-4592) ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

2013-05-23 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4592: -- Status: Patch Available (was: In Progress) ColumnArithmeticColumn.txt template never sets output

[jira] [Commented] (HIVE-4592) ColumnArithmeticColumn.txt template never sets output isNull to true; can give wrong results

2013-05-24 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13666422#comment-13666422 ] Eric Hanson commented on HIVE-4592: --- Okay, I will do that.

[jira] [Updated] (HIVE-4592) fix failure to output isNull to true and other NULL propagation issues; update arithmetic tests

2013-05-24 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4592: -- Summary: fix failure to output isNull to true and other NULL propagation issues; update arithmetic

[jira] [Updated] (HIVE-4592) fix failure to set output isNull to true and other NULL propagation issues; update arithmetic tests

2013-05-24 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4592: -- Attachment: HIVE-4592.4.patch fix failure to set output isNull to true and other NULL propagation

[jira] [Commented] (HIVE-4592) fix failure to set output isNull to true and other NULL propagation issues; update arithmetic tests

2013-05-24 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1372#comment-1372 ] Eric Hanson commented on HIVE-4592: --- Patch is ready to go. See review board entry

[jira] [Commented] (HIVE-4495) Implement vectorized string substr

2013-05-28 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13668409#comment-13668409 ] Eric Hanson commented on HIVE-4495: --- Tim, please attach the patch to this JIRA. The

[jira] [Commented] (HIVE-4548) Speed up vectorized LIKE filter for special cases abc%, %abc and %abc%

2013-05-28 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13668423#comment-13668423 ] Eric Hanson commented on HIVE-4548: --- Teddy, This look good. Thanks! Please add a comment

[jira] [Commented] (HIVE-4070) Like operator in Hive is case sensitive while in MySQL (and most likely other DBs) it's case insensitive

2013-05-28 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13668559#comment-13668559 ] Eric Hanson commented on HIVE-4070: --- There's an effort to add vectorized query execution

[jira] [Updated] (HIVE-4160) Vectorized Query Execution in Hive

2013-05-28 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4160: -- Attachment: Hive-Vectorized-Query-Execution-Design-rev8.pdf Vectorized Query Execution in Hive

[jira] [Updated] (HIVE-4160) Vectorized Query Execution in Hive

2013-05-28 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4160: -- Attachment: Hive-Vectorized-Query-Execution-Design-rev8.docx Vectorized Query Execution in Hive

[jira] [Commented] (HIVE-4160) Vectorized Query Execution in Hive

2013-05-28 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13668778#comment-13668778 ] Eric Hanson commented on HIVE-4160: --- Updated design spec with new section by Remus Rusanu

[jira] [Commented] (HIVE-4608) Vectorized UDFs for Timestamp in nanoseconds

2013-05-28 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13668826#comment-13668826 ] Eric Hanson commented on HIVE-4608: --- Hi Gopal, can you put the patch on Review Board

[jira] [Commented] (HIVE-4579) Create a SARG interface for RecordReaders

2013-05-28 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13668881#comment-13668881 ] Eric Hanson commented on HIVE-4579: --- Overall this looks great. One issue that I think

[jira] [Commented] (HIVE-4579) Create a SARG interface for RecordReaders

2013-05-29 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13669545#comment-13669545 ] Eric Hanson commented on HIVE-4579: --- Since SARGs are always for filters, not for

[jira] [Commented] (HIVE-4608) Vectorized UDFs for Timestamp in nanoseconds

2013-05-30 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13670741#comment-13670741 ] Eric Hanson commented on HIVE-4608: --- Please see my comments on review board.

[jira] [Commented] (HIVE-4608) Vectorized UDFs for Timestamp in nanoseconds

2013-05-31 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13671721#comment-13671721 ] Eric Hanson commented on HIVE-4608: --- Looks good! Thanks Gopal.

[jira] [Commented] (HIVE-4642) Implement vectorized RLIKE and REGEXP filter expressions

2013-05-31 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13671867#comment-13671867 ] Eric Hanson commented on HIVE-4642: --- This is for a later milestone, not the first

[jira] [Created] (HIVE-4642) Implement vectorized RLIKE and REGEXP filter expressions

2013-05-31 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4642: - Summary: Implement vectorized RLIKE and REGEXP filter expressions Key: HIVE-4642 URL: https://issues.apache.org/jira/browse/HIVE-4642 Project: Hive Issue Type:

[jira] [Commented] (HIVE-4642) Implement vectorized RLIKE and REGEXP filter expressions

2013-06-04 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13674690#comment-13674690 ] Eric Hanson commented on HIVE-4642: --- I think this sounds good except that using

[jira] [Commented] (HIVE-4655) Vectorization not working with negative constants, hive doesn't fold constants.

2013-06-04 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13675100#comment-13675100 ] Eric Hanson commented on HIVE-4655: --- Can you put this on review board please?

[jira] [Created] (HIVE-4665) error at VectorExecMapper.close in group-by-agg query over ORC, vectorized

2013-06-05 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4665: - Summary: error at VectorExecMapper.close in group-by-agg query over ORC, vectorized Key: HIVE-4665 URL: https://issues.apache.org/jira/browse/HIVE-4665 Project: Hive

[jira] [Created] (HIVE-4668) wrong results for query with modulo (%) in WHERE clause filter

2013-06-05 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4668: - Summary: wrong results for query with modulo (%) in WHERE clause filter Key: HIVE-4668 URL: https://issues.apache.org/jira/browse/HIVE-4668 Project: Hive Issue

[jira] [Commented] (HIVE-4665) error at VectorExecMapper.close in group-by-agg query over ORC, vectorized

2013-06-05 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13676452#comment-13676452 ] Eric Hanson commented on HIVE-4665: --- Similar error occurs for this query: select

[jira] [Updated] (HIVE-4665) error at VectorExecMapper.close in group-by-agg query over ORC, vectorized

2013-06-05 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4665: -- Assignee: (was: Jitendra Nath Pandey) error at VectorExecMapper.close in group-by-agg query

[jira] [Commented] (HIVE-4654) Remove unused org.apache.hadoop.hive.ql.exec Writables

2013-06-05 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13676529#comment-13676529 ] Eric Hanson commented on HIVE-4654: --- This appears related to some functional bugs. See

[jira] [Updated] (HIVE-4665) error at VectorExecMapper.close in group-by-agg query over ORC, vectorized

2013-06-05 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4665: -- Assignee: Eric Hanson error at VectorExecMapper.close in group-by-agg query over ORC, vectorized

[jira] [Commented] (HIVE-4665) error at VectorExecMapper.close in group-by-agg query over ORC, vectorized

2013-06-05 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13676553#comment-13676553 ] Eric Hanson commented on HIVE-4665: --- I started working on this and was able to get

[jira] [Updated] (HIVE-4665) error at VectorExecMapper.close in group-by-agg query over ORC, vectorized

2013-06-05 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4665: -- Assignee: Jitendra Nath Pandey (was: Eric Hanson) error at VectorExecMapper.close in group-by-agg

[jira] [Created] (HIVE-4676) Optimize COUNT(*) aggregate over vectorized ORC execution path

2013-06-06 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4676: - Summary: Optimize COUNT(*) aggregate over vectorized ORC execution path Key: HIVE-4676 URL: https://issues.apache.org/jira/browse/HIVE-4676 Project: Hive Issue

[jira] [Updated] (HIVE-4676) Optimize COUNT(*) aggregate over vectorized ORC execution path

2013-06-06 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4676: -- Description: The COUNT\(*\) aggregate with the vectorized execution path over ORC should be optimized

[jira] [Updated] (HIVE-4676) Optimize COUNT(*) aggregate over vectorized ORC execution path

2013-06-06 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4676: -- Description: The COUNT\(*\) aggregate with the vectorized execution path over ORC should be optimized

[jira] [Updated] (HIVE-4676) Optimize COUNT(*) aggregate over vectorized ORC execution path

2013-06-06 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4676: -- Description: The COUNT(*) aggregate with the vectorized execution path over ORC should be optimized

[jira] [Updated] (HIVE-4676) Optimize COUNT(*) aggregate over vectorized ORC execution path

2013-06-06 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4676: -- Description: The COUNT\(*\) aggregate with the vectorized execution path over ORC should be optimized

[jira] [Updated] (HIVE-4676) Optimize COUNT(*) aggregate over vectorized ORC execution path

2013-06-06 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4676: -- Description: The COUNT\(*\) aggregate with the vectorized execution path over ORC should be optimized

[jira] [Updated] (HIVE-4676) Optimize COUNT(*) aggregate over vectorized ORC execution path

2013-06-06 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4676: -- Description: The COUNT\(*\) aggregate with the vectorized execution path over ORC should be optimized

[jira] [Commented] (HIVE-4665) error at VectorExecMapper.close in group-by-agg query over ORC, vectorized

2013-06-06 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13677331#comment-13677331 ] Eric Hanson commented on HIVE-4665: --- Looks good! error at

[jira] [Commented] (HIVE-4665) error at VectorExecMapper.close in group-by-agg query over ORC, vectorized

2013-06-06 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13677364#comment-13677364 ] Eric Hanson commented on HIVE-4665: --- I applied this patch to my branch and ran both the

[jira] [Created] (HIVE-4678) second clause of AND filter not applied for vectorized execution

2013-06-06 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4678: - Summary: second clause of AND filter not applied for vectorized execution Key: HIVE-4678 URL: https://issues.apache.org/jira/browse/HIVE-4678 Project: Hive Issue

[jira] [Commented] (HIVE-4668) wrong results for query with modulo (%) in WHERE clause filter

2013-06-06 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13677513#comment-13677513 ] Eric Hanson commented on HIVE-4668: --- See also

[jira] [Created] (HIVE-4680) second clause of OR filter not applied in vectorized query execution

2013-06-06 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4680: - Summary: second clause of OR filter not applied in vectorized query execution Key: HIVE-4680 URL: https://issues.apache.org/jira/browse/HIVE-4680 Project: Hive

[jira] [Updated] (HIVE-4680) second clause of OR filter not applied in vectorized query execution

2013-06-06 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4680: -- Description: query: select ddate, count\(\*\) from factsqlengineam_vec_orc where ddate = 2012-05-19

[jira] [Commented] (HIVE-4684) Query with filter constant on left of = and column expression on right does not vectorize

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13678189#comment-13678189 ] Eric Hanson commented on HIVE-4684: --- Similarly, this query does not vectorize: select

[jira] [Created] (HIVE-4685) query using LIKE does not vectorize, then crashes

2013-06-07 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4685: - Summary: query using LIKE does not vectorize, then crashes Key: HIVE-4685 URL: https://issues.apache.org/jira/browse/HIVE-4685 Project: Hive Issue Type: Sub-task

[jira] [Commented] (HIVE-4685) query using LIKE does not vectorize, then crashes

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13678215#comment-13678215 ] Eric Hanson commented on HIVE-4685: --- The same error happens for query: select

[jira] [Commented] (HIVE-4685) query using LIKE does not vectorize, then crashes

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13678251#comment-13678251 ] Eric Hanson commented on HIVE-4685: --- I applied the patch for HIVE-4599 and now the query

[jira] [Updated] (HIVE-4685) query using LIKE does not vectorize

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4685: -- Summary: query using LIKE does not vectorize (was: query using LIKE does not vectorize, then crashes)

[jira] [Commented] (HIVE-4685) query using LIKE does not vectorize

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13678256#comment-13678256 ] Eric Hanson commented on HIVE-4685: --- 4599 appears to take out the printed messages saying

[jira] [Commented] (HIVE-4599) VectorGroupByOperator steals the non-vectorized children and crashes query if vectorization fails

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13678332#comment-13678332 ] Eric Hanson commented on HIVE-4599: --- This patch appears to take out the printed messages

[jira] [Created] (HIVE-4687) incorrect result for max aggregate over int column

2013-06-07 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4687: - Summary: incorrect result for max aggregate over int column Key: HIVE-4687 URL: https://issues.apache.org/jira/browse/HIVE-4687 Project: Hive Issue Type: Sub-task

[jira] [Updated] (HIVE-4687) incorrect result for max aggregate over int column

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4687: -- Assignee: Remus Rusanu incorrect result for max aggregate over int column

[jira] [Commented] (HIVE-4642) Implement vectorized RLIKE and REGEXP filter expressions

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13679690#comment-13679690 ] Eric Hanson commented on HIVE-4642: --- This sounds good. Think about additional common

[jira] [Commented] (HIVE-4695) Unit test failure in TestColumnColumnOperationVectorExpressionEvaluation

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13679760#comment-13679760 ] Eric Hanson commented on HIVE-4695: --- Starting to investigate now. Unit

[jira] [Updated] (HIVE-4695) Unit test failure in TestColumnColumnOperationVectorExpressionEvaluation

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4695: -- Attachment: HIVE-4695.1.patch Unit test failure in

[jira] [Updated] (HIVE-4695) Unit test failure in TestColumnColumnOperationVectorExpressionEvaluation

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4695: -- Status: Patch Available (was: Open) Unit test failure in

[jira] [Commented] (HIVE-4695) Unit test failure in TestColumnColumnOperationVectorExpressionEvaluation

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13679811#comment-13679811 ] Eric Hanson commented on HIVE-4695: --- I made a small change in template

[jira] [Commented] (HIVE-4678) second clause of AND, OR filter not applied for vectorized execution

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13680013#comment-13680013 ] Eric Hanson commented on HIVE-4678: --- fix verified for the repro query given here

[jira] [Updated] (HIVE-4676) Optimize COUNT(*) aggregate over vectorized ORC execution path

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4676: -- Description: The COUNT\(*\) aggregate with the vectorized execution path over ORC should be optimized

[jira] [Commented] (HIVE-4680) second clause of OR filter not applied in vectorized query execution

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13680020#comment-13680020 ] Eric Hanson commented on HIVE-4680: --- I verified that the problem is fixed for the repro

[jira] [Created] (HIVE-4701) Optimize filter Column IN ( list-of-constants ) for vectorized execution

2013-06-10 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4701: - Summary: Optimize filter Column IN ( list-of-constants ) for vectorized execution Key: HIVE-4701 URL: https://issues.apache.org/jira/browse/HIVE-4701 Project: Hive

[jira] [Updated] (HIVE-4701) Optimize filter Column IN ( list-of-constants ) for vectorized execution

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4701: -- Description: OR filters have been optimized to run with vectorized query execution. IN filters of the

[jira] [Created] (HIVE-4702) Unit test failure TestVectorSelectOperator

2013-06-10 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4702: - Summary: Unit test failure TestVectorSelectOperator Key: HIVE-4702 URL: https://issues.apache.org/jira/browse/HIVE-4702 Project: Hive Issue Type: Sub-task

[jira] [Created] (HIVE-4704) TestCase FakeVectorRowBatchFromObjectIterables error

2013-06-10 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4704: - Summary: TestCase FakeVectorRowBatchFromObjectIterables error Key: HIVE-4704 URL: https://issues.apache.org/jira/browse/HIVE-4704 Project: Hive Issue Type:

[jira] [Updated] (HIVE-4704) TestCase FakeVectorRowBatchFromObjectIterables error

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4704: -- Attachment: HIVE-4704.1.patch TestCase FakeVectorRowBatchFromObjectIterables error

[jira] [Updated] (HIVE-4704) TestCase FakeVectorRowBatchFromObjectIterables error

2013-06-10 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4704: -- Status: Patch Available (was: Open) TestCase FakeVectorRowBatchFromObjectIterables error

[jira] [Created] (HIVE-4718) array out of bounds exception near VectorHashKeyWrapper.getBytes() with 2 column GROUP BY

2013-06-11 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4718: - Summary: array out of bounds exception near VectorHashKeyWrapper.getBytes() with 2 column GROUP BY Key: HIVE-4718 URL: https://issues.apache.org/jira/browse/HIVE-4718

[jira] [Updated] (HIVE-4718) array out of bounds exception near VectorHashKeyWrapper.getBytes() with 2 column GROUP BY

2013-06-11 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4718: -- Description: select ddate, disinternalmsft16431, count\(\*\) from factsqlengineam_vec_orc where (ddate

[jira] [Commented] (HIVE-4660) Let there be Tez (aka mrr ftw)

2013-06-12 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13681719#comment-13681719 ] Eric Hanson commented on HIVE-4660: --- Overall the spec looks good. It is cute, but please

[jira] [Commented] (HIVE-4660) Let there be Tez (aka mrr ftw)

2013-06-12 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13681730#comment-13681730 ] Eric Hanson commented on HIVE-4660: --- If the following use case can be handled in Tez,

[jira] [Commented] (HIVE-4642) Implement vectorized RLIKE and REGEXP filter expressions

2013-06-14 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13683558#comment-13683558 ] Eric Hanson commented on HIVE-4642: --- This is great that you are learning about regular

[jira] [Commented] (HIVE-4055) add Date data type

2013-06-21 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13690975#comment-13690975 ] Eric Hanson commented on HIVE-4055: --- Can you please attach a functional specification to

[jira] [Updated] (HIVE-4685) query using LIKE does not vectorize

2013-06-24 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4685: -- Assignee: Eric Hanson query using LIKE does not vectorize ---

[jira] [Updated] (HIVE-4685) query using LIKE does not vectorize

2013-06-24 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4685: -- Fix Version/s: vectorization-branch Status: Patch Available (was: Open) query using

[jira] [Updated] (HIVE-4685) query using LIKE does not vectorize

2013-06-24 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4685: -- Attachment: HIVE-4685.1.patch Patch to update VectorizationContext.java to be able to create vectorized

[jira] [Created] (HIVE-4787) make vectorized LOWER(), UPPER(), LENGTH() work end-to-end; support expression input for vectorized LIKE

2013-06-24 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4787: - Summary: make vectorized LOWER(), UPPER(), LENGTH() work end-to-end; support expression input for vectorized LIKE Key: HIVE-4787 URL: https://issues.apache.org/jira/browse/HIVE-4787

[jira] [Commented] (HIVE-4624) Integrate Vectorzied Substr into Vectorized QE

2013-07-02 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13698374#comment-13698374 ] Eric Hanson commented on HIVE-4624: --- Tim, please give a status update. Thanks.

[jira] [Work started] (HIVE-4787) make vectorized LOWER(), UPPER(), LENGTH() work end-to-end; support expression input for vectorized LIKE

2013-07-05 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-4787 started by Eric Hanson. make vectorized LOWER(), UPPER(), LENGTH() work end-to-end; support expression input for vectorized LIKE

[jira] [Updated] (HIVE-4787) make vectorized LOWER(), UPPER(), LENGTH() work end-to-end; support expression input for vectorized LIKE

2013-07-05 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4787: -- Status: Patch Available (was: In Progress) make vectorized LOWER(), UPPER(), LENGTH() work

[jira] [Updated] (HIVE-4787) make vectorized LOWER(), UPPER(), LENGTH() work end-to-end; support expression input for vectorized LIKE

2013-07-05 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4787: -- Attachment: HIVE-4787.1.patch make vectorized LOWER(), UPPER(), LENGTH() work end-to-end; support

[jira] [Commented] (HIVE-4787) make vectorized LOWER(), UPPER(), LENGTH() work end-to-end; support expression input for vectorized LIKE

2013-07-05 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13701207#comment-13701207 ] Eric Hanson commented on HIVE-4787: --- Depends on patch for HIVE-4685 (initial support for

[jira] [Commented] (HIVE-4642) Implement vectorized RLIKE and REGEXP filter expressions

2013-07-08 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13702148#comment-13702148 ] Eric Hanson commented on HIVE-4642: --- I will look at this today.

[jira] [Created] (HIVE-4821) Implement type casting for all types

2013-07-08 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4821: - Summary: Implement type casting for all types Key: HIVE-4821 URL: https://issues.apache.org/jira/browse/HIVE-4821 Project: Hive Issue Type: Sub-task Affects

  1   2   3   4   5   6   7   8   >