You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by dh...@apache.org on 2008/11/11 02:50:18 UTC
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...
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)