hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dhr...@apache.org
Subject svn commit: r712905 [7/38] - in /hadoop/core/trunk: ./ src/contrib/hive/ src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/ src/contrib/hive/common/src/java/org/apache/hadoop/hive/conf/ src/contrib/hive/conf/ src/contrib/hive/data/files/ src/con...
Date Tue, 11 Nov 2008 01:50:18 GMT
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/case_sensitivity.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/case_sensitivity.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/case_sensitivity.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/case_sensitivity.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE DEST1(Key INT, VALUE STRING);
+CREATE TABLE DEST1(Key INT, VALUE STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM SRC_THRIFT

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/cast1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/cast1.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/cast1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/cast1.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 INT, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 INT, c6 INT, c7 INT);
+CREATE TABLE dest1(c1 INT, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 INT, c6 INT, c7 INT) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src INSERT OVERWRITE TABLE dest1 SELECT 3 + 2, 3.0 + 2, 3 + 2.0, 3.0 + 2.0, 3 + CAST(2.0 AS INT), CAST(1 AS BOOLEAN), CAST(TRUE AS INT) WHERE src.key = 86;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value DOUBLE);
+CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,4)) GROUP BY src.key;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1_limit.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1_limit.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1_limit.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1_limit.q Mon Nov 10 17:50:06 2008
@@ -1,6 +1,6 @@
 set mapred.reduce.tasks=31;
 
-CREATE TABLE dest1(key INT, value DOUBLE);
+CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,4)) GROUP BY src.key LIMIT 5;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1_map.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1_map.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1_map.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby1_map.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,10 @@
+set hive.map.aggr=true;
+
+CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,4)) GROUP BY src.key;
+
+FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,4)) GROUP BY src.key;
+
+SELECT dest1.* FROM dest1;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby2.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key STRING, c1 INT, c2 STRING);
+CREATE TABLE dest1(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby2_map.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby2_map.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby2_map.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby2_map.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,12 @@
+set hive.map.aggr=true;
+
+CREATE TABLE dest1(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,0,1), count(DISTINCT substr(src.value,4)), concat(substr(src.key,0,1),sum(substr(src.value,4))) GROUP BY substr(src.key,0,1);
+
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,0,1), count(DISTINCT substr(src.value,4)), concat(substr(src.key,0,1),sum(substr(src.value,4))) GROUP BY substr(src.key,0,1);
+
+SELECT dest1.* FROM dest1;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby3.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby3.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby3.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby3.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 INT, c2 INT, c3 INT, c4 INT, c5 INT);
+CREATE TABLE dest1(c1 INT, c2 INT, c3 INT, c4 INT, c5 INT) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby3_map.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby3_map.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby3_map.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby3_map.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,12 @@
+set hive.map.aggr=true;
+
+CREATE TABLE dest1(c1 INT, c2 INT, c3 INT, c4 INT, c5 INT) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT sum(substr(src.value,4)), avg(substr(src.value,4)), avg(DISTINCT substr(src.value,4)), max(substr(src.value,4)), min(substr(src.value,4));
+
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT sum(substr(src.value,4)), avg(substr(src.value,4)), avg(DISTINCT substr(src.value,4)), max(substr(src.value,4)), min(substr(src.value,4));
+
+SELECT dest1.* FROM dest1;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby4.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby4.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby4.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby4.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 STRING);
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby4_map.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby4_map.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby4_map.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby4_map.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,10 @@
+set hive.map.aggr=true;
+
+CREATE TABLE dest1(key INT) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM src INSERT OVERWRITE TABLE dest1 SELECT count(1);
+
+FROM src INSERT OVERWRITE TABLE dest1 SELECT count(1);
+
+SELECT dest1.* FROM dest1;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby5.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby5.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby5.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby5.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 INSERT OVERWRITE TABLE dest1 

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby5_map.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby5_map.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby5_map.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby5_map.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,10 @@
+set hive.map.aggr=true;
+
+CREATE TABLE dest1(key INT) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM src INSERT OVERWRITE TABLE dest1 SELECT sum(src.key);
+
+FROM src INSERT OVERWRITE TABLE dest1 SELECT sum(src.key);
+
+SELECT dest1.* FROM dest1;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby6.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby6.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby6.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby6.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 STRING);
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby7.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby7.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby7.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby7.q Mon Nov 10 17:50:06 2008
@@ -1,9 +1,9 @@
-CREATE TABLE DEST1(key INT, value STRING);
-CREATE TABLE DEST2(key INT, value STRING);
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE;
+CREATE TABLE DEST2(key INT, value STRING) STORED AS TEXTFILE;
 
 FROM SRC
 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,4)) GROUP BY SRC.key
 INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,4)) GROUP BY SRC.key;
 
 SELECT DEST1.* FROM DEST1;
