[jira] [Commented] (HIVE-2366) Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the old COLUMNS table

2011-11-04 Thread Ning Zhang (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13144131#comment-13144131
 ] 

Ning Zhang commented on HIVE-2366:
--

+1. Will commit if tests pass. 

 Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the 
 old COLUMNS table
 ---

 Key: HIVE-2366
 URL: https://issues.apache.org/jira/browse/HIVE-2366
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Reporter: Sohan Jain
Assignee: Sohan Jain
 Attachments: HIVE-2366.1.patch, HIVE-2366.2.patch


 The upgrade scripts for the hive metastore in HIVE-2246 do not upgrade the 
 indexes.  They also need to rename the old COLUMNS table after migration so 
 that old clients will not accidentally access the COLUMNS table.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2366) Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the old COLUMNS table

2011-11-04 Thread Ning Zhang (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13144143#comment-13144143
 ] 

Ning Zhang commented on HIVE-2366:
--

Backported to branch 0.8 as well. 

 Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the 
 old COLUMNS table
 ---

 Key: HIVE-2366
 URL: https://issues.apache.org/jira/browse/HIVE-2366
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Reporter: Sohan Jain
Assignee: Sohan Jain
 Fix For: 0.8.0, 0.9.0

 Attachments: HIVE-2366.1.patch, HIVE-2366.2.patch


 The upgrade scripts for the hive metastore in HIVE-2246 do not upgrade the 
 indexes.  They also need to rename the old COLUMNS table after migration so 
 that old clients will not accidentally access the COLUMNS table.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2366) Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the old COLUMNS table

2011-11-04 Thread Hudson (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1318#comment-1318
 ] 

Hudson commented on HIVE-2366:
--

Integrated in Hive-trunk-h0.21 #1059 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1059/])
HIVE-2366. Metastore upgrade scripts for HIVE-2246 do not migrate indexes 
nor rename the old COLUMNS table (Sohan Jain via Ning Zhang)

nzhang : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1197644
Files : 
* /hive/trunk/metastore/scripts/upgrade/derby/008-HIVE-2246.derby.sql
* /hive/trunk/metastore/scripts/upgrade/derby/008-REVERT-HIVE-2246.derby.sql
* /hive/trunk/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql


 Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the 
 old COLUMNS table
 ---

 Key: HIVE-2366
 URL: https://issues.apache.org/jira/browse/HIVE-2366
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Reporter: Sohan Jain
Assignee: Sohan Jain
 Fix For: 0.8.0, 0.9.0

 Attachments: HIVE-2366.1.patch, HIVE-2366.2.patch


 The upgrade scripts for the hive metastore in HIVE-2246 do not upgrade the 
 indexes.  They also need to rename the old COLUMNS table after migration so 
 that old clients will not accidentally access the COLUMNS table.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2366) Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the old COLUMNS table

2011-11-04 Thread Hudson (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13144489#comment-13144489
 ] 

Hudson commented on HIVE-2366:
--

Integrated in Hive-0.8.0-SNAPSHOT-h0.21 #82 (See 
[https://builds.apache.org/job/Hive-0.8.0-SNAPSHOT-h0.21/82/])
HIVE-2366. Metastore upgrade scripts for HIVE-2246 do not migrate indexes 
nor rename the old COLUMNS table (Sohan Jain via Ning Zhang)

nzhang : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1197646
Files : 
* 
/hive/branches/branch-0.8/metastore/scripts/upgrade/derby/008-HIVE-2246.derby.sql
* 
/hive/branches/branch-0.8/metastore/scripts/upgrade/derby/008-REVERT-HIVE-2246.derby.sql
* 
/hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql


 Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the 
 old COLUMNS table
 ---

 Key: HIVE-2366
 URL: https://issues.apache.org/jira/browse/HIVE-2366
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Reporter: Sohan Jain
Assignee: Sohan Jain
 Fix For: 0.8.0, 0.9.0

 Attachments: HIVE-2366.1.patch, HIVE-2366.2.patch


 The upgrade scripts for the hive metastore in HIVE-2246 do not upgrade the 
 indexes.  They also need to rename the old COLUMNS table after migration so 
 that old clients will not accidentally access the COLUMNS table.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2366) Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the old COLUMNS table

2011-11-03 Thread Paul Yang (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13143630#comment-13143630
 ] 

Paul Yang commented on HIVE-2366:
-

I regenerated the patch based on trunk. Looks good to me as well.

 Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the 
 old COLUMNS table
 ---

 Key: HIVE-2366
 URL: https://issues.apache.org/jira/browse/HIVE-2366
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Reporter: Sohan Jain
Assignee: Sohan Jain
 Attachments: HIVE-2366.1.patch, HIVE-2366.2.patch


 The upgrade scripts for the hive metastore in HIVE-2246 do not upgrade the 
 indexes.  They also need to rename the old COLUMNS table after migration so 
 that old clients will not accidentally access the COLUMNS table.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2366) Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the old COLUMNS table

2011-11-01 Thread Ning Zhang (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13141885#comment-13141885
 ] 

Ning Zhang commented on HIVE-2366:
--

LGTM. Paul, can you double check?

 Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the 
 old COLUMNS table
 ---

 Key: HIVE-2366
 URL: https://issues.apache.org/jira/browse/HIVE-2366
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Reporter: Sohan Jain
Assignee: Sohan Jain
 Attachments: HIVE-2366.1.patch


 The upgrade scripts for the hive metastore in HIVE-2246 do not upgrade the 
 indexes.  They also need to rename the old COLUMNS table after migration so 
 that old clients will not accidentally access the COLUMNS table.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2366) Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the old COLUMNS table

2011-08-10 Thread jirapos...@reviews.apache.org (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13082743#comment-13082743
 ] 

jirapos...@reviews.apache.org commented on HIVE-2366:
-


---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/1460/
---

Review request for hive, Ning Zhang and Paul Yang.


Summary
---

The upgrade scripts for the hive metastore in HIVE-2246 do not upgrade the 
indexes. They also need to rename the old COLUMNS table after migration so that 
old clients will not accidentally access the COLUMNS table.


This addresses bug HIVE-2366.
https://issues.apache.org/jira/browse/HIVE-2366


Diffs
-

  trunk/metastore/scripts/upgrade/derby/008-HIVE-2246.derby.sql 1156396 
  trunk/metastore/scripts/upgrade/derby/008-REVERT-HIVE-2246.derby.sql 1156396 
  trunk/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql 1156396 

Diff: https://reviews.apache.org/r/1460/diff


Testing
---

Tested db migration by hand


Thanks,

Sohan



 Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the 
 old COLUMNS table
 ---

 Key: HIVE-2366
 URL: https://issues.apache.org/jira/browse/HIVE-2366
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Reporter: Sohan Jain
Assignee: Sohan Jain
 Attachments: HIVE-2366.1.patch


 The upgrade scripts for the hive metastore in HIVE-2246 do not upgrade the 
 indexes.  They also need to rename the old COLUMNS table after migration so 
 that old clients will not accidentally access the COLUMNS table.

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