hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1448344 - in /hive/branches/ptf-windowing/ql/src: java/org/apache/hadoop/hive/ql/parse/ test/queries/clientnegative/ test/results/clientnegative/
Date Wed, 20 Feb 2013 18:36:30 GMT
Author: hashutosh
Date: Wed Feb 20 18:36:29 2013
New Revision: 1448344

URL: http://svn.apache.org/r1448344
Log:
HIVE-4040: fix ptf negative tests (Prajakta Kalmegh via Ashutosh Chauhan)

Added:
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_HavingLeadWithNoGBYNoWindowing.q
    hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_HavingLeadWithNoGBYNoWindowing.q.out
Removed:
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_HavingLead.q
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_WhereLead.q
    hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_HavingLead.q.out
    hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_WhereLead.q.out
Modified:
    hive/branches/ptf-windowing/ql/src/java/org/apache/hadoop/hive/ql/parse/WindowingSpec.java
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_AmbiguousWindowDefn.q
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_DuplicateWindowAlias.q
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleDistributeClause.q
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleOrderInWindowDefs.q
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatiblePartitionInWindowDefs.q
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleSortClause.q
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_InvalidValueBoundary.q
    hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_NoSortNoDistByClause.q
    hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_AggrFuncsWithNoGBYNoPartDef.q.out
    hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_AmbiguousWindowDefn.q.out
    hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleDistributeClause.q.out
    hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleOrderInWindowDefs.q.out
    hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatiblePartitionInWindowDefs.q.out
    hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleSortClause.q.out
    hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_NoSortNoDistByClause.q.out

Modified: hive/branches/ptf-windowing/ql/src/java/org/apache/hadoop/hive/ql/parse/WindowingSpec.java
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/java/org/apache/hadoop/hive/ql/parse/WindowingSpec.java?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/java/org/apache/hadoop/hive/ql/parse/WindowingSpec.java
(original)
+++ hive/branches/ptf-windowing/ql/src/java/org/apache/hadoop/hive/ql/parse/WindowingSpec.java
Wed Feb 20 18:36:29 2013
@@ -196,8 +196,10 @@ public class WindowingSpec {
   }
 
   private void inferDefaultWindowingSpec(WindowSpec wSpec) {
-    if ( wSpec == null || wSpec.getPartition() == null ||
-        getSourceOfQueryPartitoningSpec() != null ) {
+    if ( wSpec == null
+        || wSpec.getPartition() == null
+        || getSourceOfQueryPartitoningSpec() != null
+        || this.getQueryPartitionSpec() != null) {
       return;
     }
 

Modified: hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_AmbiguousWindowDefn.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_AmbiguousWindowDefn.q?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_AmbiguousWindowDefn.q
(original)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_AmbiguousWindowDefn.q
Wed Feb 20 18:36:29 2013
@@ -22,7 +22,7 @@ sum(p_size) as s3 over (w3) 
 from part 
 distribute by p_mfgr 
 sort by p_mfgr 
-window w1 as rows between 2 preceding and 2 following, 
-       w2 as rows between unbounded preceding and current row, 
+window w1 as (rows between 2 preceding and 2 following), 
+       w2 as (rows between unbounded preceding and current row), 
        w3 as w3;
 

Modified: hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_DuplicateWindowAlias.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_DuplicateWindowAlias.q?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_DuplicateWindowAlias.q
(original)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_DuplicateWindowAlias.q
Wed Feb 20 18:36:29 2013
@@ -19,6 +19,6 @@ select p_mfgr, p_name, p_size, 
 sum(p_size) as s1 over (w1), 
 sum(p_size) as s2 over (w2) 
 from part 
-window w1 as distribute by p_mfgr  sort by p_mfgr rows between 2 preceding and 2 following,

+window w1 as (distribute by p_mfgr  sort by p_mfgr rows between 2 preceding and 2 following),

        w2 as w1, 
-       w2 as rows between unbounded preceding and current row; 
+       w2 as (rows between unbounded preceding and current row); 

Added: hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_HavingLeadWithNoGBYNoWindowing.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_HavingLeadWithNoGBYNoWindowing.q?rev=1448344&view=auto
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_HavingLeadWithNoGBYNoWindowing.q
(added)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_HavingLeadWithNoGBYNoWindowing.q
Wed Feb 20 18:36:29 2013
@@ -0,0 +1,22 @@
+DROP TABLE part;
+
+CREATE TABLE part( 
+    p_partkey INT,
+    p_name STRING,
+    p_mfgr STRING,
+    p_brand STRING,
+    p_type STRING,
+    p_size INT,
+    p_container STRING,
+    p_retailprice DOUBLE,
+    p_comment STRING
+);
+
+LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part;
+
+-- testHavingLeadWithNoGBYNoWindowing
+select  p_mfgr,p_name, p_size 
+from part 
+having lead(p_size, 1) <= p_size 
+distribute by p_mfgr 
+sort by p_name;

Modified: hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleDistributeClause.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleDistributeClause.q?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleDistributeClause.q
(original)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleDistributeClause.q
Wed Feb 20 18:36:29 2013
@@ -16,8 +16,8 @@ LOAD DATA LOCAL INPATH '../data/files/pa
 
 -- testIncompatibleDistributeClause 
 select  p_mfgr,p_name, p_size,  
-rank() as r, denserank() as dr,  
+rank() as r, dense_rank() as dr,  
 sum(p_size) as s over (w1)  
 from part  
 distribute by p_mfgr  
-window w1 as distribute by p_name rows between 2 preceding and 2 following;
\ No newline at end of file
+window w1 as (distribute by p_name rows between 2 preceding and 2 following);
\ No newline at end of file

Modified: hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleOrderInWindowDefs.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleOrderInWindowDefs.q?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleOrderInWindowDefs.q
(original)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleOrderInWindowDefs.q
Wed Feb 20 18:36:29 2013
@@ -21,5 +21,5 @@ sum(p_size) as s2 over (w2) 
 from part 
 distribute by p_mfgr 
 sort by p_mfgr 
-window w1 as distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following,

-       w2 as distribute by p_mfgr sort by p_name rows between unbounded preceding and current
row; 
+window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following),

+       w2 as (distribute by p_mfgr sort by p_name rows between unbounded preceding and current
row); 

Modified: hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatiblePartitionInWindowDefs.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatiblePartitionInWindowDefs.q?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatiblePartitionInWindowDefs.q
(original)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatiblePartitionInWindowDefs.q
Wed Feb 20 18:36:29 2013
@@ -21,5 +21,5 @@ sum(p_size) as s2 over (w2) 
 from part 
 distribute by p_mfgr 
 sort by p_mfgr 
-window w1 as distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following,

-       w2 as distribute by p_name sort by p_name rows between unbounded preceding and current
row; 
+window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following),

