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 2009/07/28 19:47:14 UTC
[jira] Created: (HIVE-701) lots of reserved keywords in hive
lots of reserved keywords in hive
---------------------------------
Key: HIVE-701
URL: https://issues.apache.org/jira/browse/HIVE-701
Project: Hadoop Hive
Issue Type: New Feature
Components: Query Processor
Reporter: Namit Jain
There is a problem if we want to use some reserved keywords:
for example, creating a function of name left/right ? left/right is already a reserved keyword.
The other way around should also be possible - if we want to add a 'show tables status' and some applications already use status as a column name, they should not break
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-701) lots of reserved keywords in hive
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12736332#action_12736332 ]
Ashish Thusoo commented on HIVE-701:
------------------------------------
This came up on show table status. It so happens as you pointed out that status is being used for column names and if we put it into a keyword now, it will break existing scripts. Any ideas on how to address this? I think this is going to be tricky with antlr.
> lots of reserved keywords in hive
> ---------------------------------
>
> Key: HIVE-701
> URL: https://issues.apache.org/jira/browse/HIVE-701
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
>
> There is a problem if we want to use some reserved keywords:
> for example, creating a function of name left/right ? left/right is already a reserved keyword.
> The other way around should also be possible - if we want to add a 'show tables status' and some applications already use status as a column name, they should not break
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-701) lots of reserved keywords in hive
Posted by "Prasad Chakka (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12736183#action_12736183 ]
Prasad Chakka commented on HIVE-701:
------------------------------------
i think quoted reserved words work fine as column tables or table names. that is how mysql works and i remember someone making this fix long time ago. if not then we should make that fix as part of this JIRA.
> lots of reserved keywords in hive
> ---------------------------------
>
> Key: HIVE-701
> URL: https://issues.apache.org/jira/browse/HIVE-701
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
>
> There is a problem if we want to use some reserved keywords:
> for example, creating a function of name left/right ? left/right is already a reserved keyword.
> The other way around should also be possible - if we want to add a 'show tables status' and some applications already use status as a column name, they should not break
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-701) lots of reserved keywords in hive
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12736262#action_12736262 ]
Namit Jain commented on HIVE-701:
---------------------------------
That's right -
mysql> create table `tst2`(`table` int);
ERROR 1050 (42S01): Table 'tst2' already exists
mysql> create table `create`(`table` int);
Query OK, 0 rows affected (0.05 sec)
However, that is not good enough for hive - where a lot of the keywords which we might want to reserve in the future are already being used by applications
> lots of reserved keywords in hive
> ---------------------------------
>
> Key: HIVE-701
> URL: https://issues.apache.org/jira/browse/HIVE-701
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
>
> There is a problem if we want to use some reserved keywords:
> for example, creating a function of name left/right ? left/right is already a reserved keyword.
> The other way around should also be possible - if we want to add a 'show tables status' and some applications already use status as a column name, they should not break
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.