[jira] [Updated] (CARBONDATA-587) for any SQL syntax reserved keywords should be avoided.

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

anubhav tarar updated CARBONDATA-587:
-------------------------------------
    Description:
I Am Able to use reserved keyword in Carbon Table Commands

CREATE TABLE Bug221755915(int int)USING org.apache.spark.sql.CarbonSource;
+---------+--+
| Result  |
+---------+--+
+---------+--+

jdbc:hive2://localhost:10000>  CREATE TABLE null(int int)USING org.apache.spark.sql.CarbonSource;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.267 seconds)

there is no check on identifiers in carbon data

another example

create database join;
Error: org.apache.spark.sql.AnalysisException: cannot recognize input near 'join' '<EOF>' '<EOF>' in create database statement; line 1 pos 16 (state=,code=0)

  was:
I Am Able to use reserved keyword in Carbon Table Commands

CREATE TABLE Bug221755915(int int)USING org.apache.spark.sql.CarbonSource;
+---------+--+
| Result  |
+---------+--+
+---------+--+

jdbc:hive2://localhost:10000>  CREATE TABLE null(int int)USING org.apache.spark.sql.CarbonSource;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.267 seconds)

there is no check on identifiers in carbon data

another example

> for any SQL syntax reserved keywords should be avoided.
> -------------------------------------------------------
>
>                 Key: CARBONDATA-587
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-587
>             Project: CarbonData
>          Issue Type: Bug
>          Components: spark-integration
>    Affects Versions: 1.0.0-incubating
>         Environment: cluster
>            Reporter: anubhav tarar
>            Priority: Minor
>
> I Am Able to use reserved keyword in Carbon Table Commands
> CREATE TABLE Bug221755915(int int)USING org.apache.spark.sql.CarbonSource;
> +---------+--+
> | Result  |
> +---------+--+
> +---------+--+
> jdbc:hive2://localhost:10000>  CREATE TABLE null(int int)USING org.apache.spark.sql.CarbonSource;
> +---------+--+
> | Result  |
> +---------+--+
> +---------+--+
> No rows selected (0.267 seconds)
> there is no check on identifiers in carbon data
> another example
> create database join;
> Error: org.apache.spark.sql.AnalysisException: cannot recognize input near 'join' '<EOF>' '<EOF>' in create database statement; line 1 pos 16 (state=,code=0)

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)