-SELECT DEST1.* FROM DEST2;
+SELECT DEST2.* FROM DEST2;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby8.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby8.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby8.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/groupby8.q Mon Nov 10 17:50:06 2008
@@ -1,10 +1,10 @@
-CREATE TABLE DEST1(key INT, value STRING);
-CREATE TABLE DEST2(key INT, value STRING);
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE;
+CREATE TABLE DEST2(key INT, value STRING) STORED AS TEXTFILE;
 
 FROM SRC
 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,4)) GROUP BY SRC.key
 INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,4)) GROUP BY SRC.key;
 
 SELECT DEST1.* FROM DEST1;
-SELECT DEST1.* FROM DEST2;
+SELECT DEST2.* FROM DEST2;
 

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input0.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input0.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input0.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input0.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,5 @@
+EXPLAIN
+SELECT * FROM src; 
+
+SELECT * FROM src; 
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input1.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input1.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE TEST1(A INT, B FLOAT); 
+CREATE TABLE TEST1(A INT, B FLOAT) STORED AS TEXTFILE; 
 
 EXPLAIN
 DESCRIBE TEST1; 

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input10.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input10.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input10.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input10.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE TEST10(key INT, value STRING) PARTITIONED BY(ds STRING, hr STRING);
+CREATE TABLE TEST10(key INT, value STRING) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 DESCRIBE TEST10;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input11.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input11.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input11.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input11.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input11_limit.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input11_limit.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input11_limit.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input11_limit.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input12.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input12.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input12.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input12.q Mon Nov 10 17:50:06 2008
@@ -1,6 +1,6 @@
-CREATE TABLE dest1(key INT, value STRING);
-CREATE TABLE dest2(key INT, value STRING);
-CREATE TABLE dest3(key INT, value STRING) PARTITIONED BY(ds STRING, hr STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
+CREATE TABLE dest2(key INT, value STRING) STORED AS TEXTFILE;
+CREATE TABLE dest3(key INT) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src 

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input13.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input13.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input13.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input13.q Mon Nov 10 17:50:06 2008
@@ -1,6 +1,6 @@
-CREATE TABLE dest1(key INT, value STRING);
-CREATE TABLE dest2(key INT, value STRING);
-CREATE TABLE dest3(key INT, value STRING) PARTITIONED BY(ds STRING, hr STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
+CREATE TABLE dest2(key INT, value STRING) STORED AS TEXTFILE;
+CREATE TABLE dest3(key INT) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input14.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input14.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input14.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input14.q Mon Nov 10 17:50:06 2008
@@ -1,18 +1,18 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM (
   FROM src
-  SELECT TRANSFORM(src.key, src.value) AS (tkey, tvalue) 
-         USING '/bin/cat'
+  SELECT TRANSFORM(src.key, src.value)
+         USING '/bin/cat' AS (tkey, tvalue) 
   CLUSTER BY tkey 
 ) tmap
 INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100;
 
 FROM (
   FROM src
-  SELECT TRANSFORM(src.key, src.value) AS (tkey, tvalue) 
-         USING '/bin/cat'
+  SELECT TRANSFORM(src.key, src.value)
+         USING '/bin/cat' AS (tkey, tvalue) 
   CLUSTER BY tkey 
 ) tmap
 INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input14_limit.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input14_limit.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input14_limit.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input14_limit.q Mon Nov 10 17:50:06 2008
@@ -1,18 +1,18 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM (
   FROM src
-  SELECT TRANSFORM(src.key, src.value) AS (tkey, tvalue) 
-         USING '/bin/cat'
+  SELECT TRANSFORM(src.key, src.value)
+         USING '/bin/cat' AS (tkey, tvalue) 
   CLUSTER BY tkey LIMIT 20
 ) tmap
 INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100;
 
 FROM (
   FROM src
-  SELECT TRANSFORM(src.key, src.value) AS (tkey, tvalue) 
-         USING '/bin/cat'
+  SELECT TRANSFORM(src.key, src.value)
+         USING '/bin/cat' AS (tkey, tvalue) 
   CLUSTER BY tkey LIMIT 20
 ) tmap
 INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input15.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input15.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input15.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input15.q Mon Nov 10 17:50:06 2008
@@ -1,7 +1,7 @@
 EXPLAIN
-CREATE TABLE TEST15(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
+CREATE TABLE TEST15(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
 
-CREATE TABLE TEST15(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
+CREATE TABLE TEST15(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
 
 DESCRIBE TEST15;
 

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input16.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input16.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input16.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input16.q Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 -- TestSerDe is a user defined serde where the default delimiter is Ctrl-B
-CREATE TABLE INPUT16(KEY STRING, VALUE STRING) ROW FORMAT SERIALIZER 'org.apache.hadoop.hive.serde2.TestSerDe';
+CREATE TABLE INPUT16(KEY STRING, VALUE STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' STORED AS TEXTFILE;
 LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT16;
 SELECT INPUT16.VALUE, INPUT16.KEY FROM INPUT16;
 DROP TABLE INPUT16;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input16_cc.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input16_cc.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input16_cc.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input16_cc.q Mon Nov 10 17:50:06 2008
@@ -1,6 +1,7 @@
 -- TestSerDe is a user defined serde where the default delimiter is Ctrl-B
 -- the user is overwriting it with ctrlC
-CREATE TABLE INPUT16_CC(KEY STRING, VALUE STRING) ROW FORMAT SERIALIZER 'org.apache.hadoop.hive.serde2.TestSerDe'  with serdeproperties ('testserde.default.serialization.format'='\003', 'dummy.prop.not.used'='dummyy.val');
+DROP TABLE INPUT16_CC;
+CREATE TABLE INPUT16_CC(KEY STRING, VALUE STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.TestSerDe'  with serdeproperties ('testserde.default.serialization.format'='\003', 'dummy.prop.not.used'='dummyy.val') STORED AS TEXTFILE;
 LOAD DATA LOCAL INPATH '../data/files/kv1_cc.txt' INTO TABLE INPUT16_CC;
 SELECT INPUT16_CC.VALUE, INPUT16_CC.KEY FROM INPUT16_CC;
 DROP TABLE INPUT16_CC;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input17.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input17.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input17.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input17.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,20 @@
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM (
+  FROM src_thrift
+  SELECT TRANSFORM(src_thrift.aint + src_thrift.lint[0], src_thrift.lintstring[0])
+         USING '/bin/cat' AS (tkey, tvalue) 
+  CLUSTER BY tkey 
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue;
+
+FROM (
+  FROM src_thrift
+  SELECT TRANSFORM(src_thrift.aint + src_thrift.lint[0], src_thrift.lintstring[0])
+         USING '/bin/cat' AS (tkey, tvalue) 
+  CLUSTER BY tkey 
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue;
+
+SELECT dest1.* FROM dest1;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input18.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input18.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input18.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input18.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,20 @@
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM (
+  FROM src
+  SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
+         USING '/bin/cat'
+  CLUSTER BY key
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.key, regexp_replace(tmap.value,'\t','+') WHERE tmap.key < 100;
+
+FROM (
+  FROM src
+  SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
+         USING '/bin/cat'
+  CLUSTER BY key
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.key, regexp_replace(tmap.value,'\t','+') WHERE tmap.key < 100;
+
+SELECT dest1.* FROM dest1;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input19.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input19.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input19.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input19.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,3 @@
+create table apachelog(ipaddress STRING,identd STRING,user STRING,finishtime STRING,requestline string,returncode INT,size INT) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe' WITH SERDEPROPERTIES (  'serialization.format'= 'org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol',  'quote.delim'= '("|\\[|\\])',  'field.delim'=' ',  'serialization.null.format'='-'  ) STORED AS TEXTFILE;
+LOAD DATA LOCAL INPATH '../data/files/apache.access.log' INTO TABLE apachelog;
+SELECT a.* FROM apachelog a;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input1_limit.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input1_limit.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input1_limit.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input1_limit.q Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
-CREATE TABLE dest1(key INT, value STRING);
-CREATE TABLE dest2(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
+CREATE TABLE dest2(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input2.q Mon Nov 10 17:50:06 2008
@@ -1,6 +1,8 @@
-CREATE TABLE TEST2a(A INT, B FLOAT); 
+DROP TABLE TEST2a;
+CREATE TABLE TEST2a(A INT, B FLOAT) STORED AS TEXTFILE; 
 DESCRIBE TEST2a; 
-CREATE TABLE TEST2b(A ARRAY<INT>, B FLOAT, C MAP<FLOAT, INT>); 
+DROP TABLE TEST2b;
+CREATE TABLE TEST2b(A ARRAY<INT>, B FLOAT, C MAP<FLOAT, INT>) STORED AS TEXTFILE; 
 DESCRIBE TEST2b; 
 SHOW TABLES;
 DROP TABLE TEST2a;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input3.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input3.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input3.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input3.q Mon Nov 10 17:50:06 2008
@@ -1,9 +1,9 @@
 DROP TABLE TEST3a;
 DROP TABLE TEST3b;
 DROP TABLE TEST3c;
-CREATE TABLE TEST3a(A INT, B FLOAT); 
+CREATE TABLE TEST3a(A INT, B FLOAT) STORED AS TEXTFILE; 
 DESCRIBE TEST3a; 
-CREATE TABLE TEST3b(A ARRAY<INT>, B FLOAT, C MAP<FLOAT, INT>); 
+CREATE TABLE TEST3b(A ARRAY<INT>, B FLOAT, C MAP<FLOAT, INT>) STORED AS TEXTFILE; 
 DESCRIBE TEST3b; 
 SHOW TABLES;
 EXPLAIN

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input4.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input4.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input4.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input4.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE INPUT4(KEY STRING, VALUE STRING);
+CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE;
 EXPLAIN
 LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4;
 LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input4_cb_delim.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input4_cb_delim.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input4_cb_delim.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input4_cb_delim.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE INPUT4_CB(KEY STRING, VALUE STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002' LINES TERMINATED BY '\012';
+CREATE TABLE INPUT4_CB(KEY STRING, VALUE STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002' LINES TERMINATED BY '\012' STORED AS TEXTFILE;
 LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT4_CB;
 SELECT INPUT4_CB.VALUE, INPUT4_CB.KEY FROM INPUT4_CB;
 DROP TABLE INPUT4_CB

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input5.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input5.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input5.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input5.q Mon Nov 10 17:50:06 2008
@@ -1,18 +1,18 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM (
   FROM src_thrift
-  SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring) AS (tkey, tvalue) 
-         USING '/bin/cat'
+  SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
+         USING '/bin/cat' AS (tkey, tvalue) 
   CLUSTER BY tkey 
 ) tmap
 INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue;
 
 FROM (
   FROM src_thrift
-  SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring) AS (tkey, tvalue) 
-         USING '/bin/cat'
+  SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
+         USING '/bin/cat' AS (tkey, tvalue) 
   CLUSTER BY tkey 
 ) tmap
 INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input6.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input6.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input6.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input6.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key STRING, value STRING);
+CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src1

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input7.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input7.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input7.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input7.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 DOUBLE, c2 INT);
+CREATE TABLE dest1(c1 DOUBLE, c2 INT) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src1

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input8.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input8.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input8.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input8.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 STRING, c2 INT, c3 DOUBLE);
+CREATE TABLE dest1(c1 STRING, c2 INT, c3 DOUBLE) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src1 

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input9.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input9.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input9.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input9.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(value STRING, key INT);
+CREATE TABLE dest1(value STRING, key INT) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src1

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_dfs.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_dfs.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_dfs.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_dfs.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,2 @@
 dfs -cat ../../../../build/contrib/hive/ql/test/data/files/kv1.txt;
-set fs.default.name=file://src
-dfs -ls
 

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_dynamicserde.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_dynamicserde.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_dynamicserde.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_dynamicserde.q Mon Nov 10 17:50:06 2008
@@ -3,7 +3,8 @@
 FIELDS TERMINATED BY '1'
 COLLECTION ITEMS TERMINATED BY '2'
 MAP KEYS TERMINATED BY '3'
-LINES TERMINATED BY '10';
+LINES TERMINATED BY '10'
+STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src_thrift
@@ -13,3 +14,5 @@
 INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring;
 
 SELECT dest1.* FROM dest1;
+
+SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part0.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part0.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part0.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part0.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,4 @@
+EXPLAIN
+SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08';
+
+SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08';

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part1.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part1.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING, hr STRING, ds STRING);
+CREATE TABLE dest1(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE;
 
 EXPLAIN EXTENDED
 FROM srcpart

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part2.q Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
-CREATE TABLE dest1(key INT, value STRING, hr STRING, ds STRING);
-CREATE TABLE dest2(key INT, value STRING, hr STRING, ds STRING);
+CREATE TABLE dest1(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE;
+CREATE TABLE dest2(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE;
 
 EXPLAIN EXTENDED
 FROM srcpart

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part3.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part3.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part3.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part3.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,4 @@
+EXPLAIN
+SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.hr = 11;
+
+SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.hr = 11;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part4.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part4.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part4.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part4.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,4 @@
+EXPLAIN
+SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.hr = 15;
+
+SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.hr = 15;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part5.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part5.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part5.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_part5.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,4 @@
+EXPLAIN
+SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.key < 100;
+
+SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.key < 100;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_testxpath.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_testxpath.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_testxpath.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_testxpath.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING, mapvalue STRING);
+CREATE TABLE dest1(key INT, value STRING, mapvalue STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src_thrift

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_testxpath2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_testxpath2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_testxpath2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/input_testxpath2.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(lint_size INT, lintstring_size INT, mstringstring_size INT);
+CREATE TABLE dest1(lint_size INT, lintstring_size INT, mstringstring_size INT) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src_thrift

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl1.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl1.q Mon Nov 10 17:50:06 2008
@@ -1,7 +1,7 @@
 EXPLAIN
-CREATE TABLE INPUTDDL1(key INT, value STRING); 
+CREATE TABLE INPUTDDL1(key INT, value STRING) STORED AS TEXTFILE; 
 
-CREATE TABLE INPUTDDL1(key INT, value STRING); 
+CREATE TABLE INPUTDDL1(key INT, value STRING) STORED AS TEXTFILE; 
 
 SELECT INPUTDDL1.* from INPUTDDL1;
 

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl2.q Mon Nov 10 17:50:06 2008
@@ -1,6 +1,6 @@
 EXPLAIN
-CREATE TABLE INPUTDDL2(key INT, value STRING) PARTITIONED BY(ds DATETIME, country STRING);
-CREATE TABLE INPUTDDL2(key INT, value STRING) PARTITIONED BY(ds DATETIME, country STRING);
+CREATE TABLE INPUTDDL2(key INT, value STRING) PARTITIONED BY(ds DATETIME, country STRING) STORED AS TEXTFILE;
+CREATE TABLE INPUTDDL2(key INT, value STRING) PARTITIONED BY(ds DATETIME, country STRING) STORED AS TEXTFILE;
 DESCRIBE INPUTDDL2;
 DROP TABLE INPUTDDL2;
 

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl3.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl3.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl3.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl3.q Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 EXPLAIN
-CREATE TABLE INPUTDDL3(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
-CREATE TABLE INPUTDDL3(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
+CREATE TABLE INPUTDDL3(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
+CREATE TABLE INPUTDDL3(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
 DESCRIBE INPUTDDL3;
 DROP TABLE INPUTDDL3;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl5.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl5.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl5.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl5.q Mon Nov 10 17:50:06 2008
@@ -1,6 +1,6 @@
 -- test for internationalization
 -- kv4.txt contains the utf-8 character 0xE982B5E993AE which we are verifying later on
-CREATE TABLE INPUTDDL5(name STRING);
+CREATE TABLE INPUTDDL5(name STRING) STORED AS TEXTFILE;
 LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE INPUTDDL5;
 DESCRIBE INPUTDDL5;
 SELECT INPUTDDL5.name from INPUTDDL5;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl6.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl6.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl6.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl6.q Mon Nov 10 17:50:06 2008
@@ -2,7 +2,7 @@
 -- test for describe extended table partition
 -- test for alter table drop partition
 DROP TABLE INPUTDDL6;
-CREATE TABLE INPUTDDL6(KEY STRING, VALUE STRING) PARTITIONED BY(ds DATETIME);
+CREATE TABLE INPUTDDL6(KEY STRING, VALUE STRING) PARTITIONED BY(ds DATETIME) STORED AS TEXTFILE;
 LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUTDDL6 PARTITION (ds='2008-04-09');
 LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUTDDL6 PARTITION (ds='2008-04-08');
 DESCRIBE EXTENDED INPUTDDL6;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl7.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl7.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl7.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl7.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,33 @@
+-- test for loading into tables with the correct file format
+-- test for loading into partitions with the correct file format
+
+DROP TABLE T1;
+CREATE TABLE T1(name STRING) STORED AS TEXTFILE;
+LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE T1;
+SELECT COUNT(1) FROM T1;
+
+DROP TABLE T2;
+CREATE TABLE T2(name STRING) STORED AS SEQUENCEFILE;
+LOAD DATA LOCAL INPATH '../data/files/kv1.seq' INTO TABLE T2;
+SELECT COUNT(1) FROM T2;
+
+DROP TABLE T3;
+CREATE TABLE T3(name STRING) PARTITIONED BY(ds STRING) STORED AS TEXTFILE;
+LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE T3 PARTITION (ds='2008-04-09');
+SELECT COUNT(1) FROM T3 where T3.ds='2008-04-09';
+
+DROP TABLE T4;
+CREATE TABLE T4(name STRING) PARTITIONED BY(ds STRING) STORED AS SEQUENCEFILE;
+LOAD DATA LOCAL INPATH '../data/files/kv1.seq' INTO TABLE T4 PARTITION (ds='2008-04-09');
+SELECT COUNT(1) FROM T4 where T4.ds='2008-04-09';
+
+DESCRIBE EXTENDED T1;
+DESCRIBE EXTENDED T2;
+DESCRIBE EXTENDED T3 PARTITION (ds='2008-04-09');
+DESCRIBE EXTENDED T4 PARTITION (ds='2008-04-09');
+
+
+DROP TABLE T1;
+DROP TABLE T2;
+DROP TABLE T3;
+DROP TABLE T4;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl8.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl8.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl8.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/inputddl8.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,8 @@
+DROP TABLE INPUTDDL8;
+CREATE TABLE INPUTDDL8 COMMENT 'This is a thrift based table' 
+    PARTITIONED BY(ds DATETIME, country STRING) 
+    CLUSTERED BY(aint) SORTED BY(lint) INTO 32 BUCKETS
+    ROW FORMAT SERDE'org.apache.hadoop.hive.serde2.ThriftDeserializer' WITH SERDEPROPERTIES ('serialization.class' = 'org.apache.hadoop.hive.serde2.thrift.test.Complex', 'serialization.format' = 'com.facebook.thrift.protocol.TBinaryProtocol')
+    STORED AS SEQUENCEFILE;
+DESCRIBE EXTENDED INPUTDDL8;
+DROP TABLE INPUTDDL8;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join1.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join1.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src src1 JOIN src src2 ON (src1.key = src2.key)

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join10.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join10.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join10.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join10.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,6 @@
+EXPLAIN FROM 
+(SELECT src.* FROM src) x
+JOIN 
+(SELECT src.* FROM src) Y
+ON (x.key = Y.key)
+SELECT Y.*;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join11.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join11.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join11.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join11.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,14 @@
+EXPLAIN
+SELECT src1.c1, src2.c4 
+FROM
+(SELECT src.key as c1, src.value as c2 from src) src1
+JOIN
+(SELECT src.key as c3, src.value as c4 from src) src2
+ON src1.c1 = src2.c3 AND src1.c1 < 100;
+
+SELECT src1.c1, src2.c4 
+FROM
+(SELECT src.key as c1, src.value as c2 from src) src1
+JOIN
+(SELECT src.key as c3, src.value as c4 from src) src2
+ON src1.c1 = src2.c3 AND src1.c1 < 100;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join12.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join12.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join12.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join12.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,20 @@
+EXPLAIN
+SELECT src1.c1, src2.c4 
+FROM
+(SELECT src.key as c1, src.value as c2 from src) src1
+JOIN
+(SELECT src.key as c3, src.value as c4 from src) src2
+ON src1.c1 = src2.c3 AND src1.c1 < 100
+JOIN
+(SELECT src.key as c5, src.value as c6 from src) src3
+ON src1.c1 = src3.c5 AND src3.c5 < 80;
+
+SELECT src1.c1, src2.c4 
+FROM
+(SELECT src.key as c1, src.value as c2 from src) src1
+JOIN
+(SELECT src.key as c3, src.value as c4 from src) src2
+ON src1.c1 = src2.c3 AND src1.c1 < 100
+JOIN
+(SELECT src.key as c5, src.value as c6 from src) src3
+ON src1.c1 = src3.c5 AND src3.c5 < 80;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join13.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join13.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join13.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join13.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,20 @@
+EXPLAIN
+SELECT src1.c1, src2.c4 
+FROM
+(SELECT src.key as c1, src.value as c2 from src) src1
+JOIN
+(SELECT src.key as c3, src.value as c4 from src) src2
+ON src1.c1 = src2.c3 AND src1.c1 < 100
+JOIN
+(SELECT src.key as c5, src.value as c6 from src) src3
+ON src1.c1 + src2.c3 = src3.c5 AND src3.c5 < 200;
+
+SELECT src1.c1, src2.c4 
+FROM
+(SELECT src.key as c1, src.value as c2 from src) src1
+JOIN
+(SELECT src.key as c3, src.value as c4 from src) src2
+ON src1.c1 = src2.c3 AND src1.c1 < 100
+JOIN
+(SELECT src.key as c5, src.value as c6 from src) src3
+ON src1.c1 + src2.c3 = src3.c5 AND src3.c5 < 200;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join14.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join14.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join14.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join14.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,10 @@
+CREATE TABLE dest1(c1 INT, c2 STRING) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM src JOIN srcpart ON src.key = srcpart.key AND srcpart.ds = '2008-04-08' and src.key > 100
+INSERT OVERWRITE TABLE dest1 SELECT src.key, srcpart.value;
+
+FROM src JOIN srcpart ON src.key = srcpart.key AND srcpart.ds = '2008-04-08' and src.key > 100
+INSERT OVERWRITE TABLE dest1 SELECT src.key, srcpart.value;
+
+select dest1.* from dest1;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join15.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join15.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join15.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join15.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,4 @@
+EXPLAIN
+SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key);
+
+SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key);

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join16.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join16.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join16.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join16.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1 @@
+EXPLAIN SELECT subq.key, tab.value FROM (select a.key, a.value from src a where a.key > 10 ) subq JOIN src tab ON (subq.key = tab.key and subq.key > 20 and subq.value = tab.value) where tab.value < 200;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join2.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key + src2.key = src3.key)

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join3.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join3.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join3.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join3.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key = src3.key)

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join4.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join4.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join4.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join4.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING);
+CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM (

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join5.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join5.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join5.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join5.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING);
+CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM (

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join6.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join6.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join6.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join6.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING);
+CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM (

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join7.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join7.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join7.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join7.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING, c5 INT, c6 STRING);
+CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING, c5 INT, c6 STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM (

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join8.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join8.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join8.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join8.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING);
+CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM (

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join9.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join9.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join9.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/join9.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 EXPLAIN EXTENDED
 FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/noalias_subq1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/noalias_subq1.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/noalias_subq1.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/noalias_subq1.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,5 @@
+EXPLAIN
+SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100;
+
+SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100;
+

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/notable_alias1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/notable_alias1.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/notable_alias1.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/notable_alias1.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,10 @@
+CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT '1234', key, count(1) WHERE src.key < 100 group by key;
+
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT '1234', key, count(1) WHERE src.key < 100 group by key;
+
+SELECT dest1.* FROM dest1;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/notable_alias2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/notable_alias2.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/notable_alias2.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/notable_alias2.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,10 @@
+CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT '1234', src.key, count(1) WHERE key < 100 group by src.key;
+
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT '1234', src.key, count(1) WHERE key < 100 group by src.key;
+
+SELECT dest1.* FROM dest1;

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/quote1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/quote1.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/quote1.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/quote1.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,13 @@
+CREATE TABLE dest1(`location` INT, `type` STRING) PARTITIONED BY(`table` STRING) STORED AS TEXTFILE;
+
+EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 PARTITION(`table`='2008-04-08') SELECT src.key as `partition`, src.value as `from` WHERE src.key >= 200 and src.key < 300;
+
+EXPLAIN
+SELECT `table`.`location`, `table`.`type`, `table`.`table` FROM dest1 `table` WHERE `table`.`table` = '2008-04-08';
+
+FROM src
+INSERT OVERWRITE TABLE dest1 PARTITION(`table`='2008-04-08') SELECT src.key as `partition`, src.value as `from` WHERE src.key >= 200 and src.key < 300;
+
+SELECT `table`.`location`, `table`.`type`, `table`.`table` FROM dest1 `table` WHERE `table`.`table` = '2008-04-08';

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample1.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample1.q Mon Nov 10 17:50:06 2008
@@ -1,13 +1,13 @@
-CREATE TABLE dest1(key INT, value STRING, dt STRING, hr STRING);
+CREATE TABLE dest1(key INT, value STRING, dt STRING, hr STRING) STORED AS TEXTFILE;
 
 -- no input pruning, no sample filter
 EXPLAIN EXTENDED
 INSERT OVERWRITE TABLE dest1 SELECT s.*
-FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1) s
+FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON rand()) s
 WHERE s.ds='2008-04-08' and s.hr='11';
 
 INSERT OVERWRITE TABLE dest1 SELECT s.*
-FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1) s
+FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON rand()) s
 WHERE s.ds='2008-04-08' and s.hr='11';
 
 SELECT dest1.* FROM dest1;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample2.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 -- input pruning, no sample filter
 -- default table sample columns

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample4.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample4.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample4.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample4.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 -- bucket column is the same as table sample
 -- No need for sample filter

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample5.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample5.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample5.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample5.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 -- no input pruning, sample filter
 EXPLAIN EXTENDED

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample6.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample6.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample6.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample6.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 -- both input pruning and sample filter
 EXPLAIN EXTENDED

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample7.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample7.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample7.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/sample7.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(key INT, value STRING);
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 
 -- both input pruning and sample filter
 EXPLAIN EXTENDED

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/scriptfile1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/scriptfile1.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/scriptfile1.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/scriptfile1.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,13 @@
+CREATE TABLE dest1(key INT, value STRING);
+
+ADD FILE src/test/scripts/testgrep;
+
+FROM (
+  FROM src
+  SELECT TRANSFORM(src.key, src.value)
+         USING 'testgrep' AS (tkey, tvalue) 
+  CLUSTER BY tkey 
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue;
+
+SELECT dest1.* FROM dest1;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/show_tables.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/show_tables.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/show_tables.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/show_tables.q Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
-CREATE TABLE shtb_test1(KEY STRING, VALUE STRING) PARTITIONED BY(ds DATETIME);
-CREATE TABLE shtb_test2(KEY STRING, VALUE STRING) PARTITIONED BY(ds DATETIME);
+CREATE TABLE shtb_test1(KEY STRING, VALUE STRING) PARTITIONED BY(ds DATETIME) STORED AS TEXTFILE;
+CREATE TABLE shtb_test2(KEY STRING, VALUE STRING) PARTITIONED BY(ds DATETIME) STORED AS TEXTFILE;
 
 EXPLAIN
 SHOW TABLES 'shtb_*';

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf1.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf1.q Mon Nov 10 17:50:06 2008
@@ -1,7 +1,7 @@
 CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING,
   c5 STRING, c6 STRING, c7 STRING, c8 STRING,
   c9 STRING, c10 STRING, c11 STRING, c12 STRING, c13 STRING,
-  c14 STRING, c15 STRING, c16 STRING, c17 STRING);
+  c14 STRING, c15 STRING, c16 STRING, c17 STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src INSERT OVERWRITE TABLE dest1 SELECT 'a' LIKE '%a%', 'b' LIKE '%a%', 'ab' LIKE '%a%', 'ab' LIKE '%a_',

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf2.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 STRING);
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE;
 
 FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86;
 

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf3.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf3.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf3.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf3.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING);
+CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING) STORED AS TEXTFILE;
 
 EXPLAIN
 FROM src INSERT OVERWRITE TABLE dest1 SELECT count(CAST('' AS INT)), sum(CAST('' AS INT)), avg(CAST('' AS INT)), 

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf4.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf4.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf4.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf4.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-CREATE TABLE dest1(c1 STRING);
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE;
 
 FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86;
 

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/negative/insert_wrong_number_columns.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/negative/insert_wrong_number_columns.q?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/negative/insert_wrong_number_columns.q (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/negative/insert_wrong_number_columns.q Mon Nov 10 17:50:06 2008
@@ -0,0 +1,2 @@
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value, 1 WHERE src.key < 100

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/negative/quoted_string.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/negative/quoted_string.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/negative/quoted_string.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/negative/quoted_string.q Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
 FROM src
-INSERT OVERWRITE TABLE dest1 SELECT "1234", src.value WHERE src.key < 100
+INSERT OVERWRITE TABLE dest1 SELECT '1234", src.value WHERE src.key < 100

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/cast1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/cast1.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/cast1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/cast1.q Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
 FROM src
-INSERT OVERWRITE TABLE dest1 SELECT 3 + 2, 3.0 + 2, 3 + 2.0, 3.0 + 2.0, 3 + CAST(2.0 AS INT), CAST(1 AS BOOLEAN), CAST(TRUE AS INT) WHERE src.key = 86
+SELECT 3 + 2, 3.0 + 2, 3 + 2.0, 3.0 + 2.0, 3 + CAST(2.0 AS INT), CAST(1 AS BOOLEAN), CAST(TRUE AS INT) WHERE src.key = 86

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby2.q Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
 FROM src
-INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,0,1), count(DISTINCT substr(src.value,4)), concat(substr(src.key,0,1),sum(substr(src.value,4))) GROUP BY substr(src.key,0,1)
+SELECT substr(src.key,0,1), count(DISTINCT substr(src.value,4)), concat(substr(src.key,0,1),sum(substr(src.value,4))) GROUP BY substr(src.key,0,1)

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby3.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby3.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby3.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby3.q Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
 FROM src
-INSERT OVERWRITE TABLE dest1 SELECT sum(substr(src.value,4)), avg(substr(src.value,4)), avg(DISTINCT substr(src.value,4)), max(substr(src.value,4)), min(substr(src.value,4))
+SELECT sum(substr(src.value,4)), avg(substr(src.value,4)), avg(DISTINCT substr(src.value,4)), max(substr(src.value,4)), min(substr(src.value,4))

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby4.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby4.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby4.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby4.q Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
 FROM src
-INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,0,1) GROUP BY substr(src.key,0,1)
+SELECT substr(src.key,0,1) GROUP BY substr(src.key,0,1)

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby5.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby5.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby5.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby5.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
-INSERT OVERWRITE TABLE dest1 
+
 SELECT src.key, sum(substr(src.value,4)) 
 FROM src
 GROUP BY src.key

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby6.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby6.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby6.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/groupby6.q Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
 FROM src
-INSERT OVERWRITE TABLE dest1 SELECT DISTINCT substr(src.value,4,1)
+SELECT DISTINCT substr(src.value,4,1)

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input2.q Mon Nov 10 17:50:06 2008
@@ -1,4 +1,4 @@
 FROM src
 INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
 INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
-INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 200
+INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key, 2 WHERE src.key >= 200

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input3.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input3.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input3.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input3.q Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 FROM src
 INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
 INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
-INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 200 and src.key < 300
+INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key, 2 WHERE src.key >= 200 and src.key < 300
 INSERT OVERWRITE DIRECTORY '../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out' SELECT src.value WHERE src.key >= 300

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input4.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input4.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input4.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input4.q Mon Nov 10 17:50:06 2008
@@ -1,7 +1,7 @@
 FROM (
   FROM src
-  SELECT TRANSFORM(src.key, src.value) AS (tkey, tvalue) 
-         USING '/bin/cat'
+  SELECT TRANSFORM(src.key, src.value)
+         USING '/bin/cat' AS (tkey, tvalue) 
   CLUSTER BY tkey 
 ) tmap
 INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input5.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input5.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input5.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input5.q Mon Nov 10 17:50:06 2008
@@ -1,7 +1,7 @@
 FROM (
   FROM src_thrift
-  SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring) AS (tkey, tvalue) 
-         USING '/bin/cat'
+  SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
+         USING '/bin/cat' AS (tkey, tvalue) 
   CLUSTER BY tkey 
 ) tmap
 INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input8.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input8.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input8.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input8.q Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
 FROM src1 
-INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
+SELECT 4 + NULL, src1.key - NULL, NULL + NULL

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_part1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_part1.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_part1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_part1.q Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
 FROM srcpart
-INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
+SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_testxpath.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_testxpath.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_testxpath.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_testxpath.q Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
 FROM src_thrift
-INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[1], src_thrift.lintstring[0].mystring, src_thrift.mstringstring['key_2']
+SELECT src_thrift.lint[1], src_thrift.lintstring[0].mystring, src_thrift.mstringstring['key_2']

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_testxpath2.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_testxpath2.q?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_testxpath2.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/positive/input_testxpath2.q Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
 FROM src_thrift
-INSERT OVERWRITE TABLE dest1 SELECT size(src_thrift.lint), size(src_thrift.lintstring), size(src_thrift.mstringstring) where src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL)
+SELECT size(src_thrift.lint), size(src_thrift.lintstring), size(src_thrift.mstringstring) where src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL)



Mime
View raw message