[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14385159#comment-14385159 ]
Hive QA commented on HIVE-10120: -------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12707863/HIVE-10120.01.patch {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 8673 tests executed *Failed tests:* {noformat} TestSparkClient - did not produce a TEST-*.xml file org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udaf_percentile_approx_23 org.apache.hive.jdbc.TestSSL.testSSLFetchHttp {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3190/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3190/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3190/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12707863 - PreCommit-HIVE-TRUNK-Build > 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)