[ https://issues.apache.org/jira/browse/HIVE-4391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13637661#comment-13637661 ]
Ashutosh Chauhan commented on HIVE-4391: ---------------------------------------- whereas following non-windowing functions with CTAS succeeds create table t3 as select *, if(c1>10,10,0) from t2; create table t4 as select *, c1*2 from t2; > 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