[
https://issues.apache.org/jira/browse/TAJO-1389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14358124#comment-14358124
]
Hyunsik Choi edited comment on TAJO-1389 at 3/12/15 5:33 AM:
-------------------------------------------------------------
According to ANSI SQL standard, double quote (") is for object identifier, and
single quote (') is for string literal value. BTW, Some SQL systems like Hive,
MySQL, and Drill use single quote (') for object identifier.
Nevertheless, JDBC already allows DBMS-dependent identifier quote string.
DatabaseMetaData of JDBC already provides this information. Please refer to
DatabaseMetaData::getIdentifierQuoteString() method. Tajo JDBC already provides
double quote as the identifier quote string via
DatabaseMetaData::getIdentifierQuoteString() API. But, some tools using JDBC
does not use this information correctly. This is not our problem, so we don't
need to parse single quote as identifier quote string.
As far as I know, 'Burst' can choose the base JDBC driver when a user uses a
generic (or external) JDBC driver. Tajo JDBC is almost compatible with
PostgreSQL's JDBC; please see \[1]. If you choose PostgreSQL as a base JDBC
driver, Burst will work without this problem.
\[1]
https://github.com/pgjdbc/pgjdbc/blob/master/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java#L392
was (Author: hyunsik):
According to ANSI SQL standard, double quote (") is for object identifier, and
single quote (') is for string literal value. BTW, Some SQL systems like Hive,
MySQL, and Drill use single quote (') for object identifier.
Nevertheless, JDBC already allows DBMS-dependent identifier quote string.
DatabaseMetaData of JDBC already provides this information. Please refer to
DatabaseMetaData::getIdentifierQuoteString() method. Tajo JDBC already provides
double quote as the identifier quote string via
DatabaseMetaData::getIdentifierQuoteString() API. But, some tools using JDBC
does not use this information correctly. This is not our problem, so we don't
need to parse single quote as identifier quote string.
As far as I know, 'Burst' can choose the base JDBC driver when a user uses a
generic (or external) JDBC driver. Tajo JDBC is almost compatible with
PostgreSQL's JDBC; please see \[1]. If you choose PostgreSQL as a base JDBC
driver, Burst will work without any this problem.
\[1]
https://github.com/pgjdbc/pgjdbc/blob/master/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java#L392
> Add a documentation to introduce available tools for Tajo
> ---------------------------------------------------------
>
> Key: TAJO-1389
> URL: https://issues.apache.org/jira/browse/TAJO-1389
> Project: Tajo
> Issue Type: Bug
> Components: documentation
> Reporter: Hyunsik Choi
> Fix For: 0.11
>
>
> After thin JDBC driver including 0.10.0 release, many tools easily can be
> used for Tajo. It would great if we have some documentation or wiki page to
> introduce them.
> As far as I know, the following tools are available for Tajo. If some
> applications are omitted, please let me know them that you tested.
> *Open source tools:*
> * SQL workbench (http://www.sql-workbench.net/)
> * Tadpole (https://github.com/hangum/TadpoleForDBTools)
> * Squirrel (http://squirrel-sql.sourceforge.net/)
> *Commercial BI tools*
> * ?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