+       w2 as (distribute by p_name sort by p_name rows between unbounded preceding and current
row); 

Modified: hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleSortClause.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleSortClause.q?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleSortClause.q
(original)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_IncompatibleSortClause.q
Wed Feb 20 18:36:29 2013
@@ -16,8 +16,8 @@ LOAD DATA LOCAL INPATH '../data/files/pa
 
 -- testIncompatibleSortClause 
 select  p_mfgr,p_name, p_size,  
-rank() as r, denserank() as dr,  
+rank() as r, dense_rank() as dr,  
 sum(p_size) as s over (w1)  
 from part  
 distribute by p_mfgr  
-window w1 as distribute by p_mfgr sort by p_name  rows between 2 preceding and 2 following;
\ No newline at end of file
+window w1 as (distribute by p_mfgr sort by p_name  rows between 2 preceding and 2 following);
\ No newline at end of file

Modified: hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_InvalidValueBoundary.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_InvalidValueBoundary.q?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_InvalidValueBoundary.q
(original)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_InvalidValueBoundary.q
Wed Feb 20 18:36:29 2013
@@ -17,8 +17,8 @@ LOAD DATA LOCAL INPATH '../data/files/pa
 -- testInvalidValueBoundary
 select  p_mfgr,p_name, p_size,   
 sum(p_size) as s over (w1) ,    
-denserank() as dr  
+dense_rank() as dr  
 from part  
 distribute by p_mfgr  
 sort by p_name  
-window w1 as range between p_name 2 less and current row;
\ No newline at end of file
+window w1 as (range between p_name 2 less and current row);
\ No newline at end of file

Modified: hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_NoSortNoDistByClause.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_NoSortNoDistByClause.q?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_NoSortNoDistByClause.q
(original)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientnegative/ptf_negative_NoSortNoDistByClause.q
Wed Feb 20 18:36:29 2013
@@ -16,6 +16,6 @@ LOAD DATA LOCAL INPATH '../data/files/pa
 
 -- testNoSortNoDistByClause 
 select  p_mfgr,p_name, p_size,  
-rank() as r, denserank() as dr  
+rank() as r, dense_rank() as dr  
 from part  
-window w1 as rows between 2 preceding and 2 following;
\ No newline at end of file
+window w1 as (rows between 2 preceding and 2 following);
\ No newline at end of file

