/dports/devel/spark/spark-2.1.1/sql/hive/src/test/resources/ql/src/test/queries/clientpositive/ |
H A D | groupby9.q | 7 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 D | ppd_multi_insert.q | 10 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 D | groupby_sort_skew_1.q | 21 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 D | groupby_sort_1.q | 20 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 D | multigroupby_singlemr.q | 10 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 D | groupby10.q | 13 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 D | input13.q | 7 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 D | multi_insert_gby.q | 6 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 D | infer_bucket_sort.q | 9 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 D | multi_insert_gby3.q | 7 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 D | groupby8.q | 9 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 D | auto_sortmerge_join_13.q | 28 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 D | infer_bucket_sort_multi_insert.q | 13 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 D | subquery_multiinsert.q | 17 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 D | input12_hadoop20.q | 12 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 D | input12.q | 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… 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 D | bucketsortoptimize_insert_2.q | 37 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 D | groupby_multi_single_reducer.q | 11 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 D | infer_bucket_sort_map_operators.q | 15 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 D | alter_numbuckets_partitioned_table2_h23.q | 11 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 D | infer_bucket_sort_grouping_operators.q | 12 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 D | alter_numbuckets_partitioned_table2.q | 11 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 D | groupby_complex_types.q | 7 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 D | groupby_sort_5.q | 12 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 D | q_test_init.sql | 90 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);
|