You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2010/08/06 23:23:16 UTC
[jira] Created: (HIVE-1517) ability to select across a database
ability to select across a database
-----------------------------------
Key: HIVE-1517
URL: https://issues.apache.org/jira/browse/HIVE-1517
Project: Hadoop Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Namit Jain
Assignee: Carl Steinbach
After https://issues.apache.org/jira/browse/HIVE-675, we need a way to be able to select across a database for this feature to be useful.
For eg:
use db1
create table foo(....);
use db2
select .. from db1.foo.....
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1517) ability to select across a database
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1517:
---------------------------------
Attachment: HIVE-1517.1.patch.txt
> ability to select across a database
> -----------------------------------
>
> Key: HIVE-1517
> URL: https://issues.apache.org/jira/browse/HIVE-1517
> Project: Hadoop Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Carl Steinbach
> Fix For: 0.6.0, 0.7.0
>
> Attachments: HIVE-1517.1.patch.txt
>
>
> After https://issues.apache.org/jira/browse/HIVE-675, we need a way to be able to select across a database for this feature to be useful.
> For eg:
> use db1
> create table foo(....);
> use db2
> select .. from db1.foo.....
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1517) ability to select across a database
Posted by "John Sichi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12912621#action_12912621 ]
John Sichi commented on HIVE-1517:
----------------------------------
@Carl: this is just a checkpoint patch, right? Since this didn't make the Friday cut, can we move it to 0.7?
> ability to select across a database
> -----------------------------------
>
> Key: HIVE-1517
> URL: https://issues.apache.org/jira/browse/HIVE-1517
> Project: Hadoop Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Carl Steinbach
> Fix For: 0.6.0, 0.7.0
>
> Attachments: HIVE-1517.1.patch.txt
>
>
> After https://issues.apache.org/jira/browse/HIVE-675, we need a way to be able to select across a database for this feature to be useful.
> For eg:
> use db1
> create table foo(....);
> use db2
> select .. from db1.foo.....
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1517) ability to select across a database
Posted by "John Sichi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12896703#action_12896703 ]
John Sichi commented on HIVE-1517:
----------------------------------
This case needs to work:
{noformat}
use db1;
create table t(...);
create view v as select * from t;
use db2;
select * from db1.v;
{noformat}
What this means is that when we store the definition of v, we need to store a fully-qualified db1.t reference. Otherwise, when we expand the view in the later query, we'll look for t in db2 (incorrect) rather than db1 (correct).
> ability to select across a database
> -----------------------------------
>
> Key: HIVE-1517
> URL: https://issues.apache.org/jira/browse/HIVE-1517
> Project: Hadoop Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Carl Steinbach
>
> After https://issues.apache.org/jira/browse/HIVE-675, we need a way to be able to select across a database for this feature to be useful.
> For eg:
> use db1
> create table foo(....);
> use db2
> select .. from db1.foo.....
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1517) ability to select across a database
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1517:
---------------------------------
Fix Version/s: (was: 0.6.0)
@John: Yes, it's a checkpoint patch. Moving this to 0.7.0.
> ability to select across a database
> -----------------------------------
>
> Key: HIVE-1517
> URL: https://issues.apache.org/jira/browse/HIVE-1517
> Project: Hadoop Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Carl Steinbach
> Fix For: 0.7.0
>
> Attachments: HIVE-1517.1.patch.txt
>
>
> After https://issues.apache.org/jira/browse/HIVE-675, we need a way to be able to select across a database for this feature to be useful.
> For eg:
> use db1
> create table foo(....);
> use db2
> select .. from db1.foo.....
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1517) ability to select across a database
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1517:
---------------------------------
Fix Version/s: 0.6.0
0.7.0
> ability to select across a database
> -----------------------------------
>
> Key: HIVE-1517
> URL: https://issues.apache.org/jira/browse/HIVE-1517
> Project: Hadoop Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Carl Steinbach
> Fix For: 0.6.0, 0.7.0
>
>
> After https://issues.apache.org/jira/browse/HIVE-675, we need a way to be able to select across a database for this feature to be useful.
> For eg:
> use db1
> create table foo(....);
> use db2
> select .. from db1.foo.....
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.