Modified: hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_AggrFuncsWithNoGBYNoPartDef.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_AggrFuncsWithNoGBYNoPartDef.q.out?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_AggrFuncsWithNoGBYNoPartDef.q.out
(original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_AggrFuncsWithNoGBYNoPartDef.q.out
Wed Feb 20 18:36:29 2013
@@ -33,4 +33,4 @@ PREHOOK: Output: default@part
 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table
part
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@part
-FAILED: SemanticException 6:5 No partition specification associated with start of PTF chain
. Error encountered near token 's1'
+FAILED: SemanticException 6:5 No partition specification associated with Windowing . Error
encountered near token 's1'

Modified: hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_AmbiguousWindowDefn.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_AmbiguousWindowDefn.q.out?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_AmbiguousWindowDefn.q.out
(original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_AmbiguousWindowDefn.q.out
Wed Feb 20 18:36:29 2013
@@ -33,4 +33,4 @@ PREHOOK: Output: default@part
 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table
part
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@part
-FAILED: SemanticException Window Spec w3  refers to an unknown source 
+FAILED: SemanticException Cycle in Window references [w3, w3]

Added: hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_HavingLeadWithNoGBYNoWindowing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_HavingLeadWithNoGBYNoWindowing.q.out?rev=1448344&view=auto
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_HavingLeadWithNoGBYNoWindowing.q.out
(added)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_HavingLeadWithNoGBYNoWindowing.q.out
Wed Feb 20 18:36:29 2013
@@ -0,0 +1,36 @@
+PREHOOK: query: DROP TABLE part
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE part
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE part( 
+    p_partkey INT,
+    p_name STRING,
+    p_mfgr STRING,
+    p_brand STRING,
+    p_type STRING,
+    p_size INT,
+    p_container STRING,
+    p_retailprice DOUBLE,
+    p_comment STRING
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE part( 
+    p_partkey INT,
+    p_name STRING,
+    p_mfgr STRING,
+    p_brand STRING,
+    p_type STRING,
+    p_size INT,
+    p_container STRING,
+    p_retailprice DOUBLE,
+    p_comment STRING
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@part
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table
part
+PREHOOK: type: LOAD
+PREHOOK: Output: default@part
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table
part
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@part
+FAILED: SemanticException 6:23 Query has no windowing or group by clause: Unsupported place
for having. Error encountered near token 'p_size'

Modified: hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleDistributeClause.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleDistributeClause.q.out?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleDistributeClause.q.out
(original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleDistributeClause.q.out
Wed Feb 20 18:36:29 2013
@@ -33,4 +33,4 @@ PREHOOK: Output: default@part
 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table
part
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@part
-FAILED: SemanticException Window Function 'sum((TOK_TABLE_OR_COL p_size)) w1 partitionColumns=[(TOK_TABLE_OR_COL
p_name)] window(start=range(2 PRECEDING), end=range(2 FOLLOWING))  as s' has an incompatible
partition clause
+FAILED: SemanticException Window Function 'sum' has an incompatible partition clause

Modified: hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleOrderInWindowDefs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleOrderInWindowDefs.q.out?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleOrderInWindowDefs.q.out
(original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleOrderInWindowDefs.q.out
Wed Feb 20 18:36:29 2013
@@ -33,4 +33,4 @@ PREHOOK: Output: default@part
 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table
part
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@part
-FAILED: SemanticException Window Function 'sum((TOK_TABLE_OR_COL p_size)) w2 partitionColumns=[(TOK_TABLE_OR_COL
p_mfgr)] orderColumns=[(TOK_TABLE_OR_COL p_name) ASC] window(start=range(Unbounded PRECEDING),
end=currentRow)  as s2' has an incompatible order clause
+FAILED: SemanticException Window Function 'sum' has an incompatible order clause

Modified: hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatiblePartitionInWindowDefs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatiblePartitionInWindowDefs.q.out?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatiblePartitionInWindowDefs.q.out
(original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatiblePartitionInWindowDefs.q.out
Wed Feb 20 18:36:29 2013
@@ -33,4 +33,4 @@ PREHOOK: Output: default@part
 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table
part
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@part
-FAILED: SemanticException Window Function 'sum((TOK_TABLE_OR_COL p_size)) w2 partitionColumns=[(TOK_TABLE_OR_COL
p_name)] orderColumns=[(TOK_TABLE_OR_COL p_name) ASC] window(start=range(Unbounded PRECEDING),
end=currentRow)  as s2' has an incompatible partition clause
+FAILED: SemanticException Window Function 'sum' has an incompatible partition clause

Modified: hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleSortClause.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleSortClause.q.out?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleSortClause.q.out
(original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_IncompatibleSortClause.q.out
Wed Feb 20 18:36:29 2013
@@ -33,4 +33,4 @@ PREHOOK: Output: default@part
 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table
part
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@part
-FAILED: SemanticException Window Function 'sum((TOK_TABLE_OR_COL p_size)) w1 partitionColumns=[(TOK_TABLE_OR_COL
p_mfgr)] orderColumns=[(TOK_TABLE_OR_COL p_name) ASC] window(start=range(2 PRECEDING), end=range(2
FOLLOWING))  as s' has an incompatible order clause
+FAILED: SemanticException Window Function 'sum' has an incompatible order clause

Modified: hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_NoSortNoDistByClause.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_NoSortNoDistByClause.q.out?rev=1448344&r1=1448343&r2=1448344&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_NoSortNoDistByClause.q.out
(original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientnegative/ptf_negative_NoSortNoDistByClause.q.out
Wed Feb 20 18:36:29 2013
@@ -33,4 +33,4 @@ PREHOOK: Output: default@part
 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table
part
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@part
-FAILED: SemanticException 6:5 No partition specification associated with start of PTF chain
. Error encountered near token '2'
+FAILED: SemanticException 6:5 No partition specification associated with Windowing . Error
encountered near token '2'



Mime
View raw message