[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-25 Thread John Sichi (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

John Sichi updated HIVE-2128:
-

Status: Open  (was: Patch Available)

Reran with latest patch and still got failures in these three:

testCliDriver_index_auto_mult_tables
testCliDriver_index_auto_mult_tables_compact
testCliDriver_index_auto_self_join


 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch, HIVE-2128.6.patch, HIVE-2128.7.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-25 Thread Syed S. Albiz (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Syed S. Albiz updated HIVE-2128:


Attachment: HIVE-2128.8.patch

Ah, sorry, forgot to git rebase before regenerating the patch, some of the 
recently landed patches introduced changes to the testcase output.

 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch, HIVE-2128.6.patch, HIVE-2128.7.patch, 
 HIVE-2128.8.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-25 Thread Syed S. Albiz (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Syed S. Albiz updated HIVE-2128:


Status: Patch Available  (was: Open)

 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch, HIVE-2128.6.patch, HIVE-2128.7.patch, 
 HIVE-2128.8.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-25 Thread John Sichi (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

John Sichi updated HIVE-2128:
-

   Resolution: Fixed
Fix Version/s: 0.8.0
 Hadoop Flags: [Reviewed]
   Status: Resolved  (was: Patch Available)

Committed.  Thanks Syed!


 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Fix For: 0.8.0

 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch, HIVE-2128.6.patch, HIVE-2128.7.patch, 
 HIVE-2128.8.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-23 Thread Syed S. Albiz (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Syed S. Albiz updated HIVE-2128:


Status: Patch Available  (was: Open)

 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch, HIVE-2128.6.patch, HIVE-2128.7.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-23 Thread Syed S. Albiz (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Syed S. Albiz updated HIVE-2128:


Attachment: HIVE-2128.7.patch

Sorry, I forgot to regenerate the testcase outputs. Fixed in this patch

 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch, HIVE-2128.6.patch, HIVE-2128.7.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-22 Thread John Sichi (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

John Sichi updated HIVE-2128:
-

Status: Open  (was: Patch Available)

I got failures in the new tests:

testCliDriver_index_auto_mult_tables
testCliDriver_index_auto_mult_tables_compact
testCliDriver_index_auto_self_join

Plus this existing test:

testCliDriver_index_bitmap_auto_partitioned

Maybe you forgot to update the logs?


 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch, HIVE-2128.6.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-21 Thread Syed S. Albiz (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Syed S. Albiz updated HIVE-2128:


Attachment: HIVE-2128.6.patch

 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch, HIVE-2128.6.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-21 Thread Syed S. Albiz (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Syed S. Albiz updated HIVE-2128:


Status: Patch Available  (was: Open)

 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch, HIVE-2128.6.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-19 Thread John Sichi (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

John Sichi updated HIVE-2128:
-

Status: Open  (was: Patch Available)

Comments on Review Board.  After that it looks good to go!

 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-18 Thread Syed S. Albiz (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Syed S. Albiz updated HIVE-2128:


Attachment: HIVE-2128.5.patch

removed unnecessary imports

 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch, 
 HIVE-2128.4.patch, HIVE-2128.5.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-05 Thread Syed S. Albiz (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Syed S. Albiz updated HIVE-2128:


Attachment: HIVE-2128.1.patch

 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
 Attachments: HIVE-2128.1.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-05 Thread Syed S. Albiz (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Syed S. Albiz updated HIVE-2128:


Attachment: HIVE-2128.2.patch

Hmm, you're right, we would need multiple blockfilter files in that case. I'm 
not sure if that is possible though in the framework we have, given that we 
choose one single index query to generate each time at each stage. In the case 
where we have multiple indexes involved at each stage, the index handler is 
responsible for combining index inputs into a single output file. For example, 
I have attached a case that seems like it might cause problems (both src and 
srcpart have indexes built and filters applied), however since the index 
queries are generated separately for separate table scans it seems like there 
is no collision between blockfilter files. Does this address the issue? It 
seems like there might still be a possibility of collision between table and 
blockfilter file, so I wonder if you had a different case in mind?

 Automatic Indexing with multiple tables
 ---

 Key: HIVE-2128
 URL: https://issues.apache.org/jira/browse/HIVE-2128
 Project: Hive
  Issue Type: Improvement
  Components: Indexing
Affects Versions: 0.8.0
Reporter: Russell Melick
Assignee: Syed S. Albiz
 Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch


 Make automatic indexing work with jobs which access multiple tables.  We'll 
 probably need to modify the way that the index input format works in order to 
 associate index formats/files with specific tables.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira