Repository: tajo Updated Branches: refs/heads/master d3ee50a95 -> a5d14f808
http://git-wip-us.apache.org/repos/asf/tajo/blob/a5d14f80/tajo-core/src/test/resources/dataset/TestJoinBroadcast/orders_large/orders.tbl ---------------------------------------------------------------------- diff --git a/tajo-core/src/test/resources/dataset/TestJoinBroadcast/orders_large/orders.tbl b/tajo-core/src/test/resources/dataset/TestJoinBroadcast/orders_large/orders.tbl new file mode 100644 index 0000000..26b2a9a --- /dev/null +++ b/tajo-core/src/test/resources/dataset/TestJoinBroadcast/orders_large/orders.tbl @@ -0,0 +1,300 @@ +1|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +2|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +3|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +4|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +5|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +6|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +7|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +8|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +9|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +10|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +11|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +12|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +13|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +14|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +15|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +16|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +17|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +18|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +19|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +20|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +21|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +22|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +23|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +24|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +25|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +26|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +27|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +28|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +29|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +30|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +31|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +32|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +33|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +34|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +35|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +36|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +37|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +38|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +39|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +40|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +41|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +42|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +43|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +44|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +45|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +46|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +47|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +48|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +49|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +50|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +51|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +52|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +53|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +54|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +55|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +56|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +57|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +58|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +59|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +60|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +61|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +62|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +63|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +64|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +65|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +66|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +67|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +68|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +69|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +70|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +71|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +72|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +73|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +74|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +75|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +76|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +77|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +78|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +79|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +80|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +81|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +82|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +83|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +84|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +85|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +86|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +87|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +88|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +89|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +90|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +91|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +92|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +93|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +94|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +95|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +96|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +97|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +98|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +99|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +100|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +101|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +102|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +103|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +104|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +105|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +106|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +107|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +108|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +109|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +110|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +111|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +112|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +113|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +114|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +115|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +116|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +117|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +118|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +119|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +120|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +121|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +122|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +123|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +124|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +125|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +126|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +127|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +128|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +129|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +130|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +131|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +132|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +133|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +134|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +135|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +136|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +137|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +138|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +139|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +140|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +141|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +142|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +143|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +144|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +145|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +146|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +147|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +148|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +149|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +150|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +151|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +152|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +153|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +154|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +155|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +156|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +157|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +158|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +159|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +160|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +161|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +162|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +163|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +164|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +165|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +166|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +167|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +168|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +169|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +170|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +171|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +172|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +173|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +174|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +175|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +176|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +177|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +178|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +179|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +180|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +181|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +182|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +183|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +184|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +185|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +186|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +187|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +188|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +189|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +190|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +191|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +192|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +193|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +194|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +195|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +196|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +197|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +198|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +199|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +200|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +201|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +202|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +203|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +204|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +205|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +206|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +207|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +208|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +209|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +210|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +211|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +212|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +213|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +214|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +215|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +216|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +217|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +218|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +219|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +220|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +221|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +222|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +223|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +224|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +225|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +226|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +227|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +228|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +229|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +230|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +231|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +232|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +233|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +234|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +235|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +236|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +237|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +238|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +239|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +240|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +241|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +242|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +243|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +244|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +245|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +246|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +247|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +248|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +249|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +250|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +251|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +252|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +253|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +254|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +255|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +256|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +257|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +258|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +259|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +260|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +261|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +262|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +263|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +264|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +265|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +266|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +267|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +268|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +269|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +270|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +271|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +272|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +273|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +274|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +275|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +276|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +277|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +278|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +279|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +280|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +281|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +282|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +283|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +284|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +285|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +286|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +287|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +288|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +289|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +290|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +291|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +292|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +293|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +294|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +295|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +296|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +297|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| +298|3|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | +299|4|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| +300|2|F|193846.25|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| http://git-wip-us.apache.org/repos/asf/tajo/blob/a5d14f80/tajo-core/src/test/resources/queries/TestJoinBroadcast/create_orders_large_ddl.sql ---------------------------------------------------------------------- diff --git a/tajo-core/src/test/resources/queries/TestJoinBroadcast/create_orders_large_ddl.sql b/tajo-core/src/test/resources/queries/TestJoinBroadcast/create_orders_large_ddl.sql new file mode 100644 index 0000000..4b9bb65 --- /dev/null +++ b/tajo-core/src/test/resources/queries/TestJoinBroadcast/create_orders_large_ddl.sql @@ -0,0 +1,7 @@ +-- Large Orders Table +-- It is used for broadcast join + +create external table if not exists orders_large ( o_orderkey INT4, o_custkey INT4, + o_orderstatus TEXT, o_totalprice FLOAT8, o_orderdate TEXT, + o_orderpriority TEXT, o_clerk TEXT, o_shippriority INT4, o_comment TEXT) +using csv with ('csvfile.delimiter'='|', 'csvfile.null'='NULL') location ${table.path}; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a5d14f80/tajo-core/src/test/resources/queries/TestJoinBroadcast/testBroadcastSubquery.sql ---------------------------------------------------------------------- diff --git a/tajo-core/src/test/resources/queries/TestJoinBroadcast/testBroadcastSubquery.sql b/tajo-core/src/test/resources/queries/TestJoinBroadcast/testBroadcastSubquery.sql index dcd9569..cc63b2e 100644 --- a/tajo-core/src/test/resources/queries/TestJoinBroadcast/testBroadcastSubquery.sql +++ b/tajo-core/src/test/resources/queries/TestJoinBroadcast/testBroadcastSubquery.sql @@ -8,4 +8,5 @@ from (select o_orderkey, o_custkey from orders) a where l_partkey = p_partkey - and l_orderkey = a.o_orderkey \ No newline at end of file + and l_orderkey = a.o_orderkey +order by l_orderkey, o_custkey, p_name \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a5d14f80/tajo-core/src/test/resources/queries/TestJoinBroadcast/testLeftOuterJoin2.sql ---------------------------------------------------------------------- diff --git a/tajo-core/src/test/resources/queries/TestJoinBroadcast/testLeftOuterJoin2.sql b/tajo-core/src/test/resources/queries/TestJoinBroadcast/testLeftOuterJoin2.sql new file mode 100644 index 0000000..4061200 --- /dev/null +++ b/tajo-core/src/test/resources/queries/TestJoinBroadcast/testLeftOuterJoin2.sql @@ -0,0 +1,5 @@ +select a.l_orderkey, b.c_custkey, b.c_name, b.c_nationkey, d.n_name +from lineitem_large a +left outer join customer_large b on a.l_orderkey = b.c_custkey +left outer join orders c on b.c_custkey = c.o_custkey +left outer join nation d on a.l_orderkey = d.n_nationkey http://git-wip-us.apache.org/repos/asf/tajo/blob/a5d14f80/tajo-core/src/test/resources/queries/TestJoinBroadcast/testLeftOuterJoin3.sql ---------------------------------------------------------------------- diff --git a/tajo-core/src/test/resources/queries/TestJoinBroadcast/testLeftOuterJoin3.sql b/tajo-core/src/test/resources/queries/TestJoinBroadcast/testLeftOuterJoin3.sql new file mode 100644 index 0000000..a983b41 --- /dev/null +++ b/tajo-core/src/test/resources/queries/TestJoinBroadcast/testLeftOuterJoin3.sql @@ -0,0 +1,7 @@ +select a.c_custkey, a.c_name, a.c_nationkey, b.l_orderkey, c.o_orderdate, d.o_orderdate, e.n_name, f.p_name +from customer_large a +left outer join lineitem_large b on a.c_custkey = b.l_orderkey +left outer join orders c on b.l_orderkey = c.o_orderkey +left outer join orders_large d on a.c_custkey = d.o_orderkey +left outer join nation e on d.o_orderkey = e.n_nationkey +left outer join part f on f.p_partkey = d.o_orderkey http://git-wip-us.apache.org/repos/asf/tajo/blob/a5d14f80/tajo-core/src/test/resources/queries/TestJoinOnPartitionedTables/testFilterPushDownPartitionColumnCaseWhen.sql ---------------------------------------------------------------------- diff --git a/tajo-core/src/test/resources/queries/TestJoinOnPartitionedTables/testFilterPushDownPartitionColumnCaseWhen.sql b/tajo-core/src/test/resources/queries/TestJoinOnPartitionedTables/testFilterPushDownPartitionColumnCaseWhen.sql index 951b831..f5f426b 100644 --- a/tajo-core/src/test/resources/queries/TestJoinOnPartitionedTables/testFilterPushDownPartitionColumnCaseWhen.sql +++ b/tajo-core/src/test/resources/queries/TestJoinOnPartitionedTables/testFilterPushDownPartitionColumnCaseWhen.sql @@ -2,4 +2,5 @@ select c_custkey, c_nationkey, c_name, o_custkey, (case when a.c_nationkey > 3 t from customer_parts a inner join orders b on a.c_custkey = b.o_custkey -where a.c_custkey = (case when a.c_name like 'Customer%' and a.c_nationkey > 3 then 4 else 3 end) \ No newline at end of file +where a.c_custkey = (case when a.c_name like 'Customer%' and a.c_nationkey > 3 then 4 else 3 end) +order by c_custkey \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a5d14f80/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery.result ---------------------------------------------------------------------- diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery.result index e3c4bd7..d95e0c9 100644 --- a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery.result +++ b/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery.result @@ -1,15 +1,15 @@ l_orderkey,o_custkey,p_name ------------------------------- +1,3,blush thistle blue yellow saddle 1,3,goldenrod lavender spring chocolate lace 1,3,goldenrod lavender spring chocolate lace 1,3,goldenrod lavender spring chocolate lace -3,2,goldenrod lavender spring chocolate lace -3,2,goldenrod lavender spring chocolate lace -1,3,blush thistle blue yellow saddle -2,4,blush thistle blue yellow saddle -3,2,blush thistle blue yellow saddle 1,3,spring green yellow purple cornsilk 1,3,spring green yellow purple cornsilk +2,4,blush thistle blue yellow saddle +3,2,blush thistle blue yellow saddle +3,2,goldenrod lavender spring chocolate lace +3,2,goldenrod lavender spring chocolate lace 3,2,spring green yellow purple cornsilk 3,2,spring green yellow purple cornsilk 3,2,spring green yellow purple cornsilk \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a5d14f80/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin2.result ---------------------------------------------------------------------- diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin2.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin2.result new file mode 100644 index 0000000..ee73754 --- /dev/null +++ b/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin2.result @@ -0,0 +1,99 @@ +l_orderkey,c_custkey,c_name,c_nationkey,n_name +------------------------------- +1,1,Customer#000000001,10,ARGENTINA +1,1,Customer#000000001,10,ARGENTINA +1,1,Customer#000000001,10,ARGENTINA +1,1,Customer#000000001,10,ARGENTINA +1,1,Customer#000000001,10,ARGENTINA +1,1,Customer#000000001,10,ARGENTINA +2,2,Customer#000000002,7,BRAZIL +3,3,Customer#000000003,7,CANADA +3,3,Customer#000000003,7,CANADA +3,3,Customer#000000003,7,CANADA +3,3,Customer#000000003,7,CANADA +3,3,Customer#000000003,7,CANADA +3,3,Customer#000000003,7,CANADA +4,4,Customer#000000004,10,EGYPT +5,5,Customer#000000005,5,ETHIOPIA +5,5,Customer#000000005,5,ETHIOPIA +5,5,Customer#000000005,5,ETHIOPIA +6,6,Customer#000000006,17,FRANCE +7,7,Customer#000000007,21,GERMANY +7,7,Customer#000000007,21,GERMANY +7,7,Customer#000000007,21,GERMANY +7,7,Customer#000000007,21,GERMANY +7,7,Customer#000000007,21,GERMANY +7,7,Customer#000000007,21,GERMANY +7,7,Customer#000000007,21,GERMANY +32,32,Customer#000000032,15,null +32,32,Customer#000000032,15,null +32,32,Customer#000000032,15,null +32,32,Customer#000000032,15,null +32,32,Customer#000000032,15,null +32,32,Customer#000000032,15,null +33,33,Customer#000000033,4,null +33,33,Customer#000000033,4,null +33,33,Customer#000000033,4,null +33,33,Customer#000000033,4,null +34,34,Customer#000000034,11,null +34,34,Customer#000000034,11,null +34,34,Customer#000000034,11,null +35,35,Customer#000000035,22,null +35,35,Customer#000000035,22,null +35,35,Customer#000000035,22,null +35,35,Customer#000000035,22,null +35,35,Customer#000000035,22,null +35,35,Customer#000000035,22,null +36,36,Customer#000000036,15,null +37,37,Customer#000000037,11,null +37,37,Customer#000000037,11,null +37,37,Customer#000000037,11,null +38,38,Customer#000000038,14,null +39,39,Customer#000000039,3,null +39,39,Customer#000000039,3,null +39,39,Customer#000000039,3,null +39,39,Customer#000000039,3,null +39,39,Customer#000000039,3,null +39,39,Customer#000000039,3,null +64,64,Customer#000000064,15,null +65,65,Customer#000000065,10,null +65,65,Customer#000000065,10,null +65,65,Customer#000000065,10,null +66,66,Customer#000000066,1,null +66,66,Customer#000000066,1,null +67,67,Customer#000000067,0,null +67,67,Customer#000000067,0,null +67,67,Customer#000000067,0,null +67,67,Customer#000000067,0,null +67,67,Customer#000000067,0,null +67,67,Customer#000000067,0,null +68,68,Customer#000000068,3,null +68,68,Customer#000000068,3,null +68,68,Customer#000000068,3,null +68,68,Customer#000000068,3,null +68,68,Customer#000000068,3,null +68,68,Customer#000000068,3,null +68,68,Customer#000000068,3,null +69,69,Customer#000000069,13,null +69,69,Customer#000000069,13,null +69,69,Customer#000000069,13,null +69,69,Customer#000000069,13,null +69,69,Customer#000000069,13,null +69,69,Customer#000000069,13,null +70,70,Customer#000000070,3,null +70,70,Customer#000000070,3,null +70,70,Customer#000000070,3,null +70,70,Customer#000000070,3,null +70,70,Customer#000000070,3,null +70,70,Customer#000000070,3,null +71,71,Customer#000000071,16,null +71,71,Customer#000000071,16,null +71,71,Customer#000000071,16,null +71,71,Customer#000000071,16,null +71,71,Customer#000000071,16,null +71,71,Customer#000000071,16,null +96,96,Customer#000000096,7,null +96,96,Customer#000000096,7,null +97,97,Customer#000000097,16,null +97,97,Customer#000000097,16,null +97,97,Customer#000000097,16,null \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a5d14f80/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin3.result ---------------------------------------------------------------------- diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin3.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin3.result new file mode 100644 index 0000000..f188d27 --- /dev/null +++ b/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin3.result @@ -0,0 +1,174 @@ +c_custkey,c_name,c_nationkey,l_orderkey,o_orderdate,o_orderdate,n_name,p_name +------------------------------- +1,Customer#000000001,10,1,1996-01-02,1996-01-02,ARGENTINA,goldenrod lavender spring chocolate lace +1,Customer#000000001,10,1,1996-01-02,1996-01-02,ARGENTINA,goldenrod lavender spring chocolate lace +1,Customer#000000001,10,1,1996-01-02,1996-01-02,ARGENTINA,goldenrod lavender spring chocolate lace +1,Customer#000000001,10,1,1996-01-02,1996-01-02,ARGENTINA,goldenrod lavender spring chocolate lace +1,Customer#000000001,10,1,1996-01-02,1996-01-02,ARGENTINA,goldenrod lavender spring chocolate lace +1,Customer#000000001,10,1,1996-01-02,1996-01-02,ARGENTINA,goldenrod lavender spring chocolate lace +2,Customer#000000002,7,2,1996-12-01,1996-12-01,BRAZIL,blush thistle blue yellow saddle +3,Customer#000000003,7,3,1993-10-14,1993-10-14,CANADA,spring green yellow purple cornsilk +3,Customer#000000003,7,3,1993-10-14,1993-10-14,CANADA,spring green yellow purple cornsilk +3,Customer#000000003,7,3,1993-10-14,1993-10-14,CANADA,spring green yellow purple cornsilk +3,Customer#000000003,7,3,1993-10-14,1993-10-14,CANADA,spring green yellow purple cornsilk +3,Customer#000000003,7,3,1993-10-14,1993-10-14,CANADA,spring green yellow purple cornsilk +3,Customer#000000003,7,3,1993-10-14,1993-10-14,CANADA,spring green yellow purple cornsilk +4,Customer#000000004,10,4,null,1996-01-02,EGYPT,null +5,Customer#000000005,5,5,null,1996-12-01,ETHIOPIA,null +5,Customer#000000005,5,5,null,1996-12-01,ETHIOPIA,null +5,Customer#000000005,5,5,null,1996-12-01,ETHIOPIA,null +6,Customer#000000006,17,6,null,1993-10-14,FRANCE,null +7,Customer#000000007,21,7,null,1996-01-02,GERMANY,null +7,Customer#000000007,21,7,null,1996-01-02,GERMANY,null +7,Customer#000000007,21,7,null,1996-01-02,GERMANY,null +7,Customer#000000007,21,7,null,1996-01-02,GERMANY,null +7,Customer#000000007,21,7,null,1996-01-02,GERMANY,null +7,Customer#000000007,21,7,null,1996-01-02,GERMANY,null +7,Customer#000000007,21,7,null,1996-01-02,GERMANY,null +8,Customer#000000008,4,null,null,1996-12-01,INDIA,null +9,Customer#000000009,16,null,null,1993-10-14,INDONESIA,null +10,Customer#000000010,20,null,null,1996-01-02,IRAN,null +11,Customer#000000011,19,null,null,1996-12-01,IRAQ,null +12,Customer#000000012,16,null,null,1993-10-14,JAPAN,null +13,Customer#000000013,9,null,null,1996-01-02,JORDAN,null +14,Customer#000000014,22,null,null,1996-12-01,KENYA,null +15,Customer#000000015,19,null,null,1993-10-14,MOROCCO,null +16,Customer#000000016,17,null,null,1996-01-02,MOZAMBIQUE,null +17,Customer#000000017,12,null,null,1996-12-01,PERU,null +18,Customer#000000018,3,null,null,1993-10-14,CHINA,null +19,Customer#000000019,10,null,null,1996-01-02,ROMANIA,null +20,Customer#000000020,23,null,null,1996-12-01,SAUDI ARABIA,null +21,Customer#000000021,19,null,null,1993-10-14,VIETNAM,null +22,Customer#000000022,17,null,null,1996-01-02,RUSSIA,null +23,Customer#000000023,15,null,null,1996-12-01,UNITED KINGDOM,null +24,Customer#000000024,19,null,null,1993-10-14,UNITED STATES,null +25,Customer#000000025,7,null,null,1996-01-02,null,null +26,Customer#000000026,4,null,null,1996-12-01,null,null +27,Customer#000000027,7,null,null,1993-10-14,null,null +28,Customer#000000028,12,null,null,1996-01-02,null,null +29,Customer#000000029,13,null,null,1996-12-01,null,null +30,Customer#000000030,13,null,null,1993-10-14,null,null +31,Customer#000000031,21,null,null,1996-01-02,null,null +32,Customer#000000032,15,32,null,1996-12-01,null,null +32,Customer#000000032,15,32,null,1996-12-01,null,null +32,Customer#000000032,15,32,null,1996-12-01,null,null +32,Customer#000000032,15,32,null,1996-12-01,null,null +32,Customer#000000032,15,32,null,1996-12-01,null,null +32,Customer#000000032,15,32,null,1996-12-01,null,null +33,Customer#000000033,4,33,null,1993-10-14,null,null +33,Customer#000000033,4,33,null,1993-10-14,null,null +33,Customer#000000033,4,33,null,1993-10-14,null,null +33,Customer#000000033,4,33,null,1993-10-14,null,null +34,Customer#000000034,11,34,null,1996-01-02,null,null +34,Customer#000000034,11,34,null,1996-01-02,null,null +34,Customer#000000034,11,34,null,1996-01-02,null,null +35,Customer#000000035,22,35,null,1996-12-01,null,null +35,Customer#000000035,22,35,null,1996-12-01,null,null +35,Customer#000000035,22,35,null,1996-12-01,null,null +35,Customer#000000035,22,35,null,1996-12-01,null,null +35,Customer#000000035,22,35,null,1996-12-01,null,null +35,Customer#000000035,22,35,null,1996-12-01,null,null +36,Customer#000000036,15,36,null,1993-10-14,null,null +37,Customer#000000037,11,37,null,1996-01-02,null,null +37,Customer#000000037,11,37,null,1996-01-02,null,null +37,Customer#000000037,11,37,null,1996-01-02,null,null +38,Customer#000000038,14,38,null,1996-12-01,null,null +39,Customer#000000039,3,39,null,1993-10-14,null,null +39,Customer#000000039,3,39,null,1993-10-14,null,null +39,Customer#000000039,3,39,null,1993-10-14,null,null +39,Customer#000000039,3,39,null,1993-10-14,null,null +39,Customer#000000039,3,39,null,1993-10-14,null,null +39,Customer#000000039,3,39,null,1993-10-14,null,null +40,Customer#000000040,1,null,null,1996-01-02,null,null +41,Customer#000000041,0,null,null,1996-12-01,null,null +42,Customer#000000042,12,null,null,1993-10-14,null,null +43,Customer#000000043,1,null,null,1996-01-02,null,null +44,Customer#000000044,2,null,null,1996-12-01,null,null +45,Customer#000000045,2,null,null,1993-10-14,null,null +46,Customer#000000046,3,null,null,1996-01-02,null,null +47,Customer#000000047,18,null,null,1996-12-01,null,null +48,Customer#000000048,15,null,null,1993-10-14,null,null +49,Customer#000000049,0,null,null,1996-01-02,null,null +50,Customer#000000050,18,null,null,1996-12-01,null,null +51,Customer#000000051,14,null,null,1993-10-14,null,null +52,Customer#000000052,9,null,null,1996-01-02,null,null +53,Customer#000000053,10,null,null,1996-12-01,null,null +54,Customer#000000054,4,null,null,1993-10-14,null,null +55,Customer#000000055,12,null,null,1996-01-02,null,null +56,Customer#000000056,19,null,null,1996-12-01,null,null +57,Customer#000000057,13,null,null,1993-10-14,null,null +58,Customer#000000058,9,null,null,1996-01-02,null,null +59,Customer#000000059,9,null,null,1996-12-01,null,null +60,Customer#000000060,1,null,null,1993-10-14,null,null +61,Customer#000000061,13,null,null,1996-01-02,null,null +62,Customer#000000062,18,null,null,1996-12-01,null,null +63,Customer#000000063,20,null,null,1993-10-14,null,null +64,Customer#000000064,15,64,null,1996-01-02,null,null +65,Customer#000000065,10,65,null,1996-12-01,null,null +65,Customer#000000065,10,65,null,1996-12-01,null,null +65,Customer#000000065,10,65,null,1996-12-01,null,null +66,Customer#000000066,1,66,null,1993-10-14,null,null +66,Customer#000000066,1,66,null,1993-10-14,null,null +67,Customer#000000067,0,67,null,1996-01-02,null,null +67,Customer#000000067,0,67,null,1996-01-02,null,null +67,Customer#000000067,0,67,null,1996-01-02,null,null +67,Customer#000000067,0,67,null,1996-01-02,null,null +67,Customer#000000067,0,67,null,1996-01-02,null,null +67,Customer#000000067,0,67,null,1996-01-02,null,null +68,Customer#000000068,3,68,null,1996-12-01,null,null +68,Customer#000000068,3,68,null,1996-12-01,null,null +68,Customer#000000068,3,68,null,1996-12-01,null,null +68,Customer#000000068,3,68,null,1996-12-01,null,null +68,Customer#000000068,3,68,null,1996-12-01,null,null +68,Customer#000000068,3,68,null,1996-12-01,null,null +68,Customer#000000068,3,68,null,1996-12-01,null,null +69,Customer#000000069,13,69,null,1993-10-14,null,null +69,Customer#000000069,13,69,null,1993-10-14,null,null +69,Customer#000000069,13,69,null,1993-10-14,null,null +69,Customer#000000069,13,69,null,1993-10-14,null,null +69,Customer#000000069,13,69,null,1993-10-14,null,null +69,Customer#000000069,13,69,null,1993-10-14,null,null +70,Customer#000000070,3,70,null,1996-01-02,null,null +70,Customer#000000070,3,70,null,1996-01-02,null,null +70,Customer#000000070,3,70,null,1996-01-02,null,null +70,Customer#000000070,3,70,null,1996-01-02,null,null +70,Customer#000000070,3,70,null,1996-01-02,null,null +70,Customer#000000070,3,70,null,1996-01-02,null,null +71,Customer#000000071,16,71,null,1996-12-01,null,null +71,Customer#000000071,16,71,null,1996-12-01,null,null +71,Customer#000000071,16,71,null,1996-12-01,null,null +71,Customer#000000071,16,71,null,1996-12-01,null,null +71,Customer#000000071,16,71,null,1996-12-01,null,null +71,Customer#000000071,16,71,null,1996-12-01,null,null +72,Customer#000000072,8,null,null,1993-10-14,null,null +73,Customer#000000073,4,null,null,1996-01-02,null,null +74,Customer#000000074,11,null,null,1996-12-01,null,null +75,Customer#000000075,2,null,null,1993-10-14,null,null +76,Customer#000000076,8,null,null,1996-01-02,null,null +77,Customer#000000077,1,null,null,1996-12-01,null,null +78,Customer#000000078,5,null,null,1993-10-14,null,null +79,Customer#000000079,2,null,null,1996-01-02,null,null +80,Customer#000000080,4,null,null,1996-12-01,null,null +81,Customer#000000081,17,null,null,1993-10-14,null,null +82,Customer#000000082,3,null,null,1996-01-02,null,null +83,Customer#000000083,7,null,null,1996-12-01,null,null +84,Customer#000000084,19,null,null,1993-10-14,null,null +85,Customer#000000085,0,null,null,1996-01-02,null,null +86,Customer#000000086,15,null,null,1996-12-01,null,null +87,Customer#000000087,2,null,null,1993-10-14,null,null +88,Customer#000000088,14,null,null,1996-01-02,null,null +89,Customer#000000089,17,null,null,1996-12-01,null,null +90,Customer#000000090,14,null,null,1993-10-14,null,null +91,Customer#000000091,2,null,null,1996-01-02,null,null +92,Customer#000000092,12,null,null,1996-12-01,null,null +93,Customer#000000093,19,null,null,1993-10-14,null,null +94,Customer#000000094,5,null,null,1996-01-02,null,null +95,Customer#000000095,5,null,null,1996-12-01,null,null +96,Customer#000000096,7,96,null,1993-10-14,null,null +96,Customer#000000096,7,96,null,1993-10-14,null,null +97,Customer#000000097,16,97,null,1996-01-02,null,null +97,Customer#000000097,16,97,null,1996-01-02,null,null +97,Customer#000000097,16,97,null,1996-01-02,null,null +98,Customer#000000098,11,null,null,1996-12-01,null,null +99,Customer#000000099,9,null,null,1993-10-14,null,null +100,Customer#000000100,17,null,null,1996-01-02,null,null \ No newline at end of file
