You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2013/10/12 18:38:13 UTC
svn commit: r1531557 [10/20] - in /hive/branches/maven: ./ ant/
ant/src/org/apache/hadoop/hive/ant/ beeline/
beeline/src/java/org/apache/hive/beeline/
beeline/src/test/org/apache/hive/beeline/src/test/ cli/
cli/src/test/org/apache/hadoop/hive/cli/ comm...
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/skewjoinopt8.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/skewjoinopt8.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/skewjoinopt8.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/skewjoinopt8.q Sat Oct 12 16:37:47 2013
@@ -4,16 +4,16 @@ set hive.optimize.skewjoin.compiletime =
CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1;
+LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1;
CREATE TABLE T2(key STRING, val STRING)
SKEWED BY (key) ON ((3), (8)) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2;
+LOAD DATA LOCAL INPATH '../../data/files/T2.txt' INTO TABLE T2;
CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3;
+LOAD DATA LOCAL INPATH '../../data/files/T3.txt' INTO TABLE T3;
-- This test is for validating skewed join compile time optimization for more than
-- 2 tables. The join key is the same, and so a 3-way join would be performed.
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/skewjoinopt9.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/skewjoinopt9.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/skewjoinopt9.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/skewjoinopt9.q Sat Oct 12 16:37:47 2013
@@ -5,11 +5,11 @@ set hive.optimize.skewjoin.compiletime =
CREATE TABLE T1(key STRING, val STRING)
SKEWED BY (key) ON ((2)) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1;
+LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1;
CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2;
+LOAD DATA LOCAL INPATH '../../data/files/T2.txt' INTO TABLE T2;
-- no skew join compile time optimization would be performed if one of the
-- join sources is a sub-query consisting of a union all
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_1.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_1.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_1.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_1.q Sat Oct 12 16:37:47 2013
@@ -6,9 +6,9 @@ create table smb_bucket_1(key int, value
create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
-load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
-load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
-load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
+load data local inpath '../../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
+load data local inpath '../../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
+load data local inpath '../../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
set hive.optimize.bucketmapjoin = true;
set hive.optimize.bucketmapjoin.sortedmerge = true;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_10.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_10.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_10.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_10.q Sat Oct 12 16:37:47 2013
@@ -6,11 +6,11 @@ alter table tmp_smb_bucket_10 add partit
-- add dummy files to make sure that the number of files in each partition is same as number of buckets
-load data local inpath '../data/files/smbbucket_1.rc' INTO TABLE tmp_smb_bucket_10 partition(ds='1');
-load data local inpath '../data/files/smbbucket_2.rc' INTO TABLE tmp_smb_bucket_10 partition(ds='1');
+load data local inpath '../../data/files/smbbucket_1.rc' INTO TABLE tmp_smb_bucket_10 partition(ds='1');
+load data local inpath '../../data/files/smbbucket_2.rc' INTO TABLE tmp_smb_bucket_10 partition(ds='1');
-load data local inpath '../data/files/smbbucket_1.rc' INTO TABLE tmp_smb_bucket_10 partition(ds='2');
-load data local inpath '../data/files/smbbucket_2.rc' INTO TABLE tmp_smb_bucket_10 partition(ds='2');
+load data local inpath '../../data/files/smbbucket_1.rc' INTO TABLE tmp_smb_bucket_10 partition(ds='2');
+load data local inpath '../../data/files/smbbucket_2.rc' INTO TABLE tmp_smb_bucket_10 partition(ds='2');
set hive.optimize.bucketmapjoin = true;
set hive.optimize.bucketmapjoin.sortedmerge = true;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_2.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_2.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_2.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_2.q Sat Oct 12 16:37:47 2013
@@ -6,9 +6,9 @@ create table smb_bucket_1(key int, value
create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
-load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
-load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
-load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
+load data local inpath '../../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
+load data local inpath '../../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
+load data local inpath '../../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
set hive.optimize.bucketmapjoin = true;
set hive.optimize.bucketmapjoin.sortedmerge = true;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_25.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_25.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_25.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_25.q Sat Oct 12 16:37:47 2013
@@ -10,9 +10,9 @@ create table smb_bucket_1(key int, value
create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
-load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
-load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
-load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
+load data local inpath '../../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
+load data local inpath '../../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
+load data local inpath '../../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
explain
select * from (select a.key from smb_bucket_1 a join smb_bucket_2 b on (a.key = b.key) where a.key = 5) t1 left outer join (select c.key from smb_bucket_2 c join smb_bucket_3 d on (c.key = d.key) where c.key=5) t2 on (t1.key=t2.key) where t2.key=5;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_3.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_3.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_3.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_3.q Sat Oct 12 16:37:47 2013
@@ -6,9 +6,9 @@ create table smb_bucket_1(key int, value
create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
-load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
-load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
-load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
+load data local inpath '../../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
+load data local inpath '../../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
+load data local inpath '../../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
set hive.optimize.bucketmapjoin = true;
set hive.optimize.bucketmapjoin.sortedmerge = true;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_4.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_4.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_4.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_4.q Sat Oct 12 16:37:47 2013
@@ -6,9 +6,9 @@ create table smb_bucket_1(key int, value
create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
-load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
-load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
-load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
+load data local inpath '../../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
+load data local inpath '../../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
+load data local inpath '../../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
set hive.optimize.bucketmapjoin = true;
set hive.optimize.bucketmapjoin.sortedmerge = true;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_5.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_5.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_5.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_5.q Sat Oct 12 16:37:47 2013
@@ -6,9 +6,9 @@ create table smb_bucket_1(key int, value
create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE;
-load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
-load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
-load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
+load data local inpath '../../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
+load data local inpath '../../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
+load data local inpath '../../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3;
set hive.optimize.bucketmapjoin = true;
set hive.optimize.bucketmapjoin.sortedmerge = true;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_7.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_7.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_7.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_7.q Sat Oct 12 16:37:47 2013
@@ -15,8 +15,8 @@ create table smb_join_results(k1 int, v1
create table smb_join_results_empty_bigtable(k1 int, v1 string, k2 int, v2 string);
create table normal_join_results(k1 int, v1 string, k2 int, v2 string);
-load data local inpath '../data/files/empty1.txt' into table smb_bucket4_1;
-load data local inpath '../data/files/empty2.txt' into table smb_bucket4_1;
+load data local inpath '../../data/files/empty1.txt' into table smb_bucket4_1;
+load data local inpath '../../data/files/empty2.txt' into table smb_bucket4_1;
insert overwrite table smb_bucket4_2
select * from src;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_8.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_8.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_8.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/smb_mapjoin_8.q Sat Oct 12 16:37:47 2013
@@ -5,7 +5,7 @@ set hive.exec.reducers.max = 1;
create table smb_bucket_input (key int, value string) stored as rcfile;
-load data local inpath '../data/files/smb_bucket_input.rc' into table smb_bucket_input;
+load data local inpath '../../data/files/smb_bucket_input.rc' into table smb_bucket_input;
CREATE TABLE smb_bucket4_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/source.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/source.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/source.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/source.q Sat Oct 12 16:37:47 2013
@@ -1 +1 @@
-source ../data/files/source.txt;
+source ../../data/files/source.txt;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/stats1.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/stats1.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/stats1.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/stats1.q Sat Oct 12 16:37:47 2013
@@ -26,5 +26,5 @@ DESCRIBE FORMATTED tmptable;
-- Load a file into a existing table
-- Some stats (numFiles, totalSize) should be updated correctly
-- Some other stats (numRows, rawDataSize) should be cleared
-load data local inpath '../data/files/srcbucket20.txt' INTO TABLE tmptable;
+load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE tmptable;
DESCRIBE FORMATTED tmptable;
\ No newline at end of file
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/stats11.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/stats11.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/stats11.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/stats11.q Sat Oct 12 16:37:47 2013
@@ -2,25 +2,25 @@ set datanucleus.cache.collections=false;
set hive.stats.autogather=true;
CREATE TABLE srcbucket_mapjoin(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE;
-load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin;
-load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin;
+load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin;
+load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin;
CREATE TABLE srcbucket_mapjoin_part (key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE;
explain
-load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
-load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
+load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
+load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
desc formatted srcbucket_mapjoin_part partition(ds='2008-04-08');
-load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
+load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
desc formatted srcbucket_mapjoin_part partition(ds='2008-04-08');
-load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
+load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
desc formatted srcbucket_mapjoin_part partition(ds='2008-04-08');
-load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
+load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
desc formatted srcbucket_mapjoin_part partition(ds='2008-04-08');
CREATE TABLE srcbucket_mapjoin_part_2 (key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE;
-load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part_2 partition(ds='2008-04-08');
-load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part_2 partition(ds='2008-04-08');
+load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part_2 partition(ds='2008-04-08');
+load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part_2 partition(ds='2008-04-08');
create table bucketmapjoin_hash_result_1 (key bigint , value1 bigint, value2 bigint);
create table bucketmapjoin_hash_result_2 (key bigint , value1 bigint, value2 bigint);
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/stats18.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/stats18.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/stats18.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/stats18.q Sat Oct 12 16:37:47 2013
@@ -13,7 +13,7 @@ insert overwrite table stats_part partit
-- Some other stats (numRows, rawDataSize) should be cleared
desc formatted stats_part partition (ds='2010-04-08', hr='13');
-load data local inpath '../data/files/srcbucket20.txt' INTO TABLE stats_part partition (ds='2010-04-08', hr='13');
+load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE stats_part partition (ds='2010-04-08', hr='13');
desc formatted stats_part partition (ds='2010-04-08', hr='13');
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/stats3.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/stats3.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/stats3.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/stats3.q Sat Oct 12 16:37:47 2013
@@ -5,9 +5,9 @@ drop table hive_test_dst;
create table hive_test_src ( col1 string ) stored as textfile ;
explain extended
-load data local inpath '../data/files/test.dat' overwrite into table hive_test_src ;
+load data local inpath '../../data/files/test.dat' overwrite into table hive_test_src ;
-load data local inpath '../data/files/test.dat' overwrite into table hive_test_src ;
+load data local inpath '../../data/files/test.dat' overwrite into table hive_test_src ;
desc formatted hive_test_src;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/subq.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/subq.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/subq.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/subq.q Sat Oct 12 16:37:47 2013
@@ -2,12 +2,12 @@ EXPLAIN
FROM (
FROM src select src.* WHERE src.key < 100
) unioninput
-INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*;
+INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*;
FROM (
FROM src select src.* WHERE src.key < 100
) unioninput
-INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*;
+INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*;
-dfs -cat ../build/ql/test/data/warehouse/union.out/*;
+dfs -cat ${system:test.warehouse.dir}/union.out/*;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/symlink_text_input_format.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/symlink_text_input_format.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/symlink_text_input_format.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/symlink_text_input_format.q Sat Oct 12 16:37:47 2013
@@ -5,8 +5,8 @@ CREATE TABLE symlink_text_input_format (
CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat';
-dfs -cp ../data/files/symlink1.txt ../build/ql/test/data/warehouse/symlink_text_input_format/symlink1.txt;
-dfs -cp ../data/files/symlink2.txt ../build/ql/test/data/warehouse/symlink_text_input_format/symlink2.txt;
+dfs -cp ../../data/files/symlink1.txt ${system:test.tmp.dir}/warehouse/symlink_text_input_format/symlink1.txt;
+dfs -cp ../../data/files/symlink2.txt ${system:test.tmp.dir}/warehouse/symlink_text_input_format/symlink2.txt;
EXPLAIN SELECT * FROM symlink_text_input_format order by key, value;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/table_access_keys_stats.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/table_access_keys_stats.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/table_access_keys_stats.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/table_access_keys_stats.q Sat Oct 12 16:37:47 2013
@@ -4,7 +4,7 @@ SET hive.stats.collect.tablekeys=true;
-- This test is used for testing the TableAccessAnalyzer
CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1;
+LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1;
CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE;
CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/timestamp_null.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/timestamp_null.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/timestamp_null.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/timestamp_null.q Sat Oct 12 16:37:47 2013
@@ -1,6 +1,6 @@
DROP TABLE IF EXISTS timestamp_null;
CREATE TABLE timestamp_null (t1 TIMESTAMP);
-LOAD DATA LOCAL INPATH '../data/files/test.dat' OVERWRITE INTO TABLE timestamp_null;
+LOAD DATA LOCAL INPATH '../../data/files/test.dat' OVERWRITE INTO TABLE timestamp_null;
SELECT * FROM timestamp_null LIMIT 1;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/truncate_table.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/truncate_table.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/truncate_table.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/truncate_table.q Sat Oct 12 16:37:47 2013
@@ -1,5 +1,5 @@
create table src_truncate (key string, value string);
-load data local inpath '../data/files/kv1.txt' into table src_truncate;;
+load data local inpath '../../data/files/kv1.txt' into table src_truncate;;
create table srcpart_truncate (key string, value string) partitioned by (ds string, hr string);
alter table srcpart_truncate add partition (ds='2008-04-08', hr='11');
@@ -7,10 +7,10 @@ alter table srcpart_truncate add partiti
alter table srcpart_truncate add partition (ds='2008-04-09', hr='11');
alter table srcpart_truncate add partition (ds='2008-04-09', hr='12');
-load data local inpath '../data/files/kv1.txt' into table srcpart_truncate partition (ds='2008-04-08', hr='11');
-load data local inpath '../data/files/kv1.txt' into table srcpart_truncate partition (ds='2008-04-08', hr='12');
-load data local inpath '../data/files/kv1.txt' into table srcpart_truncate partition (ds='2008-04-09', hr='11');
-load data local inpath '../data/files/kv1.txt' into table srcpart_truncate partition (ds='2008-04-09', hr='12');
+load data local inpath '../../data/files/kv1.txt' into table srcpart_truncate partition (ds='2008-04-08', hr='11');
+load data local inpath '../../data/files/kv1.txt' into table srcpart_truncate partition (ds='2008-04-08', hr='12');
+load data local inpath '../../data/files/kv1.txt' into table srcpart_truncate partition (ds='2008-04-09', hr='11');
+load data local inpath '../../data/files/kv1.txt' into table srcpart_truncate partition (ds='2008-04-09', hr='12');
set hive.fetch.task.convertion=more;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udaf_context_ngrams.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udaf_context_ngrams.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udaf_context_ngrams.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udaf_context_ngrams.q Sat Oct 12 16:37:47 2013
@@ -1,5 +1,5 @@
CREATE TABLE kafka (contents STRING);
-LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka;
+LOAD DATA LOCAL INPATH '../../data/files/text-en.txt' INTO TABLE kafka;
set mapred.reduce.tasks=1;
set hive.exec.reducers.max=1;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udaf_corr.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udaf_corr.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udaf_corr.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udaf_corr.q Sat Oct 12 16:37:47 2013
@@ -2,7 +2,7 @@ DROP TABLE covar_tab;
CREATE TABLE covar_tab (a INT, b INT, c INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
+LOAD DATA LOCAL INPATH '../../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab;
DESCRIBE FUNCTION corr;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udaf_covar_pop.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udaf_covar_pop.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udaf_covar_pop.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udaf_covar_pop.q Sat Oct 12 16:37:47 2013
@@ -2,7 +2,7 @@ DROP TABLE covar_tab;
CREATE TABLE covar_tab (a INT, b INT, c INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
+LOAD DATA LOCAL INPATH '../../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab;
DESCRIBE FUNCTION covar_pop;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udaf_covar_samp.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udaf_covar_samp.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udaf_covar_samp.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udaf_covar_samp.q Sat Oct 12 16:37:47 2013
@@ -2,7 +2,7 @@ DROP TABLE covar_tab;
CREATE TABLE covar_tab (a INT, b INT, c INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
+LOAD DATA LOCAL INPATH '../../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab;
DESCRIBE FUNCTION covar_samp;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udaf_ngrams.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udaf_ngrams.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udaf_ngrams.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udaf_ngrams.q Sat Oct 12 16:37:47 2013
@@ -1,5 +1,5 @@
CREATE TABLE kafka (contents STRING);
-LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka;
+LOAD DATA LOCAL INPATH '../../data/files/text-en.txt' INTO TABLE kafka;
set mapred.reduce.tasks=1;
set hive.exec.reducers.max=1;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udaf_percentile_approx_20.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udaf_percentile_approx_20.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udaf_percentile_approx_20.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udaf_percentile_approx_20.q Sat Oct 12 16:37:47 2013
@@ -1,10 +1,10 @@
-- INCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S)
CREATE TABLE bucket (key double, value string) CLUSTERED BY (key) SORTED BY (key DESC) INTO 4 BUCKETS STORED AS TEXTFILE;
-load data local inpath '../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket;
create table t1 (result double);
create table t2 (result double);
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q Sat Oct 12 16:37:47 2013
@@ -2,10 +2,10 @@
-- 0.23 changed input order of data in reducer task, which affects result of percentile_approx
CREATE TABLE bucket (key double, value string) CLUSTERED BY (key) SORTED BY (key DESC) INTO 4 BUCKETS STORED AS TEXTFILE;
-load data local inpath '../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket;
create table t1 (result double);
create table t2 (result double);
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udf_field.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udf_field.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udf_field.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udf_field.q Sat Oct 12 16:37:47 2013
@@ -25,7 +25,7 @@ FROM src LIMIT 1;
CREATE TABLE test_table(col1 STRING, col2 STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE test_table;
+LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE test_table;
select col1,col2,
field("66",col1),
@@ -42,7 +42,7 @@ from test_table where col1="86" or col1=
CREATE TABLE test_table1(col1 int, col2 string) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE test_table1;
+LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE test_table1;
select col1,col2,
field(66,col1),
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udf_in_file.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udf_in_file.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udf_in_file.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udf_in_file.q Sat Oct 12 16:37:47 2013
@@ -1,12 +1,12 @@
DESCRIBE FUNCTION in_file;
EXPLAIN
-SELECT in_file("303", "../data/files/test2.dat"),
- in_file("304", "../data/files/test2.dat"),
- in_file(CAST(NULL AS STRING), "../data/files/test2.dat")
+SELECT in_file("303", "../../data/files/test2.dat"),
+ in_file("304", "../../data/files/test2.dat"),
+ in_file(CAST(NULL AS STRING), "../../data/files/test2.dat")
FROM src LIMIT 1;
-SELECT in_file("303", "../data/files/test2.dat"),
- in_file("304", "../data/files/test2.dat"),
- in_file(CAST(NULL AS STRING), "../data/files/test2.dat")
+SELECT in_file("303", "../../data/files/test2.dat"),
+ in_file("304", "../../data/files/test2.dat"),
+ in_file(CAST(NULL AS STRING), "../../data/files/test2.dat")
FROM src LIMIT 1;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udf_length.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udf_length.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udf_length.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udf_length.q Sat Oct 12 16:37:47 2013
@@ -9,6 +9,6 @@ DROP TABLE dest1;
-- Test with non-ascii characters.
CREATE TABLE dest1(name STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1;
+LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1;
EXPLAIN SELECT length(dest1.name) FROM dest1;
SELECT length(dest1.name) FROM dest1;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udf_printf.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udf_printf.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udf_printf.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udf_printf.q Sat Oct 12 16:37:47 2013
@@ -27,7 +27,7 @@ CREATE TABLE binay_udf(key binary, value
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '9'
STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/string.txt' INTO TABLE binay_udf;
+LOAD DATA LOCAL INPATH '../../data/files/string.txt' INTO TABLE binay_udf;
create table dest1 (key binary, value int);
insert overwrite table dest1 select transform(*) using 'cat' as key binary, value int from binay_udf;
select value, printf("format key: %s", key) from dest1;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udf_reverse.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udf_reverse.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udf_reverse.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udf_reverse.q Sat Oct 12 16:37:47 2013
@@ -11,5 +11,5 @@ DROP TABLE dest1;
-- kv4.txt contains the text 0xE982B5E993AE, which should be reversed to
-- 0xE993AEE982B5
CREATE TABLE dest1(name STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1;
+LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1;
SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udf_sort_array.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udf_sort_array.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udf_sort_array.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udf_sort_array.q Sat Oct 12 16:37:47 2013
@@ -30,7 +30,7 @@ CREATE TABLE dest1 (
timestamps ARRAY<TIMESTAMP>
) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/primitive_type_arrays.txt' OVERWRITE INTO TABLE dest1;
+LOAD DATA LOCAL INPATH '../../data/files/primitive_type_arrays.txt' OVERWRITE INTO TABLE dest1;
SELECT sort_array(tinyints), sort_array(smallints), sort_array(ints),
sort_array(bigints), sort_array(booleans), sort_array(floats),
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udf_to_unix_timestamp.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udf_to_unix_timestamp.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udf_to_unix_timestamp.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udf_to_unix_timestamp.q Sat Oct 12 16:37:47 2013
@@ -2,7 +2,7 @@ DESCRIBE FUNCTION to_unix_timestamp;
DESCRIBE FUNCTION EXTENDED to_unix_timestamp;
create table oneline(key int, value string);
-load data local inpath '../data/files/things.txt' into table oneline;
+load data local inpath '../../data/files/things.txt' into table oneline;
SELECT
'2009-03-20 11:30:01',
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/udf_unix_timestamp.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/udf_unix_timestamp.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/udf_unix_timestamp.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/udf_unix_timestamp.q Sat Oct 12 16:37:47 2013
@@ -2,7 +2,7 @@ DESCRIBE FUNCTION unix_timestamp;
DESCRIBE FUNCTION EXTENDED unix_timestamp;
create table oneline(key int, value string);
-load data local inpath '../data/files/things.txt' into table oneline;
+load data local inpath '../../data/files/things.txt' into table oneline;
SELECT
'2009-03-20 11:30:01',
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union.q Sat Oct 12 16:37:47 2013
@@ -6,13 +6,13 @@ FROM (
UNION ALL
FROM src SELECT src.* WHERE src.key > 100
) unioninput
-INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*;
+INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*;
FROM (
FROM src select src.key, src.value WHERE src.key < 100
UNION ALL
FROM src SELECT src.* WHERE src.key > 100
) unioninput
-INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*;
+INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*;
-dfs -cat ../build/ql/test/data/warehouse/union.out/*;
+dfs -cat ${system:test.warehouse.dir}/union.out/*;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_date.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_date.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_date.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_date.q Sat Oct 12 16:37:47 2013
@@ -17,8 +17,8 @@ create table union_date_2 (
FL_NUM int
);
-LOAD DATA LOCAL INPATH '../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_1;
-LOAD DATA LOCAL INPATH '../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_2;
+LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_1;
+LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_2;
select * from (
select fl_num, fl_date from union_date_1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_1.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_1.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_1.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_1.q Sat Oct 12 16:37:47 2013
@@ -19,7 +19,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_10.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_10.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_10.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_10.q Sat Oct 12 16:37:47 2013
@@ -24,7 +24,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as rcfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_11.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_11.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_11.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_11.q Sat Oct 12 16:37:47 2013
@@ -24,7 +24,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as rcfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_12.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_12.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_12.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_12.q Sat Oct 12 16:37:47 2013
@@ -24,7 +24,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as rcfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_13.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_13.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_13.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_13.q Sat Oct 12 16:37:47 2013
@@ -24,7 +24,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as rcfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_14.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_14.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_14.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_14.q Sat Oct 12 16:37:47 2013
@@ -25,7 +25,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as rcfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_15.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_15.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_15.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_15.q Sat Oct 12 16:37:47 2013
@@ -25,7 +25,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1 partition (ds)
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_16.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_16.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_16.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_16.q Sat Oct 12 16:37:47 2013
@@ -25,7 +25,7 @@ set hive.exec.dynamic.partition=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile ;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1 partition (ds)
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_17.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_17.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_17.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_17.q Sat Oct 12 16:37:47 2013
@@ -22,7 +22,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1 partition (ds)
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_18.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_18.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_18.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_18.q Sat Oct 12 16:37:47 2013
@@ -24,7 +24,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, ds string) stored as textfile;
create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1 partition (ds)
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_19.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_19.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_19.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_19.q Sat Oct 12 16:37:47 2013
@@ -19,7 +19,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_2.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_2.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_2.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_2.q Sat Oct 12 16:37:47 2013
@@ -20,7 +20,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_20.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_20.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_20.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_20.q Sat Oct 12 16:37:47 2013
@@ -20,7 +20,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(values bigint, key string) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_21.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_21.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_21.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_21.q Sat Oct 12 16:37:47 2013
@@ -20,7 +20,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_22.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_22.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_22.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_22.q Sat Oct 12 16:37:47 2013
@@ -19,7 +19,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint, values2 bigint) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_23.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_23.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_23.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_23.q Sat Oct 12 16:37:47 2013
@@ -20,7 +20,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_24.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_24.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_24.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_24.q Sat Oct 12 16:37:47 2013
@@ -18,7 +18,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key double, values bigint) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
EXPLAIN
INSERT OVERWRITE TABLE outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_3.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_3.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_3.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_3.q Sat Oct 12 16:37:47 2013
@@ -20,7 +20,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_4.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_4.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_4.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_4.q Sat Oct 12 16:37:47 2013
@@ -20,7 +20,7 @@ set hive.merge.smallfiles.avgsize=1;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_5.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_5.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_5.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_5.q Sat Oct 12 16:37:47 2013
@@ -22,7 +22,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_6.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_6.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_6.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_6.q Sat Oct 12 16:37:47 2013
@@ -17,7 +17,7 @@ create table inputTbl1(key string, val s
create table outputTbl1(key string, values bigint) stored as textfile;
create table outputTbl2(key string, values bigint) stored as textfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
FROM (
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_7.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_7.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_7.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_7.q Sat Oct 12 16:37:47 2013
@@ -21,7 +21,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as rcfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_8.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_8.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_8.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_8.q Sat Oct 12 16:37:47 2013
@@ -22,7 +22,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as rcfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_9.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_9.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_9.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/union_remove_9.q Sat Oct 12 16:37:47 2013
@@ -22,7 +22,7 @@ set mapred.input.dir.recursive=true;
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as rcfile;
-load data local inpath '../data/files/T1.txt' into table inputTbl1;
+load data local inpath '../../data/files/T1.txt' into table inputTbl1;
explain
insert overwrite table outputTbl1
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/uniquejoin.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/uniquejoin.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/uniquejoin.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/uniquejoin.q Sat Oct 12 16:37:47 2013
@@ -2,9 +2,9 @@ CREATE TABLE T1(key STRING, val STRING)
CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE;
CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1;
-LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2;
-LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3;
+LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1;
+LOAD DATA LOCAL INPATH '../../data/files/T2.txt' INTO TABLE T2;
+LOAD DATA LOCAL INPATH '../../data/files/T3.txt' INTO TABLE T3;
FROM UNIQUEJOIN PRESERVE T1 a (a.key), PRESERVE T2 b (b.key), PRESERVE T3 c (c.key)
SELECT a.key, b.key, c.key;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/varchar_1.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/varchar_1.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/varchar_1.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/varchar_1.q Sat Oct 12 16:37:47 2013
@@ -5,7 +5,7 @@ create table varchar1 (key varchar(10),
create table varchar1_1 (key string, value string);
-- load from file
-load data local inpath '../data/files/srcbucket0.txt' overwrite into table varchar1;
+load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar1;
select * from varchar1 limit 2;
-- insert overwrite, from same/different length varchar
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/varchar_join1.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/varchar_join1.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/varchar_join1.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/varchar_join1.q Sat Oct 12 16:37:47 2013
@@ -17,9 +17,9 @@ create table varchar_join1_str (
c2 string
);
-load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc1;
-load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc2;
-load data local inpath '../data/files/vc1.txt' into table varchar_join1_str;
+load data local inpath '../../data/files/vc1.txt' into table varchar_join1_vc1;
+load data local inpath '../../data/files/vc1.txt' into table varchar_join1_vc2;
+load data local inpath '../../data/files/vc1.txt' into table varchar_join1_str;
-- Join varchar with same length varchar
select * from varchar_join1_vc1 a join varchar_join1_vc1 b on (a.c2 = b.c2) order by a.c1;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/varchar_serde.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/varchar_serde.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/varchar_serde.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/varchar_serde.q Sat Oct 12 16:37:47 2013
@@ -18,7 +18,7 @@ with serdeproperties (
)
stored as textfile;
-load data local inpath '../data/files/srcbucket0.txt' overwrite into table varchar_serde_regex;
+load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar_serde_regex;
select * from varchar_serde_regex limit 5;
select value, count(*) from varchar_serde_regex group by value limit 5;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/varchar_union1.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/varchar_union1.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/varchar_union1.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/varchar_union1.q Sat Oct 12 16:37:47 2013
@@ -17,9 +17,9 @@ create table varchar_union1_str (
c2 string
);
-load data local inpath '../data/files/vc1.txt' into table varchar_union1_vc1;
-load data local inpath '../data/files/vc1.txt' into table varchar_union1_vc2;
-load data local inpath '../data/files/vc1.txt' into table varchar_union1_str;
+load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc1;
+load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc2;
+load data local inpath '../../data/files/vc1.txt' into table varchar_union1_str;
-- union varchar with same length varchar
select * from (
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/view.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/view.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/view.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/view.q Sat Oct 12 16:37:47 2013
@@ -4,13 +4,13 @@ USE db1;
CREATE TABLE table1 (key STRING, value STRING)
STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
+LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
OVERWRITE INTO TABLE table1;
CREATE TABLE table2 (key STRING, value STRING)
STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
+LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
OVERWRITE INTO TABLE table2;
-- relative reference, no alias
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/view_cast.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/view_cast.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/view_cast.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/view_cast.q Sat Oct 12 16:37:47 2013
@@ -1,11 +1,11 @@
DROP TABLE IF EXISTS atab;
CREATE TABLE IF NOT EXISTS atab (ks_uid BIGINT, sr_uid STRING, sr_id STRING, tstamp STRING, m_id STRING, act STRING, at_sr_uid STRING, tstamp_type STRING, original_m_id STRING, original_tstamp STRING, registered_flag TINYINT, at_ks_uid BIGINT) PARTITIONED BY (dt STRING,nt STRING);
-LOAD DATA LOCAL INPATH '../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130312', nt='tw');
-LOAD DATA LOCAL INPATH '../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130311', nt='tw');
+LOAD DATA LOCAL INPATH '../../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130312', nt='tw');
+LOAD DATA LOCAL INPATH '../../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130311', nt='tw');
DROP TABLE IF EXISTS mstab;
CREATE TABLE mstab(ks_uid INT, csc INT) PARTITIONED BY (dt STRING);
-LOAD DATA LOCAL INPATH '../data/files/v2.txt' INTO TABLE mstab PARTITION (dt='20130311');
+LOAD DATA LOCAL INPATH '../../data/files/v2.txt' INTO TABLE mstab PARTITION (dt='20130311');
DROP VIEW IF EXISTS aa_view_tw;
CREATE VIEW aa_view_tw AS SELECT ks_uid, sr_id, act, at_ks_uid, at_sr_uid, from_unixtime(CAST(CAST( tstamp as BIGINT)/1000 AS BIGINT),'yyyyMMdd') AS act_date, from_unixtime(CAST(CAST( original_tstamp AS BIGINT)/1000 AS BIGINT),'yyyyMMdd') AS content_creation_date FROM atab WHERE dt='20130312' AND nt='tw' AND ks_uid != at_ks_uid;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/windowing.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/windowing.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/windowing.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/windowing.q Sat Oct 12 16:37:47 2013
@@ -13,7 +13,7 @@ CREATE TABLE part(
p_comment STRING
);
-LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part;
+LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part;
-- 1. testWindowing
select p_mfgr, p_name, p_size,
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/windowing_adjust_rowcontainer_sz.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/windowing_adjust_rowcontainer_sz.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/windowing_adjust_rowcontainer_sz.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/windowing_adjust_rowcontainer_sz.q Sat Oct 12 16:37:47 2013
@@ -13,7 +13,7 @@ CREATE TABLE part(
p_comment STRING
);
-LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part;
+LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part;
set hive.join.cache.size=1;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/windowing_columnPruning.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/windowing_columnPruning.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/windowing_columnPruning.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/windowing_columnPruning.q Sat Oct 12 16:37:47 2013
@@ -13,7 +13,7 @@ CREATE TABLE part(
p_comment STRING
);
-LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part;
+LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part;
-- 1. testQueryLevelPartitionColsNotInSelect
select p_size,
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/windowing_expressions.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/windowing_expressions.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/windowing_expressions.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/windowing_expressions.q Sat Oct 12 16:37:47 2013
@@ -13,7 +13,7 @@ CREATE TABLE part(
p_comment STRING
);
-LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part;
+LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part;
drop table over10k;
@@ -32,7 +32,7 @@ create table over10k(
row format delimited
fields terminated by '|';
-load data local inpath '../data/files/over10k' into table over10k;
+load data local inpath '../../data/files/over10k' into table over10k;
select p_mfgr, p_retailprice, p_size,
round(sum(p_retailprice) over w1 , 2) = round(sum(lag(p_retailprice,1,0.0)) over w1 + last_value(p_retailprice) over w1 , 2),
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/windowing_multipartitioning.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/windowing_multipartitioning.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/windowing_multipartitioning.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/windowing_multipartitioning.q Sat Oct 12 16:37:47 2013
@@ -15,7 +15,7 @@ create table over10k(
row format delimited
fields terminated by '|';
-load data local inpath '../data/files/over10k' into table over10k;
+load data local inpath '../../data/files/over10k' into table over10k;
select s, rank() over (partition by s order by si), sum(b) over (partition by s order by si) from over10k limit 100;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/windowing_navfn.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/windowing_navfn.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/windowing_navfn.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/windowing_navfn.q Sat Oct 12 16:37:47 2013
@@ -15,7 +15,7 @@ create table over10k(
row format delimited
fields terminated by '|';
-load data local inpath '../data/files/over10k' into table over10k;
+load data local inpath '../../data/files/over10k' into table over10k;
select s, row_number() over (partition by d order by dec) from over10k limit 100;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/windowing_ntile.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/windowing_ntile.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/windowing_ntile.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/windowing_ntile.q Sat Oct 12 16:37:47 2013
@@ -15,7 +15,7 @@ create table over10k(
row format delimited
fields terminated by '|';
-load data local inpath '../data/files/over10k' into table over10k;
+load data local inpath '../../data/files/over10k' into table over10k;
select i, ntile(10) over (partition by s order by i) from over10k limit 100;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/windowing_rank.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/windowing_rank.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/windowing_rank.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/windowing_rank.q Sat Oct 12 16:37:47 2013
@@ -15,7 +15,7 @@ create table over10k(
row format delimited
fields terminated by '|';
-load data local inpath '../data/files/over10k' into table over10k;
+load data local inpath '../../data/files/over10k' into table over10k;
select s, rank() over (partition by f order by t) from over10k limit 100;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/windowing_udaf.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/windowing_udaf.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/windowing_udaf.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/windowing_udaf.q Sat Oct 12 16:37:47 2013
@@ -15,7 +15,7 @@ create table over10k(
row format delimited
fields terminated by '|';
-load data local inpath '../data/files/over10k' into table over10k;
+load data local inpath '../../data/files/over10k' into table over10k;
select s, min(i) over (partition by s) from over10k limit 100;
Modified: hive/branches/maven/ql/src/test/queries/clientpositive/windowing_windowspec.q
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/queries/clientpositive/windowing_windowspec.q?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/queries/clientpositive/windowing_windowspec.q (original)
+++ hive/branches/maven/ql/src/test/queries/clientpositive/windowing_windowspec.q Sat Oct 12 16:37:47 2013
@@ -15,7 +15,7 @@ create table over10k(
row format delimited
fields terminated by '|';
-load data local inpath '../data/files/over10k' into table over10k;
+load data local inpath '../../data/files/over10k' into table over10k;
select s, sum(b) over (partition by i order by s,b rows unbounded preceding) from over10k limit 100;
Modified: hive/branches/maven/ql/src/test/results/beelinepositive/input37.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/beelinepositive/input37.q.out?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/beelinepositive/input37.q.out (original)
+++ hive/branches/maven/ql/src/test/results/beelinepositive/input37.q.out Sat Oct 12 16:37:47 2013
@@ -12,7 +12,7 @@ FROM
(
FROM documents
MAP documents.contents
-USING 'java -cp ../build/ql/test/classes org.apache.hadoop.hive.scripts.extracturl' AS (url, count)
+USING 'java -cp ../util/target/classes/ org.apache.hadoop.hive.scripts.extracturl' AS (url, count)
) subq
group by url;
'url','_c1'
Modified: hive/branches/maven/ql/src/test/results/clientnegative/exim_00_unsupported_schema.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientnegative/exim_00_unsupported_schema.q.out?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientnegative/exim_00_unsupported_schema.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientnegative/exim_00_unsupported_schema.q.out Sat Oct 12 16:37:47 2013
@@ -7,10 +7,10 @@ POSTHOOK: query: create table exim_depar
tblproperties("creator"="krishna")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@exim_department
-PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+PREHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_department
PREHOOK: type: LOAD
PREHOOK: Output: default@exim_department
-POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+POSTHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
#### A masked pattern was here ####
Modified: hive/branches/maven/ql/src/test/results/clientnegative/exim_01_nonpart_over_loaded.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientnegative/exim_01_nonpart_over_loaded.q.out?rev=1531557&r1=1531556&r2=1531557&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientnegative/exim_01_nonpart_over_loaded.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientnegative/exim_01_nonpart_over_loaded.q.out Sat Oct 12 16:37:47 2013
@@ -7,10 +7,10 @@ POSTHOOK: query: create table exim_depar
tblproperties("creator"="krishna")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@exim_department
-PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+PREHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_department
PREHOOK: type: LOAD
PREHOOK: Output: default@exim_department
-POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+POSTHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: default@exim_department
#### A masked pattern was here ####
@@ -47,10 +47,10 @@ POSTHOOK: query: create table exim_depar
tblproperties("maker"="krishna")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: importer@exim_department
-PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+PREHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_department
PREHOOK: type: LOAD
PREHOOK: Output: importer@exim_department
-POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
+POSTHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
POSTHOOK: Output: importer@exim_department
FAILED: SemanticException [Error 10119]: Table exists and contains data files