You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Jakob Homan (Created) (JIRA)" <ji...@apache.org> on 2012/02/02 01:15:53 UTC
[jira] [Created] (HIVE-2774) Message when trying to create a view
from a view should give name of offending view
Message when trying to create a view from a view should give name of offending view
-----------------------------------------------------------------------------------
Key: HIVE-2774
URL: https://issues.apache.org/jira/browse/HIVE-2774
Project: Hive
Issue Type: Improvement
Components: Query Processor
Affects Versions: 0.7.1
Reporter: Jakob Homan
Assignee: Jakob Homan
Fix For: 0.9.0
Attachments: HIVE-2774.patch
Currently when trying to create a view that contains another view (a prohibited operation) the exception is:
{noformat}FAILED: Error in semantic analysis: Invalid Table Alias Referencing view from foreign databases is not supported.{noformat}
'Twould be better if this message included the view that caused the error so that when building views from lots of tables, one doesn't need to hunt to figure out which one was the actual view.
--
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] [Updated] (HIVE-2774) Message when trying to create a view
from a view should give name of offending view
Posted by "Ashutosh Chauhan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan updated HIVE-2774:
-----------------------------------
Affects Version/s: 0.9.0
Fix Version/s: (was: 0.9.0)
Unlinking from 0.9
> Message when trying to create a view from a view should give name of offending view
> -----------------------------------------------------------------------------------
>
> Key: HIVE-2774
> URL: https://issues.apache.org/jira/browse/HIVE-2774
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Affects Versions: 0.7.1, 0.9.0
> Reporter: Jakob Homan
> Assignee: Jakob Homan
> Attachments: HIVE-2774.patch
>
>
> Currently when trying to create a view that contains another view (a prohibited operation) the exception is:
> {noformat}FAILED: Error in semantic analysis: Invalid Table Alias Referencing view from foreign databases is not supported.{noformat}
> 'Twould be better if this message included the view that caused the error so that when building views from lots of tables, one doesn't need to hunt to figure out which one was the actual view.
--
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] [Updated] (HIVE-2774) Message when trying to create a view
from a view should give name of offending view
Posted by "Jakob Homan (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jakob Homan updated HIVE-2774:
------------------------------
Attachment: HIVE-2774.patch
Quick patch that adds the offending table name to the message. Not easily testable and easily reasonable, so no tests.
> Message when trying to create a view from a view should give name of offending view
> -----------------------------------------------------------------------------------
>
> Key: HIVE-2774
> URL: https://issues.apache.org/jira/browse/HIVE-2774
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Affects Versions: 0.7.1
> Reporter: Jakob Homan
> Assignee: Jakob Homan
> Fix For: 0.9.0
>
> Attachments: HIVE-2774.patch
>
>
> Currently when trying to create a view that contains another view (a prohibited operation) the exception is:
> {noformat}FAILED: Error in semantic analysis: Invalid Table Alias Referencing view from foreign databases is not supported.{noformat}
> 'Twould be better if this message included the view that caused the error so that when building views from lots of tables, one doesn't need to hunt to figure out which one was the actual view.
--
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] [Updated] (HIVE-2774) Message when trying to create a view
from a view should give name of offending view
Posted by "Jakob Homan (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jakob Homan updated HIVE-2774:
------------------------------
Status: Patch Available (was: Open)
> Message when trying to create a view from a view should give name of offending view
> -----------------------------------------------------------------------------------
>
> Key: HIVE-2774
> URL: https://issues.apache.org/jira/browse/HIVE-2774
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Affects Versions: 0.7.1
> Reporter: Jakob Homan
> Assignee: Jakob Homan
> Fix For: 0.9.0
>
> Attachments: HIVE-2774.patch
>
>
> Currently when trying to create a view that contains another view (a prohibited operation) the exception is:
> {noformat}FAILED: Error in semantic analysis: Invalid Table Alias Referencing view from foreign databases is not supported.{noformat}
> 'Twould be better if this message included the view that caused the error so that when building views from lots of tables, one doesn't need to hunt to figure out which one was the actual view.
--
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-2774) Message when trying to create a view
from a view should give name of offending view
Posted by "Namit Jain (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203167#comment-13203167 ]
Namit Jain commented on HIVE-2774:
----------------------------------
Can you add a negative test ?
Look at ql/src/test/queries/clientnegative for an example ?
> Message when trying to create a view from a view should give name of offending view
> -----------------------------------------------------------------------------------
>
> Key: HIVE-2774
> URL: https://issues.apache.org/jira/browse/HIVE-2774
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Affects Versions: 0.7.1
> Reporter: Jakob Homan
> Assignee: Jakob Homan
> Fix For: 0.9.0
>
> Attachments: HIVE-2774.patch
>
>
> Currently when trying to create a view that contains another view (a prohibited operation) the exception is:
> {noformat}FAILED: Error in semantic analysis: Invalid Table Alias Referencing view from foreign databases is not supported.{noformat}
> 'Twould be better if this message included the view that caused the error so that when building views from lots of tables, one doesn't need to hunt to figure out which one was the actual view.
--
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] [Updated] (HIVE-2774) Message when trying to create a view
from a view should give name of offending view
Posted by "Namit Jain (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-2774:
-----------------------------
Status: Open (was: Patch Available)
> Message when trying to create a view from a view should give name of offending view
> -----------------------------------------------------------------------------------
>
> Key: HIVE-2774
> URL: https://issues.apache.org/jira/browse/HIVE-2774
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Affects Versions: 0.7.1
> Reporter: Jakob Homan
> Assignee: Jakob Homan
> Fix For: 0.9.0
>
> Attachments: HIVE-2774.patch
>
>
> Currently when trying to create a view that contains another view (a prohibited operation) the exception is:
> {noformat}FAILED: Error in semantic analysis: Invalid Table Alias Referencing view from foreign databases is not supported.{noformat}
> 'Twould be better if this message included the view that caused the error so that when building views from lots of tables, one doesn't need to hunt to figure out which one was the actual view.
--
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