[DISCUSSION] Should Carbon prohibit to use reserved words in database\table\col name

[Lion.X]

Ref: https://issues.apache.org/jira/browse/CARBONDATA-332

I agree with Harmeet's opinion that it is not a recommended and good approach for using system reserved words in creating data structures like database, tables or columns.

In hive and Oracle, using reserved words is prohibited.

pls give your opinions.

thx

[杰]

agree.  reserved words should be prohibited in carbon.


regards
Jay




------------------ Original ------------------
From:  "Lion.X";<[hidden email]>;
Date:  Mon, Oct 31, 2016 09:51 AM
To:  "dev"<[hidden email]>;

Subject:  [DISCUSSION] Should Carbon prohibit to use reserved words indatabase\table\col name



Ref: https://issues.apache.org/jira/browse/CARBONDATA-332I agree with
Harmeet's opinion that it is not a recommended and good approach for using
system reserved words in creating data structures like database, tables or
columns.In hive and Oracle, using reserved words is prohibited.pls give your
opinions.thx



--
View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/DISCUSSION-Should-Carbon-prohibit-to-use-reserved-words-in-database-table-col-name-tp2467.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.

[Jean-Baptiste Onofré]

+1

Regards
JB

On 10/31/2016 02:51 AM, Lion.X wrote:

> Ref: https://issues.apache.org/jira/browse/CARBONDATA-332I agree with
> Harmeet's opinion that it is not a recommended and good approach for using
> system reserved words in creating data structures like database, tables or
> columns.In hive and Oracle, using reserved words is prohibited.pls give your
> opinions.thx
>
>
>
> --
> View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/DISCUSSION-Should-Carbon-prohibit-to-use-reserved-words-in-database-table-col-name-tp2467.html
> Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.
>

--
Jean-Baptiste Onofré
[hidden email]
http://blog.nanthrax.net
Talend - http://www.talend.com

[Lion.X]

I raised a PR.

https://github.com/apache/incubator-carbondata/pull/273

Pls review.

2016-10-31 13:58 GMT+08:00 Jean-Baptiste Onofré [via Apache CarbonData Mailing List archive] <[hidden email]>:

+1

Regards
JB

On 10/31/2016 02:51 AM, Lion.X wrote:

> Ref: https://issues.apache.org/jira/browse/CARBONDATA-332I agree with
> Harmeet's opinion that it is not a recommended and good approach for using
> system reserved words in creating data structures like database, tables or
> columns.In hive and Oracle, using reserved words is prohibited.pls give your
> opinions.thx
>
>
>
> --
> View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/DISCUSSION-Should-Carbon-prohibit-to-use-reserved-words-in-database-table-col-name-tp2467.html
> Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.
>

--
Jean-Baptiste Onofré
[hidden email]
http://blog.nanthrax.net
Talend - http://www.talend.com

---

If you reply to this email, your message will be added to the discussion below:

http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/DISCUSSION-Should-Carbon-prohibit-to-use-reserved-words-in-database-table-col-name-tp2467p2471.html

To unsubscribe from [DISCUSSION] Should Carbon prohibit to use reserved words in database\table\col name, click here.
NAML

... [show rest of quote]

[Lion.X]

I raised a PR.
https://github.com/apache/incubator-carbondata/pull/273
Pls review.

[Qingqing Zhou]

On Sun, Oct 30, 2016 at 6:51 PM, Lion.X <[hidden email]> wrote:
> Ref: https://issues.apache.org/jira/browse/CARBONDATA-332I agree with
> Harmeet's opinion that it is not a recommended and good approach for
> using system reserved words in creating data structures like database,
> tables or columns.In hive and Oracle, using reserved words is
> prohibited.pls give your opinions.thx
>

I think this is an issue of upper query processing layer instead of
Carbon. For example, Flink/Spark may have a different set of keywords, and
Carbon can't take a side.

Regards,
Qingqing