[jira] Commented: (HIVE-972) support views

2010-01-28 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12806157#action_12806157 ] John Sichi commented on HIVE-972: - Metastore upgrade instructions are here (they assume

[jira] Commented: (HIVE-972) support views

2010-01-20 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12803129#action_12803129 ] John Sichi commented on HIVE-972: - For the wiki, I've updated the LanguageManual pages, and

[jira] Commented: (HIVE-972) support views

2010-01-19 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802417#action_12802417 ] John Sichi commented on HIVE-972: - Re-running tests now. support views -

[jira] Commented: (HIVE-972) support views

2010-01-19 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802549#action_12802549 ] John Sichi commented on HIVE-972: - I have a patch which addresses items 8/9/10/11/12. Is it

[jira] Commented: (HIVE-972) support views

2010-01-19 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802553#action_12802553 ] Zheng Shao commented on HIVE-972: - Good to me. Please upload the new patch. support views

[jira] Commented: (HIVE-972) support views

2010-01-19 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802608#action_12802608 ] Zheng Shao commented on HIVE-972: - John, the last point, can you do 4? We definitely need to

[jira] Commented: (HIVE-972) support views

2010-01-19 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802622#action_12802622 ] John Sichi commented on HIVE-972: - Yes, will do. support views -

[jira] Commented: (HIVE-972) support views

2010-01-19 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802656#action_12802656 ] John Sichi commented on HIVE-972: - I set up a MySQL metastore configuration, then created a

[jira] Commented: (HIVE-972) support views

2010-01-19 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802659#action_12802659 ] Zheng Shao commented on HIVE-972: - Thanks John! I will test and commit it now. Please open an

[jira] Commented: (HIVE-972) support views

