Home
last modified time | relevance | path

Searched refs:OVERWRITE (Results 1 – 25 of 1278) sorted by relevance

12345678910>>...52

/dports/devel/spark/spark-2.1.1/sql/hive/src/test/resources/ql/src/test/queries/clientpositive/
H A Dgroupby9.q7 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
11 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
19 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
23 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
33 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
37 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
45 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(SUBSTR(SRC.value,5)) GROUP BY SRC.key
46 INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(SUBSTR(SRC.value,5)) GROUP BY SRC.key…
49 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(SUBSTR(SRC.value,5)) GROUP BY SRC.key
57 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
[all …]
H A Dppd_multi_insert.q10 INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
11 INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
13 INSERT OVERWRITE DIRECTORY 'target/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300;
16 INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
17 INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
19 INSERT OVERWRITE DIRECTORY 'target/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300;
31 INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
32 INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
34 INSERT OVERWRITE DIRECTORY 'target/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300;
37 INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
[all …]
H A Dgroupby_sort_skew_1.q21 INSERT OVERWRITE TABLE outputTbl1
24 INSERT OVERWRITE TABLE outputTbl1
33 INSERT OVERWRITE TABLE outputTbl2
36 INSERT OVERWRITE TABLE outputTbl2
43 INSERT OVERWRITE TABLE outputTbl1
46 INSERT OVERWRITE TABLE outputTbl1
53 INSERT OVERWRITE TABLE outputTbl1
56 INSERT OVERWRITE TABLE outputTbl1
66 INSERT OVERWRITE TABLE outputTbl3
69 INSERT OVERWRITE TABLE outputTbl3
[all …]
H A Dgroupby_sort_1.q20 INSERT OVERWRITE TABLE outputTbl1
23 INSERT OVERWRITE TABLE outputTbl1
32 INSERT OVERWRITE TABLE outputTbl2
35 INSERT OVERWRITE TABLE outputTbl2
42 INSERT OVERWRITE TABLE outputTbl1
45 INSERT OVERWRITE TABLE outputTbl1
52 INSERT OVERWRITE TABLE outputTbl1
55 INSERT OVERWRITE TABLE outputTbl1
65 INSERT OVERWRITE TABLE outputTbl3
68 INSERT OVERWRITE TABLE outputTbl3
[all …]
H A Dmultigroupby_singlemr.q10 INSERT OVERWRITE TABLE DEST1 SELECT TBL.C1, COUNT(TBL.C2) GROUP BY TBL.C1
11 INSERT OVERWRITE TABLE DEST2 SELECT TBL.C1, TBL.C2, COUNT(TBL.C3) GROUP BY TBL.C1, TBL.C2;
15 INSERT OVERWRITE TABLE DEST1 SELECT TBL.C1, COUNT(TBL.C2) GROUP BY TBL.C1
16 INSERT OVERWRITE TABLE DEST2 SELECT TBL.C1, TBL.C2, COUNT(TBL.C3) GROUP BY TBL.C2, TBL.C1;
20 INSERT OVERWRITE TABLE DEST3 SELECT TBL.C1, TBL.C2, TBL.C3, COUNT(TBL.C4) GROUP BY TBL.C1, TBL.C2, …
21 INSERT OVERWRITE TABLE DEST2 SELECT TBL.C1, TBL.C2, COUNT(TBL.C3) GROUP BY TBL.C1, TBL.C2;
25 INSERT OVERWRITE TABLE DEST3 SELECT TBL.C1, TBL.C2, TBL.C3, COUNT(TBL.C4) GROUP BY TBL.C1, TBL.C2, …
26 INSERT OVERWRITE TABLE DEST4 SELECT TBL.C1, TBL.C2, TBL.C3, COUNT(TBL.C4) GROUP BY TBL.C1, TBL.C3, …
31 INSERT OVERWRITE TABLE DEST3 SELECT TBL.C1, TBL.C2, TBL.C3, COUNT(TBL.C4) GROUP BY TBL.C1, TBL.C2, …
32 INSERT OVERWRITE TABLE DEST2 SELECT TBL.C1, TBL.C2, COUNT(TBL.C3) GROUP BY TBL.C1, TBL.C2
[all …]
H A Dgroupby10.q13 INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, count(substr(INPUT.value,5)), count(distinct substr(…
14 INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(substr(INPUT.value,5)), sum(distinct substr(INPU…
17 INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, count(substr(INPUT.value,5)), count(distinct substr(…
18 INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(substr(INPUT.value,5)), sum(distinct substr(INPU…
27 INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, count(substr(INPUT.value,5)), count(distinct substr(…
28 INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(substr(INPUT.value,5)), sum(distinct substr(INPU…
31 INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, count(substr(INPUT.value,5)), count(distinct substr(…
32 INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(substr(INPUT.value,5)), sum(distinct substr(INPU…
40 INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, sum(distinct substr(INPUT.value,5)), count(distinct …
41 INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(distinct substr(INPUT.value,5)), avg(distinct su…
[all …]
H A Dinput13.q7 INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
8 INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
9 INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 20…
10 INSERT OVERWRITE DIRECTORY 'target/warehouse/dest4.out' SELECT src.value WHERE src.key >= 300;
13 INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
14 INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
15 INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 20…
16 INSERT OVERWRITE DIRECTORY 'target/warehouse/dest4.out' SELECT src.value WHERE src.key >= 300;
H A Dmulti_insert_gby.q6 INSERT OVERWRITE TABLE e1
8 INSERT OVERWRITE TABLE e2
12 INSERT OVERWRITE TABLE e1
14 INSERT OVERWRITE TABLE e2
21 INSERT OVERWRITE TABLE e1
23 INSERT OVERWRITE TABLE e2
27 INSERT OVERWRITE TABLE e1
29 INSERT OVERWRITE TABLE e2
H A Dinfer_bucket_sort.q9 INSERT OVERWRITE TABLE test_table PARTITION (part = '1')
15 INSERT OVERWRITE TABLE test_table PARTITION (part = '1')
21 INSERT OVERWRITE TABLE test_table PARTITION (part = '1')
27 INSERT OVERWRITE TABLE test_table PARTITION (part = '1')
33 INSERT OVERWRITE TABLE test_table PARTITION (part = '1')
39 INSERT OVERWRITE TABLE test_table PARTITION (part = '1')
45 INSERT OVERWRITE TABLE test_table PARTITION (part = '1')
51 INSERT OVERWRITE TABLE test_table PARTITION (part = '1')
57 INSERT OVERWRITE TABLE test_table PARTITION (part = '1')
81 INSERT OVERWRITE TABLE test_table PARTITION (part = '1')
[all …]
H A Dmulti_insert_gby3.q7 INSERT OVERWRITE TABLE e1
9 INSERT OVERWRITE TABLE e2
14 INSERT OVERWRITE TABLE e2
16 INSERT OVERWRITE TABLE e1
20 INSERT OVERWRITE TABLE e1
22 INSERT OVERWRITE TABLE e2
29 INSERT OVERWRITE TABLE e2
31 INSERT OVERWRITE TABLE e1
47 INSERT OVERWRITE TABLE e1
49 INSERT OVERWRITE TABLE e2
H A Dgroupby8.q9 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
10 INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key;
13 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
14 INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key;
23 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
24 INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key;
27 INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
28 INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key;
H A Dauto_sortmerge_join_13.q28 INSERT OVERWRITE TABLE dest1 select key1, key2
29 INSERT OVERWRITE TABLE dest2 select value1, value2;
35 INSERT OVERWRITE TABLE dest1 select key1, key2
36 INSERT OVERWRITE TABLE dest2 select value1, value2;
50 INSERT OVERWRITE TABLE dest1 select key1, key2
51 INSERT OVERWRITE TABLE dest2 select value1, value2;
57 INSERT OVERWRITE TABLE dest1 select key1, key2
58 INSERT OVERWRITE TABLE dest2 select value1, value2;
70 INSERT OVERWRITE TABLE dest1 select key1, key2
71 INSERT OVERWRITE TABLE dest2 select value1, value2;
[all …]
H A Dinfer_bucket_sort_multi_insert.q13 INSERT OVERWRITE TABLE test_table PARTITION (part = '1') SELECT key, value
14 INSERT OVERWRITE TABLE test_table PARTITION (part = '2') SELECT value, key;
22 INSERT OVERWRITE TABLE test_table PARTITION (part = '1') SELECT key, COUNT(*) GROUP BY key
23 INSERT OVERWRITE TABLE test_table PARTITION (part = '2') SELECT COUNT(*), value GROUP BY value;
31 INSERT OVERWRITE TABLE test_table PARTITION (part = '1') SELECT key, COUNT(*) GROUP BY key
32 INSERT OVERWRITE TABLE test_table PARTITION (part = '2') SELECT key, value;
42 INSERT OVERWRITE TABLE test_table PARTITION (part = '1') SELECT key, COUNT(*) GROUP BY key
43 INSERT OVERWRITE TABLE test_table PARTITION (part = '2') SELECT key, SUM(SUBSTR(value, 5)) GROUP BY…
H A Dsubquery_multiinsert.q17 INSERT OVERWRITE TABLE src_4
24 INSERT OVERWRITE TABLE src_5
31 INSERT OVERWRITE TABLE src_4
38 INSERT OVERWRITE TABLE src_5
52 INSERT OVERWRITE TABLE src_4
59 INSERT OVERWRITE TABLE src_5
66 INSERT OVERWRITE TABLE src_4
73 INSERT OVERWRITE TABLE src_5
H A Dinput12_hadoop20.q12 INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
13 INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
14 INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 20…
17 INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
18 INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
19 INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 20…
H A Dinput12.q13 INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
14 INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
15 INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 20…
18 INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
19 INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
20 INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 20…
H A Dbucketsortoptimize_insert_2.q37 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
42 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
53 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
58 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
69 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
74 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
84 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
92 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
105 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
113 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
[all …]
H A Dgroupby_multi_single_reducer.q11 INSERT OVERWRITE TABLE dest_g2 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), con…
12 INSERT OVERWRITE TABLE dest_g3 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), con…
13 INSERT OVERWRITE TABLE dest_g4 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), con…
16 INSERT OVERWRITE TABLE dest_g2 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), con…
17 INSERT OVERWRITE TABLE dest_g3 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), con…
18 INSERT OVERWRITE TABLE dest_g4 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), con…
27 INSERT OVERWRITE TABLE dest_g3 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), con…
28 INSERT OVERWRITE TABLE dest_g4 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), con…
29 INSERT OVERWRITE TABLE dest_h2 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), con…
35 INSERT OVERWRITE TABLE dest_g4 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), con…
[all …]
H A Dinfer_bucket_sort_map_operators.q15 INSERT OVERWRITE TABLE test_table1 SELECT key, value FROM src;
17 INSERT OVERWRITE TABLE test_table2 SELECT key, value FROM src;
24 EXPLAIN INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
27 INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
33 EXPLAIN INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
41 INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
56 EXPLAIN INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
59 INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
65 EXPLAIN INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
69 INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
H A Dalter_numbuckets_partitioned_table2_h23.q11 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
20 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
29 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
38 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
47 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
56 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
65 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
74 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
83 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
H A Dinfer_bucket_sort_grouping_operators.q12 EXPLAIN INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
15 INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
22 INSERT OVERWRITE TABLE test_table_out_2 PARTITION (part = '1')
28 EXPLAIN INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
31 INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
38 INSERT OVERWRITE TABLE test_table_out_2 PARTITION (part = '1')
44 EXPLAIN INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
47 INSERT OVERWRITE TABLE test_table_out PARTITION (part = '1')
54 INSERT OVERWRITE TABLE test_table_out_2 PARTITION (part = '1')
H A Dalter_numbuckets_partitioned_table2.q11 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
20 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
29 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
38 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
47 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
56 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
65 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
74 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
83 INSERT OVERWRITE TABLE tst1 PARTITION (ds = '1') SELECT key, value FROM src;
H A Dgroupby_complex_types.q7 INSERT OVERWRITE TABLE DEST1 SELECT ARRAY(SRC.key), COUNT(1) GROUP BY ARRAY(SRC.key)
8 INSERT OVERWRITE TABLE DEST2 SELECT MAP(SRC.key, SRC.value), COUNT(1) GROUP BY MAP(SRC.key, SRC.val…
9 INSERT OVERWRITE TABLE DEST3 SELECT STRUCT(SRC.key, SRC.value), COUNT(1) GROUP BY STRUCT(SRC.key, S…
12 INSERT OVERWRITE TABLE DEST1 SELECT ARRAY(SRC.key), COUNT(1) GROUP BY ARRAY(SRC.key)
13 INSERT OVERWRITE TABLE DEST2 SELECT MAP(SRC.key, SRC.value), COUNT(1) GROUP BY MAP(SRC.key, SRC.val…
14 INSERT OVERWRITE TABLE DEST3 SELECT STRUCT(SRC.key, SRC.value), COUNT(1) GROUP BY STRUCT(SRC.key, S…
H A Dgroupby_sort_5.q12 INSERT OVERWRITE TABLE T1 select key, val from T1;
20 INSERT OVERWRITE TABLE outputTbl1
23 INSERT OVERWRITE TABLE outputTbl1
36 INSERT OVERWRITE TABLE T1 select key, val from T1;
42 INSERT OVERWRITE TABLE outputTbl1
45 INSERT OVERWRITE TABLE outputTbl1
58 INSERT OVERWRITE TABLE T1 select key, val from T1;
67 INSERT OVERWRITE TABLE outputTbl2
70 INSERT OVERWRITE TABLE outputTbl2
/dports/devel/spark/spark-2.1.1/sql/hive/src/test/resources/data/scripts/
H A Dq_test_init.sql90 OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-08", hr="11");
93 OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-08", hr="12");
96 OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-09", hr="11");
99 OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-09", hr="12");
122 OVERWRITE INTO TABLE primitives PARTITION(year=2009, month=1);
125 OVERWRITE INTO TABLE primitives PARTITION(year=2009, month=2);
128 OVERWRITE INTO TABLE primitives PARTITION(year=2009, month=3);
131 OVERWRITE INTO TABLE primitives PARTITION(year=2009, month=4);

12345678910>>...52