You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Thejas M Nair (JIRA)" <ji...@apache.org> on 2017/10/12 18:48:00 UTC

[jira] [Comment Edited] (HIVE-17765) expose Hive keywords

    [ https://issues.apache.org/jira/browse/HIVE-17765?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16201173#comment-16201173 ] 

Thejas M Nair edited comment on HIVE-17765 at 10/12/17 6:47 PM:
----------------------------------------------------------------

Javadoc for https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getSQLKeywords()
bq. Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.

ODBC behavior seems to be similar, but different -
bq. SQL_KEYWORDS 	string 	A string of all the keywords at the database management system that are not in the ODBC's list of reserved words.
(from https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/odbc/src/tpc/db2z_fngetinfo.html )

However, this patch seems to be returning all the keywords.

cc [~ashutoshc]



was (Author: thejas):
Javadoc for https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getSQLKeywords()
bq. Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.

ODBC behavior seems to be similar, but different -
bq. SQL_KEYWORDS 	string 	A string of all the keywords at the database management system that are not in the ODBC's list of reserved words.
(from https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/odbc/src/tpc/db2z_fngetinfo.html )

However, this patch seems to be returning all the keywords.

> expose Hive keywords 
> ---------------------
>
>                 Key: HIVE-17765
>                 URL: https://issues.apache.org/jira/browse/HIVE-17765
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Sergey Shelukhin
>            Assignee: Sergey Shelukhin
>         Attachments: HIVE-17765.nogen.patch, HIVE-17765.patch
>
>
> This could be useful e.g. for BI tools (via ODBC/JDBC drivers) to decide on SQL capabilities of Hive



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)