[ https://issues.apache.org/jira/browse/HIVE-4391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13638298#comment-13638298 ]
Harish Butani commented on HIVE-4391: ------------------------------------- The failure is because the Table defn contains the following FieldSchema: FieldSchema(name:(tok_function rank tok_windowspec), type:int, comment:null) fails in the name validation check: MetastoreUtils::validateName Investigating why this extra Field is added (there is a FieldSchema for rr) > Windowing function doesn't work in conjunction with CTAS > -------------------------------------------------------- > > Key: HIVE-4391 > URL: https://issues.apache.org/jira/browse/HIVE-4391 > Project: Hive > Issue Type: Bug > Components: PTF-Windowing > Affects Versions: 0.11.0 > Reporter: Ashutosh Chauhan > > Simple CTAS query like following fails > create table t3 as select *, rank() over() as rr from t2; > with exception > FAILED: Error in metadata: InvalidObjectException(message:t3 is not a valid > object name) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira