[
https://issues.apache.org/jira/browse/HIVE-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12992774#comment-12992774
]
Carl Steinbach commented on HIVE-1517:
--------------------------------------
> `db.table` Should be considered ilegal. Is that right?
I think that's correct. See the following page for a complete discussion:
http://dev.mysql.com/doc/refman/5.0/en/identifiers.html
It also looks like we need to tighten up the way the grammar handles
Identifiers:
{code}
Identifier
:
(Letter | Digit) (Letter | Digit | '_')*
| '`' RegexComponent+ '`'
;
RegexComponent
: 'a'..'z' | 'A'..'Z' | '0'..'9' | '_'
| PLUS | STAR | QUESTION | MINUS | DOT
| LPAREN | RPAREN | LSQUARE | RSQUARE | LCURLY | RCURLY
| BITWISEXOR | BITWISEOR | DOLLAR
;
{code}
Defining quoted identifiers in terms of RegexComponent permits a lot of illegal
characters.
I think we actually want something like this:
{code}
Identifier
: (Letter | Digit) (Letter | Digit | '_')*
| '`' (Letter | Digit) (Letter | Digit | '_')* '`'
;
{code}
> ability to select across a database
> -----------------------------------
>
> Key: HIVE-1517
> URL: https://issues.apache.org/jira/browse/HIVE-1517
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Siying Dong
> Priority: Blocker
> Fix For: 0.7.0
>
> Attachments: HIVE-1517.1.patch.txt, HIVE-1517.2.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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