2010-01-19 Thread Jeff Hammerbacher (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802688#action_12802688 ] Jeff Hammerbacher commented on HIVE-972: Was there a documentation update for this

[jira] Commented: (HIVE-972) support views

2010-01-19 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802689#action_12802689 ] Zheng Shao commented on HIVE-972: - I guess not yet. A good place to put it is

[jira] Commented: (HIVE-972) support views

2010-01-19 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802713#action_12802713 ] John Sichi commented on HIVE-972: - The wiki page describing the development so far is here:

[jira] Commented: (HIVE-972) support views

2010-01-18 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12801980#action_12801980 ] John Sichi commented on HIVE-972: - @Zheng: I just did a dry run of re-applying the patch on

[jira] Commented: (HIVE-972) support views

2010-01-18 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802041#action_12802041 ] Zheng Shao commented on HIVE-972: - @John, what are the test errors that you are getting? We

[jira] Commented: (HIVE-972) support views

2010-01-18 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12802117#action_12802117 ] Zheng Shao commented on HIVE-972: - Namit just committed HIVE-1066 which should fix the test

[jira] Commented: (HIVE-972) support views

2010-01-16 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12801132#action_12801132 ] Zheng Shao commented on HIVE-972: - Another question is metastore database upgrade and

[jira] Commented: (HIVE-972) support views

2010-01-16 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12801267#action_12801267 ] Prasad Chakka commented on HIVE-972: 12. Block alter_table, alter_partition queries in

[jira] Commented: (HIVE-972) support views

2010-01-16 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12801302#action_12801302 ] Zheng Shao commented on HIVE-972: - Good to know we have backward compatibility! BTW, John,

[jira] Commented: (HIVE-972) support views

2010-01-15 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12801064#action_12801064 ] Zheng Shao commented on HIVE-972: - We had a group code-review with John and here are the

[jira] Commented: (HIVE-972) support views

2010-01-14 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800334#action_12800334 ] John Sichi commented on HIVE-972: - Some notes for reviewers: (1) The reason I'm adding

[jira] Commented: (HIVE-972) support views

2010-01-14 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800346#action_12800346 ] Prasad Chakka commented on HIVE-972: regd (3) is storagedescritor needed at all for a

[jira] Commented: (HIVE-972) support views

2010-01-14 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800347#action_12800347 ] John Sichi commented on HIVE-972: - @Prasad: Since we went with the flat catalog model, a

[jira] Commented: (HIVE-972) support views

2010-01-14 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800356#action_12800356 ] Prasad Chakka commented on HIVE-972: I think I set a property in JDO ORM file to make it

[jira] Commented: (HIVE-972) support views

2010-01-14 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800363#action_12800363 ] John Sichi commented on HIVE-972: - @Prasad: DESCRIBE gets the columns of a view the same way

[jira] Commented: (HIVE-972) support views

2010-01-14 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800369#action_12800369 ] Prasad Chakka commented on HIVE-972: Then looks like we do have to keep SD so what is the

[jira] Commented: (HIVE-972) support views

2010-01-14 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800376#action_12800376 ] John Sichi commented on HIVE-972: - Here's my rationale: (1) A view is a logical object, so

[jira] Commented: (HIVE-972) support views

2010-01-14 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800382#action_12800382 ] Prasad Chakka commented on HIVE-972: I thought view definitions are supposed to be

[jira] Commented: (HIVE-972) support views

2010-01-14 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800402#action_12800402 ] John Sichi commented on HIVE-972: - OK, good. To clarify: the column descriptor metadata

[jira] Commented: (HIVE-972) support views

2010-01-14 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800406#action_12800406 ] John Sichi commented on HIVE-972: - One other point for reviewers: If you do CREATE VIEW

[jira] Commented: (HIVE-972) support views

2010-01-13 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12800089#action_12800089 ] Zheng Shao commented on HIVE-972: - bq. Regarding referencing a temporary function from a

[jira] Commented: (HIVE-972) support views

2010-01-08 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12798209#action_12798209 ] John Sichi commented on HIVE-972: - Regarding referencing a temporary function from a view: I

[jira] Commented: (HIVE-972) support views

2010-01-07 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12797847#action_12797847 ] John Sichi commented on HIVE-972: - For view expansion, I've found a parser-based shortcut

[jira] Commented: (HIVE-972) support views

2009-12-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12795461#action_12795461 ] John Sichi commented on HIVE-972: - I have updated the wiki page based on feedback from a

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793711#action_12793711 ] Ashish Thusoo commented on HIVE-972: Pretty comprehensive writeup :) Here are my

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793746#action_12793746 ] Prasad Chakka commented on HIVE-972: .. continuing discussion from hive-users@ 1.

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793750#action_12793750 ] Prasad Chakka commented on HIVE-972: Sorry, the bold formatting was unintentional and a

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793770#action_12793770 ] John Sichi commented on HIVE-972: - Prasad, regarding select *: the static expansion

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793799#action_12793799 ] Namit Jain commented on HIVE-972: - I think we can go with Lenient Dependency Invalidation -

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793806#action_12793806 ] John Sichi commented on HIVE-972: - Prasad, regarding partitioned views, I'll talk to you

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793811#action_12793811 ] Prasad Chakka commented on HIVE-972: @john, i will be in office on all work days next

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793882#action_12793882 ] Prasad Chakka commented on HIVE-972: mainly i don't understand how 'show partitions' will

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793888#action_12793888 ] Namit Jain commented on HIVE-972: - If we are allowing partitioned views, show partitions

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793907#action_12793907 ] John Sichi commented on HIVE-972: - Namit, Prasad, I'm starting to understand. I suppose we

[jira] Commented: (HIVE-972) support views

2009-12-22 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793908#action_12793908 ] John Sichi commented on HIVE-972: - Namit, alter view viewname compile is a good solution to

[jira] Commented: (HIVE-972) support views

2009-12-21 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12793452#action_12793452 ] John Sichi commented on HIVE-972: - Wiki page for planning out this feature is here; comments

[jira] Commented: (HIVE-972) support views

2009-12-06 Thread Jeff Hammerbacher (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12786751#action_12786751 ] Jeff Hammerbacher commented on HIVE-972: What sort of views? HIVE-29 discusses the