[jira] [Updated] (HIVE-10120) Disallow create table with dot/colon in column name
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lefty Leverenz updated HIVE-10120: -- Labels: TODOC1.2 (was: ) > Disallow create table with dot/colon in column name > --- > > Key: HIVE-10120 > URL: https://issues.apache.org/jira/browse/HIVE-10120 > Project: Hive > Issue Type: Improvement > Components: Parser >Reporter: Pengcheng Xiong >Assignee: Pengcheng Xiong > Labels: TODOC1.2 > Fix For: 1.2.0 > > Attachments: HIVE-10120.01.patch, HIVE-10120.02.patch > > > Since we don't allow users to query column names with dot in the middle such > as emp.no, don't allow users to create tables with such columns that cannot > be queried. Fix the documentation to reflect this fix. > Here is an example. Consider this table: > {code} > CREATE TABLE a (`emp.no` string); > select `emp.no` from a; fails with this message: > FAILED: RuntimeException java.lang.RuntimeException: cannot find field emp > from [0:emp.no] > {code} > The hive documentation needs to be fixed: > {code} > (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL) seems > to indicate that any Unicode character can go between the backticks in the > select statement, but it doesn’t like the dot/colon or even select * when > there is a column that has a dot/colon. > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-10120) Disallow create table with dot/colon in column name
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-10120: Component/s: Parser > Disallow create table with dot/colon in column name > --- > > Key: HIVE-10120 > URL: https://issues.apache.org/jira/browse/HIVE-10120 > Project: Hive > Issue Type: Improvement > Components: Parser >Reporter: Pengcheng Xiong >Assignee: Pengcheng Xiong > Fix For: 1.2.0 > > Attachments: HIVE-10120.01.patch, HIVE-10120.02.patch > > > Since we don't allow users to query column names with dot in the middle such > as emp.no, don't allow users to create tables with such columns that cannot > be queried. Fix the documentation to reflect this fix. > Here is an example. Consider this table: > {code} > CREATE TABLE a (`emp.no` string); > select `emp.no` from a; fails with this message: > FAILED: RuntimeException java.lang.RuntimeException: cannot find field emp > from [0:emp.no] > {code} > The hive documentation needs to be fixed: > {code} > (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL) seems > to indicate that any Unicode character can go between the backticks in the > select statement, but it doesn’t like the dot/colon or even select * when > there is a column that has a dot/colon. > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-10120) Disallow create table with dot/colon in column name
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10120: --- Attachment: HIVE-10120.02.patch address [~swarnim]'s comments. > Disallow create table with dot/colon in column name > --- > > Key: HIVE-10120 > URL: https://issues.apache.org/jira/browse/HIVE-10120 > Project: Hive > Issue Type: Improvement >Reporter: Pengcheng Xiong >Assignee: Pengcheng Xiong > Attachments: HIVE-10120.01.patch, HIVE-10120.02.patch > > > Since we don't allow users to query column names with dot in the middle such > as emp.no, don't allow users to create tables with such columns that cannot > be queried. Fix the documentation to reflect this fix. > Here is an example. Consider this table: > {code} > CREATE TABLE a (`emp.no` string); > select `emp.no` from a; fails with this message: > FAILED: RuntimeException java.lang.RuntimeException: cannot find field emp > from [0:emp.no] > {code} > The hive documentation needs to be fixed: > {code} > (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL) seems > to indicate that any Unicode character can go between the backticks in the > select statement, but it doesn’t like the dot/colon or even select * when > there is a column that has a dot/colon. > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-10120) Disallow create table with dot/colon in column name
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10120: --- Attachment: HIVE-10120.01.patch > Disallow create table with dot/colon in column name > --- > > Key: HIVE-10120 > URL: https://issues.apache.org/jira/browse/HIVE-10120 > Project: Hive > Issue Type: Improvement >Reporter: Pengcheng Xiong >Assignee: Pengcheng Xiong > Attachments: HIVE-10120.01.patch > > > Since we don't allow users to query column names with dot in the middle such > as emp.no, don't allow users to create tables with such columns that cannot > be queried. Fix the documentation to reflect this fix. > Here is an example. Consider this table: > {code} > CREATE TABLE a (`emp.no` string); > select `emp.no` from a; fails with this message: > FAILED: RuntimeException java.lang.RuntimeException: cannot find field emp > from [0:emp.no] > {code} > The hive documentation needs to be fixed: > {code} > (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL) seems > to indicate that any Unicode character can go between the backticks in the > select statement, but it doesn’t like the dot/colon or even select * when > there is a column that has a dot/colon. > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-10120) Disallow create table with dot/colon in column name
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10120: --- Description: Since we don't allow users to query column names with dot in the middle such as emp.no, don't allow users to create tables with such columns that cannot be queried. Fix the documentation to reflect this fix. Here is an example. Consider this table: {code} CREATE TABLE a (`emp.no` string); select `emp.no` from a; fails with this message: FAILED: RuntimeException java.lang.RuntimeException: cannot find field emp from [0:emp.no] {code} The hive documentation needs to be fixed: {code} (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL) seems to indicate that any Unicode character can go between the backticks in the select statement, but it doesn’t like the dot/colon or even select * when there is a column that has a dot/colon. {code} was: Since we don't allow users to query column names with dot in the middle such as emp.no, don't allow users to create tables with such columns that cannot be queried. Fix the documentation to reflect this fix. Here is an example. Consider this table: {code} CREATE TABLE a (`emp.no` string); {code} select `emp.no` from a; fails with this message: FAILED: RuntimeException java.lang.RuntimeException: cannot find field emp from [0:emp.no] {code} The hive documentation needs to be fixed: {code} (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL) seems to indicate that any Unicode character can go between the backticks in the select statement, but it doesn’t like the dot/colon or even select * when there is a column that has a dot/colon. {code} > Disallow create table with dot/colon in column name > --- > > Key: HIVE-10120 > URL: https://issues.apache.org/jira/browse/HIVE-10120 > Project: Hive > Issue Type: Improvement >Reporter: Pengcheng Xiong >Assignee: Pengcheng Xiong > > Since we don't allow users to query column names with dot in the middle such > as emp.no, don't allow users to create tables with such columns that cannot > be queried. Fix the documentation to reflect this fix. > Here is an example. Consider this table: > {code} > CREATE TABLE a (`emp.no` string); > select `emp.no` from a; fails with this message: > FAILED: RuntimeException java.lang.RuntimeException: cannot find field emp > from [0:emp.no] > {code} > The hive documentation needs to be fixed: > {code} > (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL) seems > to indicate that any Unicode character can go between the backticks in the > select statement, but it doesn’t like the dot/colon or even select * when > there is a column that has a dot/colon. > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)